首页 > 代码库 > Mybatis错误调试(二)

Mybatis错误调试(二)

错误日志信息: 
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中正常执行。

Mybatis错误调试(二)