I am trying to use Kafka connect with jaybird to retrieve data from firebird tables using timestamp.
Jaybird version is 5.0.4. Kafka connect failed with ‘failed to get current time from db using generic and query’ error. The correct way to get timestamp is
SELECT CURRENT_TIMESTAMP from rdb$database;

How can I rewrite default jaybird timestamp query?

Using this Getting exception ,Failed to get current time from DB using query values(CURRENT_TIMESTAMP) on database DB2 I updated jaybird driver to latest version but it did not help.