Support Kingbase. (Error Couldn't obtain triggers for job: Cannot convert the column of type BYTEA to requested type long.)

quartz-scheduler / quartz

Code for Quartz Scheduler

http://www.quartz-scheduler.org

Apache License 2.0

6.27k stars 1.93k forks source link

Support Kingbase. (Error Couldn't obtain triggers for job: Cannot convert the column of type BYTEA to requested type long.) #1096

Open a1643977841 opened 9 months ago

a1643977841 commented 9 months ago

quartz version: 2.3.2 Springboot: 2.5.12

Our project recently switched the database from Mysql to Kingbase, but the following error occurred occasionally when performing the task. After my preliminary analysis, I feel that there is an abnormality in quartz. I am not sure. Please help me look at it. Please see the attachment for three errors

error1.txt error2.txt error3.txt

mengshixing commented 5 months ago

搞定了么 bro ,好难处理呀

jhouserizer commented 4 days ago

Seems like someone needs to develop table definitions and perhaps a sqlDelegate implementation for Kingbase.

a1643977841 commented 4 days ago

I switched Kingbase JDBC to PostgreSQL JDBC problem solved