I'm looking into this for Raimund Tittes (Invextra) in Cologne/Germany.
He runs HXTT 5.1 for Access in combination with Lucee (a free version of Coldfusion) on a Windows server.
A simple SQL statement results in "Timeout Interrupted Exception: beyond 1000 msecs".
I am not sure how to set the timeout higher for HXTT in Lucee - do you have an idea?
thank you
-Michael
|
What's your jdbc url?
For instance, you can use jdbc:access:////yourdatadir/youDbFile?lockTimeout=20000
lockTimeout? To specify Access driver's timeout in milliseconds to wait until other processes or Access applications released record lock or table lock. 0 means a default value, and <0 means no wait. Default: 1000
|
thank you, I could now successfully store the "locktimeout=20000" in the connection string (I had not used a "?" before it but a ";" and that didn't work).
But although I have set it to 20000 now, I get the same error message:
"Timeout Interrupted Exception: beyond 1000 msecs" - that is a HXTT error, right?
-Michael
|
What's your full jdbc url and error message?
|
URL is
jdbc:access:/d:/inetdata/Portfolio97_NEU.mdb?lockTimeout=20000
Error is
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
do you need the full stack trace? I don't think that would help :)
|
It's a version before 5 years. Maybe you should consider renewing your license.
|