Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Connection Timedout Error in WAS

 
Balakrishnan Nagarajan
Greenhorn
Posts: 20
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Dear All,

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
at com.ibm.ws.rsadapter.AdapterUtil.toSQLException(AdapterUtil.java:1524)

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,

Regards,
Bala N.

 
Balakrishnan Nagarajan
Greenhorn
Posts: 20
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

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.


Thanks,
Bala N.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic