Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Firebird - Error to get CURRENT_TIMESTAMP #1396

Open
mbauer90 opened this issue Feb 5, 2024 · 0 comments
Open

Firebird - Error to get CURRENT_TIMESTAMP #1396

mbauer90 opened this issue Feb 5, 2024 · 0 comments

Comments

@mbauer90
Copy link

mbauer90 commented Feb 5, 2024

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;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant