I have the kafka-connect with timestamp+increment with database Firebird, but this error:
However I got an error:
[2024-02-05 14:46:42,888] ERROR [firebird|task-0] Failed to get current time from DB using Generic and query 'SELECT CURRENT_TIMESTAMP' (io.confluent.connect.jdbc.dialect.GenericDatabaseDialect:567)
java.sql.SQLSyntaxErrorException: Dynamic SQL Error; SQL error code = -104; Unexpected end of command - line 1, column 8 [SQLState:42000, ISC error code:335544851]
In GenericDatabaseDialect.java there is a query to get current timestamp:
'SELECT CURRENT_TIMESTAMP'
But in Firebird its works only:
SELECT CURRENT_TIMESTAMP from rdb$database;
Hi
I have the kafka-connect with timestamp+increment with database Firebird, but this error:
However I got an error: [2024-02-05 14:46:42,888] ERROR [firebird|task-0] Failed to get current time from DB using Generic and query 'SELECT CURRENT_TIMESTAMP' (io.confluent.connect.jdbc.dialect.GenericDatabaseDialect:567) java.sql.SQLSyntaxErrorException: Dynamic SQL Error; SQL error code = -104; Unexpected end of command - line 1, column 8 [SQLState:42000, ISC error code:335544851]
In GenericDatabaseDialect.java there is a query to get current timestamp: 'SELECT CURRENT_TIMESTAMP'
But in Firebird its works only: SELECT CURRENT_TIMESTAMP from rdb$database;