aspose file tools*
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
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.
 
Don't get me started about those stupid light bulbs.
 
subject: the problem of connection pool
 
Similar Threads
Testing Connection Pool in Weblogic6.1
creating a custom tomcat connection pool from another location
What is the concept of wrapper for JDBC
Difference between close & null with regards to connection
How to open a connection pool to a database?