Skip to Main Content
Forums

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

JDBC to connect DB2 Database during Oracle failover

843859Aug 29 2008 — edited Aug 29 2008
Hi All,

We have both Oracle and DB2 database. During the Oracle DB failover, i need to connect to DB2 database using JDBC.

I would like to have suggestions regarding the approach which i need to handle.

Should it be like this:

1) Connect to oracle DB
2) If exception occurs (in catch block), implement code to connect DB2 database.

In this case again after the failover it has to return back to oracle DB.

Is the approach is right or should i implement a different mechanism for this and is there any JDBC driver to connect DB2 database?

Please suggest

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 26 2008
Added on Aug 29 2008
#java-database-connectivity-jdbc
16 comments
291 views