File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Connection Timedout Error in WAS