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

Provide Oracle like database.url to support named instances

    XMLWordPrintable

Details

    • Enhancement
    • Resolution: Unresolved
    • Minor
    • 2.4-backlog
    • None
    • sqlserver-connector
    • None

    Description

      Feature request or enhancement

      This is a feature request

      Which use case/requirement will be addressed by the proposed feature?

      When using the sqlserver connector, the "database.port" property is a required field with the default value of 1433.  This is problematic when you have a named instance and the port is not configured with the default port.  There needs to be a way via the properties to indicate that the "database.port" property is not provided and to not default to the default port (1433).

      Implementation approach

      I have already implemented a solution for this and would like to commit for review.  The approach includes the definition of a new property ("database.noport") and the definition of a new URL Pattern that doesn't include the port in the jdbc connection string.  When creating the ConnectionFactory, if the "noport" property exists then a ConnectionFactory is created using the url pattern without the port in the string.  Otherwise, a ConnectionFactory is created using the existing url pattern.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              kyleyjexdev Kyley Jex (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated: