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:


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,



Leave a Reply to itpsdi Cancel reply

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

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

Facebook photo

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

Connecting to %s