aspose file tools*
The moose likes Servlets and the fly likes How to retry Oracle db connection with different server? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Java » Servlets
Bookmark "How to retry Oracle db connection with different server?" Watch "How to retry Oracle db connection with different server?" New topic
Author

How to retry Oracle db connection with different server?

Ben Hen
Greenhorn

Joined: Mar 27, 2012
Posts: 5
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";

My connection:



I've tried if (conn == null) but it doesn't work.

Thanks!
Stefan Evans
Bartender

Joined: Jul 06, 2005
Posts: 1016
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 JDBC DataSource.
The standard approach in most java apps these days is to use a JNDI Datasource to get connections from rather than the DriverManager.



 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to retry Oracle db connection with different server?
 
Similar Threads
Savepoints and transactions
Connection Leaks
How To Access Objects Returned From A Helper/Utility Class?
how to give the real connection back to the pool
close sql connection in finally block