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