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中正常执行。

转载于:https://www.cnblogs.com/sdjnzqr/p/4271696.html