#达梦数据库插入报错
#14:34:29.918 [XNIO-1 task-2] DEBUG c.c.d.b.DefTabOper - [logSql:1401] - Exec sql :insert into mt00_group_callev (group_id,group_cd,dag_id,dag_cd,service_cd,lev_cd,frequent,service_type,cal_mode,proj_type,create_user,create_time,update_user,update_time) values ()
#14:34:29.919 [XNIO-1 task-2] DEBUG c.c.d.b.DefTabOper - [logSql:1403] - Exec parm :[Mt00GroupCallev(group_id=1679378748806721538, group_cd=111, dag_id=1679092425261428738, dag_cd=AML_MAIN, service_cd=MT01_DB_LOAD, service_cd_disp=null, lev_cd=1, cal_mode=2, proj_type=null, frequent=1, frequent_disp=null, service_type_disp=null, service_type=1, list=null)]
14:34:30.206 [XNIO-1 task-2] ERROR c.v.w.w.b.w.e.GlobalExceptionHandler - [handleException:83] - PreparedStatementCallback; uncategorized SQLException for SQL [insert into mt00_group_callev (group_id,group_cd,dag_id,dag_cd,service_cd,lev_cd,frequent,service_type,cal_mode,proj_type,create_user,create_time,update_user,update_time) values ()]; SQL state [null]; error code [0]; Error; nested exception is java.sql.SQLException: Error
org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [insert into mt00_group_callev (group_id,group_cd,dag_id,dag_cd,service_cd,lev_cd,frequent,service_type,cal_mode,proj_type,create_user,create_time,update_user,update_time) values ()]; SQL state [null]; error code [0]; Error; nested exception is java.sql.SQLException: Error
at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1542)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:667)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:691)
at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1034)
这个UncategorizedSQLException异常表示遇到了一个未分类的SQL异常,无法确定具体的SQL错误类型。
从异常堆栈信息来看,是在执行JDBC批量插入时报错,执行的SQL是:
insert into mt00_group_callev (group_id,group_cd,dag_id,dag_cd,service_cd,lev_cd,frequent,service_type,cal_mode,proj_type,create_user,create_time,update_user,update_time) values ()
但是这个插入语句VALUES后面没有提供具体的数据,这样语法是错误的。
需要确认具体插入的数据是什么,然后提供正确的SQL语句和参数。
常见原因有以下几种: