JDBC with mulitple databases

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
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|||"gbhatti" <member43992@.dbforums.com> wrote in message
news:3477901.1066098913@.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