Morning all. I'm looking at the <JDBC connector> (...
# randomh
Hector Rios
03/14/2023, 10:08 AMMorning all. I'm looking at the JDBC connector (Flink 1.15) for TableAPI and see the following at the top of the page.
The JDBC connector allows for reading data from and writing data into any relational databases with a JDBC driver.However, the dependencies section mentions that you need to include the JDBC driver as a dependency and lists the currently supported drivers. I'm confused because the list of supported drivers conflicts with the statement above that the connector works with any database with a JDBC driver. Specifically, I'm curious about SQL Server 2019? It has a JDBC driver but is not on the list of supported drivers. Does that mean that SQL Server is not supported by the connector?
m
Martijn Visser
03/14/2023, 10:09 AMIt’s a good remark
Martijn Visser
03/14/2023, 10:09 AMThere needs to be a SQL dialect implemented when you use the JDBC driver
Martijn Visser
03/14/2023, 10:10 AMWhich isn’t the case for SQL Server
Martijn Visser
03/14/2023, 10:11 AMAh I’m wrong on my last statement: it is supported via https://issues.apache.org/jira/browse/FLINK-14101
h
Hector Rios
03/14/2023, 10:14 AMHi Martin, thank you for chiming in so quickly. Based on that issue you linked to, what does it mean?
m
Martijn Visser
03/14/2023, 10:15 AMYeah sorry, it's a bit confusing 🙂
Martijn Visser
03/14/2023, 10:15 AMSupport for MSSQL server in the JDBC connector has been added, but has not yet been released. It will be available in the next release of the JDCB connector (3.1.0) which is scheduled to be released in the next couple of weeks, after Flink 1.17 is made available
h
Hector Rios
03/14/2023, 10:17 AMAh, I see. Thank you for the update. Out of curiosity, is there a place I can navigate to see the status of the connector?