ibatis 无效字符

框架：SSI

问题描述：

在sqlmap-**.xml中配置插入语句

<insert id="addUser" parameterClass="java.util.HashMap" >
insert into users (USER_NAME,USER_SEX,USER_AGE,USER_DEPARTMENT,USER_MAIL,USER_PASSWORD) values (#userName#,#userSex#,#userAge#,#userDepartment#,#userMail#,#userPassword#);
</insert>

报错信息：

--- The error occurred in com/doone/user/map/sqlmap-users.xml.
--- The error occurred while applying a parameter map.
--- Check the doone-users.addUser-InlineParameterMap.
--- Check the statement (update failed).
--- Cause: java.sql.SQLException: ORA-00911: 无效字符

解决方案：在insert中写的sql语句不需要加最后的分号。

框架：SSI

问题描述：

在sqlmap-**.xml中配置插入语句

<insert id="addUser" parameterClass="java.util.HashMap" >
insert into users (USER_NAME,USER_SEX,USER_AGE,USER_DEPARTMENT,USER_MAIL,USER_PASSWORD) values (#userName#,#userSex#,#userAge#,#userDepartment#,#userMail#,#userPassword#);
</insert>

报错信息：

--- The error occurred in com/doone/user/map/sqlmap-users.xml.
--- The error occurred while applying a parameter map.
--- Check the doone-users.addUser-InlineParameterMap.
--- Check the statement (update failed).
--- Cause: java.sql.SQLException: ORA-00911: 无效字符

解决方案：在insert中写的sql语句不需要加最后的分号。