aspose file tools*
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
Author

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

MONZY THARIAN
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
Monzy


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="http://javarecon.tripod.com" target="_blank" rel="nofollow">http://javarecon.tripod.com</a>
MONZY THARIAN
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

regards
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 -
http://www.javaworld.com/javaworld/jw-10-2000/jw-1027-pool.html
Kyle Brown
author
Ranch Hand

Joined: Aug 10, 2001
Posts: 3879
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


Kyle Brown, Author of Persistence in the Enterprise and Enterprise Java Programming with IBM Websphere, 2nd Edition
See my homepage at http://www.kyle-brown.com/ for other WebSphere information.
Dilip kumar
Ranch Hand

Joined: Oct 16, 2000
Posts: 360
Hello,

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.
 
Don't get me started about those stupid light bulbs.
 
subject: Help!!!!!! how to set Connection Pooling
 
Similar Threads
Struts2.0 database connection design pattern
connection pooling clarification
Connection Pooling Question
Communication between two applications
Connection Pooling