Sometimes, when a query return maby rows, I receive this errors ( here part of my log ):
09-11-2010 11:56:33 >> dbuFox consultaTabla() : Timeout Interrupted Exception: beyond 30000 msecs to get result for a remote request, but that request should have been executed by remote server.
09-11-2010 11:56:33 >> dbuFox ErrorServidor
09-11-2010 11:56:33 >> Error al conectar : java.lang.NullPointerException
09-11-2010 11:57:30 >> dbuFox consultaTabla() : Timeout Interrupted Exception: beyond 30000 msecs to get result for a remote request, but that request should have been executed by remote server.
09-11-2010 11:57:30 >> dbuFox ErrorServidor
09-11-2010 11:57:30 >> Error al conectar : java.lang.NullPointerException
09-11-2010 11:58:08 >> dbuFox consultaTabla() : Remote connection has been closed.
09-11-2010 11:58:08 >> dbuFox ErrorServidor
All clients will become very slow and I need to reset stations.....the question is why this error occurs? (Remote connection has been closed).
Thanks
|
What's your sql results slow?
|
All SELECT.....in all clients......
|
Soryy for missed that thread. You can use lockTimeout connection property to set a longer timeout. The latest package will use 300000ms (5 minutes) as defaut timeout value for remote connection.
|