How to retry Oracle db connection with different server?
Joined: Mar 27, 2012
I have 2 servers - a primary and a backup. When the first connection fails, how can I get it to try the second server?
dbServer1 = "server1";
dbServer2 = "server2";
I've tried if (conn == null) but it doesn't work.
Joined: Jul 06, 2005
Well there are a couple of scenarios
1 - Connection cannot be established and it throws a SQLException. You need to catch that exception, and then "handle" it by trying the fallback server.
2 - Connection succeeds. Taking a look at the API for java.sql.Connection maybe as well as the test for null, you could try connection.isValid() ?
This sort of logic might be better encapsulated in a java class, or even a JDBCDataSource.
The standard approach in most java apps these days is to use a JNDI Datasource to get connections from rather than the DriverManager.