wood burning stoves 2.0*
The moose likes JDBC and the fly likes the problem of connection pool Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "the problem of connection pool" Watch "the problem of connection pool" New topic
Author

the problem of connection pool

gardliu
Greenhorn

Joined: Jan 15, 2002
Posts: 8
I develope a logistic system using connection pool.now It is online.But one day I can't login on!The only way is restart the webserver to initial the connection pool,then I can login.I have found the connections of the connection pool are bad instances,the test of a bad connection have waste five-eight minutes.Can you give me some advise and tell me the cause of bad connection instances!Thanks very much!
Adam Hardy
Ranch Hand

Joined: Oct 09, 2001
Posts: 565
Hi Garde again,
I remember vaguely someone saying that this problem can be caused by the database automatically closing connections from its side when they are not being used for a certain period of time.

Adam


I have seen things you people would not believe, attack ships on fire off the shoulder of Orion, c-beams sparkling in the dark near the Tennhauser Gate. All these moments will be lost in time, like tears in the rain.
 
 
subject: the problem of connection pool
 
Similar Threads
What is the concept of wrapper for JDBC
creating a custom tomcat connection pool from another location
How to open a connection pool to a database?
Testing Connection Pool in Weblogic6.1
Difference between close & null with regards to connection