Re: Error while connecting with MSSQL server

2020-12-09 Thread aj
Sure thanks Flavio, will check it out On Wed, Dec 9, 2020, 16:20 Flavio Pompermaier wrote: > I issued a PR some time ago at https://github.com/apache/flink/pull/12038 but > Flink committers were busy in refactoring that part..I don't know if it is > still required to have that part into the jdbc

Re: Error while connecting with MSSQL server

2020-12-09 Thread Flavio Pompermaier
I issued a PR some time ago at https://github.com/apache/flink/pull/12038 but Flink committers were busy in refactoring that part..I don't know if it is still required to have that part into the jdbc connector Flink code of if using the new factories (that use the java services) you could register

Re: Error while connecting with MSSQL server

2020-12-07 Thread Jark Wu
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 wrote: > Hello , > > I am trying to create a table with microsoft sql server using flink sql > > CREATE TABLE sampleSQLSink ( > id INTEG

Error while connecting with MSSQL server

2020-12-07 Thread aj
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', 'u