if "ORACLE not available" how to refresh connection pool

Hi,

Sometimes i'm getting this error "ORACLE not available" , but the connection pool was not refreshigng.

so after the oracle connection comes, my program is using old connection in pool and not picking the data from the database, until i restart the tomcat server.

can anyone give better solution rather than restarting the server.

thanks in advance,

regards,

NeelimaSridhar

[421 byte] By [Neelima.Sridhara] at [2007-11-27 5:45:31]
# 1
i got the answerHave to specify the query 搒elect 1 from dual?in validation query column.
Neelima.Sridhara at 2007-7-12 15:27:20 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...