debezium / debezium/dbz

Dynamic port support for SQL Server [DBZ-2328]

Open
#346 0 comments 0 reactions 0 assignees View on GitHub
component/sqlserver-connector migrated-from-jira type/enhancement
Dominant language
HTML
Stars
6
Forks
8
Avg merge
2d 19h
Merged PRs (30d)
1

Description

Migrated from [DBZ-2328](https://issues.redhat.com/browse/DBZ-2328)

There are two forms of JDBC URL for connecting to MSQSQL
1. Using hotname+port
2. Using hostname/instancename (Dynamic Port)

Example here:
[https://docs.microsoft.com/en-us/sql/connect/jdbc/building-the-connection-url?view=sql-server-2017]

Option 2 is used to support scenarios where the port number may change (in this prospects case, SQL Server runs as a 6 node failover cluster running 12 instances).

Debezium does not support option 2:
Line 64 from here: [https://github.com/debezium/debezium/blob/master/debezium-connector-sqlserver/src/main/java/io/debezium/connector/sqlserver/SqlServerConnection.java]

 

Could SQL Server connector support hostname/instancename (Dynamic Port)?

Contributor guide

Open the contributing guide

Research direction

Start in debezium-connector-sqlserver/src/main/java/io/debezium/connector/sqlserver/SqlServerConnection.java at the referenced line, then compare the hostname+port and hostname/instancename JDBC URL forms in the linked Microsoft documentation. Done means the SQL Server connector supports connecting through the dynamic-port hostname/instancename form.

Written by the indexing model from the issue text.

Assessment

Tech stack
java
Domain
databases
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.