This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes Connection Hangs in the Production System Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Connection Hangs in the Production System" Watch "Connection Hangs in the Production System" New topic
Author

Connection Hangs in the Production System

Rahul Shinde
Greenhorn

Joined: Jan 29, 2002
Posts: 7
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
 
wood burning stoves
 
subject: Connection Hangs in the Production System
 
Similar Threads
Connection Pool Dirty Connection?
Best way to track down connection leak
OracleConnectionCacheManager refresh problem
what will happen if we access more than the maximum pool size
Creating JavaMail session pool