how shoud i deal with dead connections in connection pool?

[williamwan]

hello,

the connections in my connection pool(datasource) are all dead because of some reason,how can i deal with it?can i update the connections in my
code?

first quesion:

can i update the dead connections in my code except from jmx-console?

and how?

second quetion:

I notice the check-valid-connection-sql configuration,it will check the

connection before hand it out,but i don't know if all connections are

dead,whether it will recreate all the connections?i want to know how

check-valid-connection-sql work,whether when it get a dead connection

it recreate one or only look for another one?

many thanks

your williamwan

[adrian.brock]

Both. It looks for another one, if there are no more or they all fail it a creates a new one.

[williamwan]

it really work

thanks to Adrian Brock


williamwan

[williamwan]

it really work

thanks to Adrian Brock


williamwan