Meaningless Drivel is fun!
The moose likes Websphere and the fly likes Help!!!!!!  how to set Connection Pooling Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Websphere
Bookmark "Help!!!!!!  how to set Connection Pooling" Watch "Help!!!!!!  how to set Connection Pooling" New topic

Help!!!!!! how to set Connection Pooling

Ranch Hand

Joined: Feb 21, 2001
Posts: 63
Dear All,
Can any one suggest how the connection pooling works. I am using connection pooling of Websphere to connect to the database , but i am getting Connection.Timeout error even though i have specified Number of Connections Maximum connection pool size to 200.I hardly have five concurrent users.I have restart my admin server every time whene ever connection pool error occurs
I am properly closing all connections in my servlets
Kindly suggest what is wrong.
Thanks in Advance

Think Big . So shall you become big.
Andy Rodriguez
Ranch Hand

Joined: Aug 30, 2001
Posts: 34
Connection timeout indicates that the app has waited for a certain amount of time specified in the CONN_TIMEOUT param , (default is 3min i think )and has not got a connection back from the pool.
Your option 1) would be to increase the CONN_TIMEOUT param .
2) check the transaction logic in your biz layer : servlet ?
3) where are you closing the connections in the servlet ? hope not in the finalize() ? and also note to make sure that you havent used the connection obj as a static object in the app
Oh , are you using WAS4.0 ? WAS 4.0 follows jdbc2.0 spec's .
[ January 03, 2002: Message edited by: Seymour Skinner ]

// <a href="" target="_blank" rel="nofollow"></a>
Ranch Hand

Joined: Feb 21, 2001
Posts: 63
Skinner ,
yes buddy, i already doing exactly what u have told me , but still it is giving me connection time out , i have increased the connection timeout parameter to 200 .
Can u tell me How to check how many connections i currently connected

Monzy :roll:
Andy Rodriguez
Ranch Hand

Joined: Aug 30, 2001
Posts: 34
Hope you have the jndi lookup in the servlet's init() .
2) Increasing the connection time out param to 200 is to increase the default value of 180 - 3min by 20 sec.
Try disabling the timeout param by setting it to zero.( ofcourse for debugging purposes only )
3) I still think you have issues with your servlet logic or with user info /password to connect to your database.
Try this link for more info on conn pooling -
Kyle Brown
Ranch Hand

Joined: Aug 10, 2001
Posts: 3892
You can use the Resource Analyzer (ra.bat) tool to find out how many connections in a pool are currently being utilized. Check the documentation for information on RA and it should help you out.

Kyle Brown, Author of Persistence in the Enterprise and Enterprise Java Programming with IBM Websphere, 2nd Edition
See my homepage at for other WebSphere information.
Dilip kumar
Ranch Hand

Joined: Oct 16, 2000
Posts: 360

Somewhere I read that the default period of time that an unallocated connection can remain in the database connection pool is 2000 seconds. Is it specific to WSAD or specific to service provider ?

Thanks much.
I agree. Here's the link:
subject: Help!!!!!! how to set Connection Pooling
It's not a secret anymore!