Hi, Currently, flink-connector-jdbc doesn't support MS Server dialect. Only MySQL and Postgres are supported.
Best, Jark On Tue, 8 Dec 2020 at 01:20, aj <ajainje...@gmail.com> wrote: > Hello , > > I am trying to create a table with microsoft sql server using flink sql > > CREATE TABLE sampleSQLSink ( > id INTEGER > message STRING, > ts TIMESTAMP(3), > proctime AS PROCTIME() > ) WITH ( > 'connector' = 'jdbc', > 'driver' = 'com.microsoft.sqlserver.jdbc.SQLServerDriver', > 'url' = 'jdbc:sqlserver://samplecustsql.database.windows.net:1433 > ;database=customerdb', > 'username'= > 'password'= > 'table-name' = > ); > > > select * from sampleSQLSink > > > I am getting this error > > ERROR] Could not execute SQL statement. Reason: > java.lang.IllegalStateException: Cannot handle such jdbc url: > jdbc:sqlserver://samplecustsql.database.windows.net:1433 > ;database=customerdb > > > Can somedoby help what is wrong. > > I am using microsoft jdbc driver. >
