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

Support TNS Names and full RAC connection strings

    XMLWordPrintable

Details

    Description

      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.

       

       

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: