JDBC with mulitple instances of database

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • gbhatti
    #1

    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
    Tags: None
    • sybrandb@yahoo.com
      #2
      Re: JDBC with mulitple instances of database

      gbhatti <member43992@db forums.comwrote in message news:<3477902.1 066098997@dbfor ums.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

        Comment

        • gbhatti
          #3
          Re: JDBC with mulitple instances of database


          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

            Comment

            • hrishy
              #4
              Re: JDBC with mulitple instances of database

              Hi

              Sarch for Transperent Application Failover (TAF)at tahiti.oracle.c om
              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

                Comment

                Previous template Next
                Working...