Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-2859

Support TNS Names and full RAC connection strings

XMLWordPrintable

    • Icon: Enhancement Enhancement
    • Resolution: Done
    • Icon: Major Major
    • 1.4.0.Final
    • None
    • oracle-connector
    • None
    • False
    • False
    • Undefined

      Right now the Oracle connector forces us to use a hostname and port number to establish a connection to Oracle. It would be nice to have support to explicitly pass the desired JDBC URL connection which will be very handy to support connection using TNS names and RAC cluster strings.

      This would provide easy support to connection strings like: 

      "jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCPS)(HOST=<hostname>)(PORT=<port>))"
    +"(CONNECT_DATA=(SERVICE_NAME=<servicename>)))"

      or 

      "jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=OFF)(FAILOVER=ON)"
    +"(ADDRESS=(PROTOCOL=TCP)(HOST=<hostname1>)(PORT=<port1>))"
    +"(ADDRESS=(PROTOCOL=TCP)(HOST=<hostname2>)(PORT=<port2>)))"
    +"(CONNECT_DATA=SERVICE_NAME=<servicename>)(SERVER=DEDICATED)))"

      among others.

       

       

              ccranfor@redhat.com Chris Cranford
              martper2 Martin Perez (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: