• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

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

 
Ranch Hand
Posts: 63
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Ranch Hand
Posts: 34
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
author
Posts: 3892
5
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Ranch Hand
Posts: 360
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic