Erel say, The correct pattern for working with a connection taken from the pool is:
But when the following error occurs:
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.
B4X:
Dim sql As SQL = pool.GetConnection
Try
'work with sql
Catch
'handle failure
End Try
sql.CloseBut when the following error occurs:
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.