Fail over in the Oracle JDBC driver

Apparently the Oracle JDBC driver supports fail over based on connection creation. I think it will support tnsnames parsing, but I’m not sure. This is supported though:

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)
(HOST=example.com)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)
(HOST=failover.example.com)(PORT=1521))
(FAILOVER=true)(LOAD_BALANCE=false)
(CONNECT_DATA=(SERVER=DEDICATED)(SID=foo)))

Not the nicest format, but you only have to do it once and it seems to work pretty well.

3 thoughts on “Fail over in the Oracle JDBC driver

  1. Great share but i have a question about failover definition.

    What will i have to define when i want to describe 2 different SID for failover case ???
    In your example there is only one SID (SID=foo)

    Best Regards,

    Alper.

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s