切换成PostgreSQL数据库，quartz报错，online表单开发-功能测试...
本帖最后由 JohnsonLee 于 2022-9-19 16:50 编辑操作失败， ### Error querying database. Cause: org.postgresql.util.PSQLException: 错误: 字段 "id" 不存在 位置：8 ### The error may exist in org/jeecg/modules/online/cgform/mapper/OnlCgformButtonMapper.java (best guess) ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: SELECT id, cgform_head_id, button_code, button_name, button_style, opt_type, exp, button_status, order_num, button_icon, opt_position FROM onl_cgform_button WHERE (button_status = ? AND cgform_head_id = ? AND button_style IN (?, ?)) ORDER BY order_num ASC ### Cause: org.postgresql.util.PSQLException: 错误: 字段 "id" 不存在 位置：8 ; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: 错误: 字段 "id" 不存在 位置：8
-------------以下是quartz报错---------------
... 2 common frames omitted
2022-09-19 16:40:53.393 ERROR druid.sql.Statement:149 - {conn-10005, pstmt-20649} execute error. SELECT * FROM QRTZ_LOCKS WHERE SCHED_NAME = 'MyScheduler' AND LOCK_NAME = ? FOR UPDATE
org.postgresql.util.PSQLException: 错误: 字段 "sched_name" 不存在
位置：32
2022-09-19 16:40:54.410 ERROR druid.sql.Statement:149 - {conn-10005, pstmt-20650} execute error. SELECT * FROM QRTZ_LOCKS WHERE SCHED_NAME = 'MyScheduler' AND LOCK_NAME = ? FOR UPDATE
org.postgresql.util.PSQLException: 错误: 当前事务被终止, 事务块结束之前的查询被忽略
解决了
页:
[1]