B4J Question How to handle sql server pool connection timeout

[fabton1963]

Erel say, The correct pattern for working with a connection taken from the pool is:

Dim sql As SQL = pool.GetConnection
Try
'work with sql
Catch
 'handle failure
End Try
sql.Close

But when the following error occurs:

`java.lang.RuntimeException: java.sql.SQLException: An attempt by a client to checkout a Connection has timed out. ... ... Caused by: com.mchange.v2.resourcepool.TimeoutException: A client timed out while waiting to acquire a resource from com.mchange.v2.resourcepool.BasicResourcePool@67f639d3 -- timeout at awaitAvailable()`,

my application is no longer able to communicate with the database or restore the connection pool. From this point on, every attempt to access the database generates an error until I restart the application.
The server application still run with unpredictable effetcs and I'll prefere a crash of java that I'm able to handle fixing trouble and restarting the service.

 

[tchart]

See here for some answers

jSQL - ability to set query timeout

As per title, could you consider adding the ability to set the timeout for SQL queries in jSQL Background... I have a jServer based data exploration tool that contains a lot of data, yesterday while testing I got this error which I hadnt seen before (this was after doing some load testing the...

www.b4x.com