Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v7.1
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Cobol v5.0
  HXTT DBF v7.1
  HXTT Excel v6.1
  HXTT Json v1.0
  HXTT Paradox v7.1
  HXTT PDF v2.0
  HXTT Text(CSV) v7.1
  HXTT Word v1.1
  HXTT XML v4.0
Offshore Outsourcing
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
   
   
   
Heng Xing Tian Tai Lab of Xi'an City (abbr, HXTT)

HXTT ACCESS
Timeout Interrupted Exception
Michael Peters
2018-09-06 06:50:18
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
Re:Timeout Interrupted Exception
HXTT Support
2018-09-06 11:07:58
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
Re:Re:Timeout Interrupted Exception
Michael Peters
2018-09-07 00:25:15
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


Re:Re:Re:Timeout Interrupted Exception
HXTT Support
2018-09-07 05:20:34
What's your full jdbc url and error message?
Re:Re:Re:Re:Timeout Interrupted Exception
Michael Peters
2018-09-07 07:29:57
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 :)

Re:Re:Re:Re:Re:Timeout Interrupted Exception
HXTT Support
2018-09-07 15:41:29
It's a version before 5 years. Maybe you should consider renewing your license.

Search Key   Search by Last 50 Questions




Google
 

Email: webmaster@hxtt.com
Copyright © 2003-2019 Heng Xing Tian Tai Lab of Xi'an City. | All Rights Reserved. | Privacy | Legal | Refund | Sitemap