Mybatis错误调试(二)

时间:2024-01-16 15:57:26

错误日志信息: 

Caused by: java.sql.BatchUpdateException: ORA-00911: 无效字符
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10070)
at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:213)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
at org.apache.ibatis.executor.BatchExecutor.doFlushStatements(BatchExecutor.java:99)
at org.apache.ibatis.executor.BaseExecutor.flushStatements(BaseExecutor.java:109)
at org.apache.ibatis.executor.BaseExecutor.flushStatements(BaseExecutor.java:104)
at org.apache.ibatis.executor.BaseExecutor.commit(BaseExecutor.java:193)
at org.apache.ibatis.executor.CachingExecutor.commit(CachingExecutor.java:113)
at org.apache.ibatis.session.defaults.DefaultSqlSession.commit(DefaultSqlSession.java:170)
at org.apache.ibatis.session.defaults.DefaultSqlSession.commit(DefaultSqlSession.java:165)
at org.mybatis.spring.SqlSessionUtils$SqlSessionSynchronization.beforeCommit(SqlSessionUtils.java:263)
... 53 more

原因:

   SQL有错

注意:

  1. 检查SQL中是否最后有一个;号。

   2.检查能否再plSQL中正常执行。