Hi All I have Tomcat 4.0 along with Oracle as DB in our prod system. For JDBC Connections, we have implemented our own pool mechanism. Incase there are more requests than the size of the pool, we create a new connection and add it to the pool. Also the pool always checks whether the Connection is OK or not while giving it to the requestor. At peak times(around 5-20 requests/min), we found that the application fail to get the database connection. There is no Exception or any stack trace The connection just hangs and hence all the applications accessing it. We have increased the MAXIMUM CURSORS of the database Also the Tomcat Thread Pool size is large enough. We have to restart our Web Server to solve this problem. But after say 6-7 hours, the same problem occurs We have maintained the pool size to 80 with initial of 10 connections I search on the Net for this problem and found few people having exactly the same problem But no where could i find the solution for this please throw some light soon regards Rahul
0
