Good morning,
we are using de Access driver (AccessJDBC_4.0.jar) to access to remote data. We have just downloaded the last version of the drivers.
Our software access to remote data constantly and, though not always, quite often we have the next exception:
"
...
2009-12-18 12:40:43[ERROR][TelevisUtilBase.getDispositivosInstalacion()] Error 1 al recuperar los dispositivos de GMAMPOSTA
java.sql.SQLException: Timeout Interrupted Exception: beyond 1000 msecs to open a database of setup.
at com.hxtt.global.SQLState.SQLException(Unknown Source)
at com.hxtt.sql.access.av.a(Unknown Source)
at com.hxtt.sql.access.r.a(Unknown Source)
at com.hxtt.concurrent.x.a(Unknown Source)
at com.hxtt.sql.access.bb.a(Unknown Source)
at com.hxtt.sql.access.ae.a(Unknown Source)
at com.hxtt.sql.bp.if(Unknown Source)
at com.hxtt.sql.di.a(Unknown Source)
at com.hxtt.sql.di.a(Unknown Source)
at com.hxtt.sql.bp.a(Unknown Source)
at com.hxtt.sql.bp.a(Unknown Source)
at com.hxtt.sql.ah.a(Unknown Source)
at com.hxtt.sql.ah.a(Unknown Source)
at com.hxtt.sql.ah.executeQuery(Unknown Source)
at com.systemfrost.cc.TelevisUtilBase.getDispositivosInstalacion(TelevisUtilBase.java:182)
at com.systemfrost.cc.TelevisUtilMac.getDispositivosInstalacion(TelevisUtilMac.java:39)
at com.systemfrost.cc.LectorCambiosCfg.run(LectorCambiosCfg.java:228)
Timeout Interrupted Exception: beyond 1000 msecs to open a database of setup.
Error Code:721152
SQL State:S1T00
java.sql.SQLException: Timeout Interrupted Exception: beyond 1000 msecs to open a database of setup.
at com.hxtt.global.SQLState.SQLException(Unknown Source)
at com.hxtt.sql.access.av.a(Unknown Source)
at com.hxtt.sql.access.r.a(Unknown Source)
at com.hxtt.concurrent.x.a(Unknown Source)
at com.hxtt.sql.access.bb.a(Unknown Source)
at com.hxtt.sql.access.ae.a(Unknown Source)
at com.hxtt.sql.bp.if(Unknown Source)
at com.hxtt.sql.di.a(Unknown Source)
at com.hxtt.sql.di.a(Unknown Source)
at com.hxtt.sql.bp.a(Unknown Source)
at com.hxtt.sql.bp.a(Unknown Source)
at com.hxtt.sql.ah.a(Unknown Source)
at com.hxtt.sql.ah.a(Unknown Source)
at com.hxtt.sql.ah.executeQuery(Unknown Source)
at com.systemfrost.cc.TelevisUtilBase.getDispositivosInstalacion(TelevisUtilBase.java:182)
at com.systemfrost.cc.TelevisUtilMac.getDispositivosInstalacion(TelevisUtilMac.java:39)
at com.systemfrost.cc.LectorCambiosCfg.run(LectorCambiosCfg.java:228)
...
"
How could we solve this problem?
Thank you very much,
Kiko.
|
>How could we solve this problem?
Try lockTimeout connection with a bigger value.
|
I did it using the method setQueryTimeout( seconds ) for my Statement Object.
I setted the timeout to 25 seconds, but I still had the message.
"java.sql.SQLException: Timeout Interrupted Exception: beyond 1000 msecs to open a database of setup. "
I saw "1000 msecs" instead of "25000 msecs" so I though it was not the problem.
And I printed out the times and, although I had setted the time to 25 secs., the error still was happening after 1 second.
The method setQueryTimeout() is the correct way to lockTimeout connection, isnt it?
Thank you very much.
|
>I did it using the method setQueryTimeout( seconds ) for my Statement Object.
That method hasn't relation with lockTimeout connection property now.
|
|
Thank you very much. I've solved the problem setting the lockTimeout connection property in the correct way.
|
Main
webmaster@hxtt.com