What is column data type in sybase compatible with kafka connect timestamp ?
as i have tried datatime ,timestamp data type in sybase but i am getting below error
[2023-02-06 11:19:22,840] ERROR [jdbc_source_sybase_01|task-0] Failed to get current time from DB using Generic and query ‘SELECT CURRENT_TIMESTAMP’ (io.confluent.connect.jdbc.dialect.GenericDatabaseDialect:564)
java.sql.SQLException: Invalid column name 'CURRENT_TIMESTAMP’.
my sample json for kafka connect mentioned below
{
“name”: “jdbc_source_sybase_02”,
“config”: {
“connector.class”: “io.confluent.connect.jdbc.JdbcSourceConnector”,
“connection.url”: “jdbc:sybase:Tds:xxxxx-yyyy:port/schema”,
“connection.user”: “xxxx”,
“connection.password”: “xxxxx”,
“topic.prefix”: “test_query_mode”,
“mode”: “timestamp”,
“timestamp.column.name”: “dt_chg_lst”,
“poll.interval.ms” : 30000,
“query”: “select dt_chg_lst,fname from CUSTOMER”,
“catalog.pattern” : “PYR_TRADE”
}
}