iBatis插入数据时报错The error occurred while applying a parameter map

最新推荐文章于 2021-03-21 16:50:48 发布

zhang_cl_cn

最新推荐文章于 2021-03-21 16:50:48 发布

阅读量7.8k

点赞数 1

分类专栏： IBatis

IBatis 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

Student.xml 中的sql语句

<insert id="addStudent" parameterClass="Student" >
		insert into student (sid, sname, major, birth, score) 
		values (#sid#, #sname#, #major#, #birth#, #score#);
</insert>

错误提示

com.ibatis.common.jdbc.exception.NestedSQLException:   
--- The error occurred in com/itcast/Student.xml.  
--- The error occurred while applying a parameter map.  
--- Check the addStudent-InlineParameterMap.  
--- Check the statement (update failed).  
--- Cause: java.sql.SQLException: ORA-00911: 无效字符
 
	at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeUpdate(MappedStatement.java:107)
	at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.insert(SqlMapExecutorDelegate.java:393)
	at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.insert(SqlMapSessionImpl.java:82)
	at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.insert(SqlMapClientImpl.java:58)
	at com.itcast.IStudentDAOImpl.addStudent(IStudentDAOImpl.java:31)
	at com.itcast.IStudentDAOImpl.main(IStudentDAOImpl.java:100)
Caused by: java.sql.SQLException: ORA-00911: 无效字符
 
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
	at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
	at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
	at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3390)
	at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeUpdate(SqlExecutor.java:80)
	at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteUpdate(MappedStatement.java:216)
	at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeUpdate(MappedStatement.java:94)
	... 5 more

原因是在Student.xml中 sql语句最后不能添加分号“;”，把分号删除就能执行成功
转自 AoYuanSE https://blog.csdn.net/dongaoyuan/article/details/17299457