This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes Websphere and the fly likes Connection Timedout Error in WAS Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Products » Websphere
Bookmark "Connection Timedout Error in WAS" Watch "Connection Timedout Error in WAS" New topic
Author

Connection Timedout Error in WAS

Balakrishnan Nagarajan
Greenhorn

Joined: Jan 16, 2009
Posts: 20
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

Joined: Jan 16, 2009
Posts: 20
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.
 
Don't get me started about those stupid light bulbs.
 
subject: Connection Timedout Error in WAS
 
Similar Threads
Application hosted on Tomcat has datasource DBCP issues
connection pool problem
JDBC and transactions
MS SQL Server socket problem
JDBC connection pool