the problem of connection pool

Greenhorn

Posts: 8

posted 21 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

Posts: 567

posted 21 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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.

With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.