Details
-
Feature Request
-
Resolution: Unresolved
-
Major
-
None
-
None
-
None
-
0
-
0%
Description
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)?