Timeout with HXTT Access driver


#1

Does anyone use old Access mdb databases on a 64bit Windows 2012 server? my customer does, using a Chinese HXTT driver. It works mostly but some queries (simple queries) produce a lock timeout error after 2 or 3 seconds that has nothing to do with the request timeout (and there are no ldb files so it doesn’t seem to be Access related) - the error seems to be related to the driver. The HXTT folks told me to add a locktimeout to the connection string (I set it to 20000) but the same 1000 msec error comes up again. I don’t know what I can do now. (Yes I agree, adding cflock might help, and using real databases would be better, but my customer says that everything worked fine as it is with Coldfusion, and should theoretically work with Lucee.) Any ideas?

-Michael

database connection string:
jdbc:access:/d:/inetdata/myaccessdb.mdb?lockTimeout=20000

error message:
Timeout Interrupted Exception: beyond 1000 msecs.
DatabaseVersion HXTT Access Version 5.1
DriverName HXTT Access JDBC Driver – A Type 4 JDBC4.0 driver for MS Access 95/97/2000/XP/2002/2003/2007/2010
DriverVersion Version 5.1