Two Laptop Bag
The moose likes JDBC and Relational Databases 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
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "the problem of connection pool" Watch "the problem of connection pool" New topic

the problem of connection pool


Joined: Jan 15, 2002
Posts: 8
I develope a logistic system using connection 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: 567
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.


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.
I agree. Here's the link:
subject: the problem of connection pool
jQuery in Action, 3rd edition