*
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 The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript 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: 566
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.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: the problem of connection pool