468,250 Members | 1,600 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,250 developers. It's quick & easy.

JDBC with mulitple instances of database


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 19 '05 #1
3 2296
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?

Kind regards


This functionality is available in sqlnet as transparent application
failover (TAF). If you use the ordinary jdbc driver you should be able
to use this without problem, providing you do your homework with
respect to standby databases and TAF and don't start experimenting
'somewhere'

Sybrand Bakker
Senior Oracle DBA
Jul 19 '05 #2

Thank you very much.

Could you elaborate bit more on "my homework". A link to more
information would suffice?

regards
--
Posted via http://dbforums.com
Jul 19 '05 #3
Hi

Sarch for Transperent Application Failover (TAF)at tahiti.oracle.com
or in the documentation CD supplied by oracle.This functionality is
built into the net8 drivers as far as i know if you use thick JDBC
drivers the problem should be trivial.

You gotta understand what TAF does it only does sleect failover.So if
your transaction fails in the middle it will connect you to the next
redundant database and starts your transaction all over again..This is
imp.as failover does not mean that your transaction will continue
automagically from where it failed.

regards
Hrishy
Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Nils Valentin | last post: by
2 posts views Thread by gbhatti | last post: by
oll3i
5 posts views Thread by oll3i | last post: by
1 post views Thread by Stefano Gibellini | last post: by
reply views Thread by kermitthefrogpy | last post: by
reply views Thread by zattat | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.