Look up ping query in the developers manual. It will validate the query before it uses it.

On Apr 14, 2009, at 8:27 PM, "yhliu" <[email protected]> wrote:

I got a problem that the program will throw close connection exception when the DB server(oracle 10G) shut down and it is unforeseeable, the worse is it will not connect the DB server in a successful manner again when the DB server resurged. After discuss with my colleagues, the point is how can I reconnect the DB server or get new connection from Pool? and what the use's of SqlMapTransactionManager.setUserConnection(...) , Can I use this method to get new connection with DB server?
Thx for any help!

2009-04-15
yhliu

Reply via email to