Here is the error message I got from server:
(TimeoutException) com.mchange.v2.resourcepool.TimeoutException: A client timed out while waiting to acquire a resource from com.mchange.v2.resourcepool.BasicResourcePool@2959535c -- timeout at awaitAvailable()
After that error, I have to forced shutdown the jar file on server and restarted again to made connection normal again.
The client were Android application.
Is there a way to catch this error on server side so that when error reappeared again the app on server can automatically restarted ?
Has your traffic increased? Have the queries changed? One of the issues could be that your pool size is to small. The default pool size for c3p0 is 15.
Has your traffic increased? Have the queries changed? One of the issues could be that your pool size is to small. The default pool size for c3p0 is 15.
No change in queries, but there were traffic increased when error occurred.
I always close connection as soon as possible, and there was data synchronization between Android device and server. This process only happen when there were master data changes in server side and it will uploaded thousand of records from server to Android device.
jRDC2 is pretty good about closing connections as fast as possible, but the sync may saturate the pool. I would definitely try increasing the pool size. Note: my assumption here is that the Firebird dB uses an unmodified jRDC2 that allows for pool usage (unlike SQLite).
jRDC2 is pretty good about closing connections as fast as possible, but the sync may saturate the pool. I would definitely try increasing the pool size. Note: my assumption here is that the Firebird dB uses an unmodified jRDC2 that allows for pool usage (unlike SQLite).