框架: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语句不需要加最后的分号。