Dynamic port support for SQL Server [DBZ-2328]
- 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
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