Yesterday we have faced connection issue in WAS server. When we check the "log" file, found the following,
ERROR JdbcDataAccess - SQLException while creating connection
com.ibm.websphere.ce.cm.ConnectionWaitTimeoutException: Connection not available, Timed out waiting for 946976
I have tried with googling regarding this error message and got to know,
1. Might be because of the Connection pooling
2. NOT closing the jdbc connections properly.
But, the application is working for a long time (probably 3 years). We also do the periodic restart to avoid some issues at business hours.
After 5-10 minutes, the application started working normally with No action from our side.
May i know, the exact reason and how to resolve these kinda issues in future.
Thanks in advance,
posted 4 years ago
I had googling on this issue and found the following,
1. Increasing the Connection Pool size (by default its 10. But 10-30 will give better performance)
2. Increasing the connection timed out setting (by default its 180. We can have upto 300 to have better performance)
If you found more solution, please do intimate me.