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.