• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
MONZY THARIAN
Ranch Hand
Posts: 63
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Andy Rodriguez
Ranch Hand
Posts: 34
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
MONZY THARIAN
Ranch Hand
Posts: 63
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 34
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 3892
5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Dilip kumar
Ranch Hand
Posts: 360
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic