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
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 ]
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:
Think Big . So shall you become big.
posted 17 years ago
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