切换成PostgreSQL数据库，quartz报错，online表单开发-功能测试...

JohnsonLee · 发表于 2022-9-19 16:44:00

本帖最后由 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 [QuartzScheduler_MyScheduler-LAPTOP-7MRODH5H1663575327498_ClusterManager] 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 [QuartzScheduler_MyScheduler-LAPTOP-7MRODH5H1663575327498_ClusterManager] 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: 错误: 当前事务被终止, 事务块结束之前的查询被忽略

JohnsonLee · 发表于 2022-9-22 17:29:19

解决了

[Online开发] 切换成PostgreSQL数据库，quartz报错，online表单开发-功能测试...