By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,077 Members | 1,790 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,077 IT Pros & Developers. It's quick & easy.

JDBC with mulitple databases

P: n/a

Dear all,

Our application needs a bit of database redundancy.

Our application only accesses database for reading purposes.

We want to have two databases in separate machines. Incase one database
server dies the application should automatically extract data from the
other server.

Is there any JDBC driver available so that it can detect failure in the
main database server and then tries to extract data from the standby
database server?

Kind regards
--
Posted via http://dbforums.com
Jul 20 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a


gbhatti wrote:
Dear all,

Our application needs a bit of database redundancy.

Our application only accesses database for reading purposes.

We want to have two databases in separate machines. Incase one database
server dies the application should automatically extract data from the
other server.

Is there any JDBC driver available so that it can detect failure in the
main database server and then tries to extract data from the standby
database server?

Kind regards

Not for SQLServer, but oracle has something like that if you have
oracle clustered DBMSes. However, it's not hard to write code
that will react to connectivity failure with one DBMS by connecting
to an alternate...

Joe Weinstein at BEA

--
Posted via http://dbforums.com


Jul 20 '05 #2

P: n/a

"gbhatti" <me*********@dbforums.com> wrote in message
news:34****************@dbforums.com...

Dear all,

Our application needs a bit of database redundancy.

Our application only accesses database for reading purposes.

We want to have two databases in separate machines. Incase one database
server dies the application should automatically extract data from the
other server.

Is there any JDBC driver available so that it can detect failure in the
main database server and then tries to extract data from the standby
database server?

Not that I'm aware of. Typically this is done with SQL Enterprise in a
clustered format.

It is possible to encode it at the client level though also. But I'm not
aware of any JDBC driver that does it.



Kind regards
--
Posted via http://dbforums.com

Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.