因为oracle中并不支持自增id,所以使用下面这种批量的先查询id,再把id的值加1后放到id字段中去,老是报ORA-00933: SQL 命令未正确结束,请大神帮帮忙。
<insert id="addRoleInfo" parameterType="java.util.List" useGeneratedKeys="false" >
<selectKey resultType="int" keyProperty="ID" order="BEFORE">
SELECT MAX(ID)+1 FROM PORTAL_SYSTEM_ROLE
</selectKey>
insert into PORTAL_SYSTEM_ROLE (ID,ROLE_ID,ROLE_NAME,CREATE_TIME,UPDATE_TIME)
values
<foreach collection="list" item="item" index="index" separator="," >
(#{item.id,jdbcType=VARCHAR},
#{item.roleId,jdbcType=VARCHAR},
#{item.roleName,jdbcType=VARCHAR},
#{item.createTime,jdbcType=TIMESTAMP},
#{item.updateTime,jdbcType=TIMESTAMP})
</foreach>
</insert>
org.springframework.jdbc.BadSqlGrammarException:
### Error updating database. Cause: java.sql.SQLException: ORA-00933: SQL 命令未正确结束
### The error may exist in file [E:\HTML\apache-tomcat-7.0.69\webapps\4asyn\WEB-INF\classes\mybatis\RoleMapper.xml]
### The error may involve com.boco.eoms.portal.role.mapper.RoleMapper.addRoleInfo-Inline
### The error occurred while setting parameters
### SQL: insert into PORTAL_SYSTEM_ROLE (ID,ROLE_ID,ROLE_NAME,CREATE_TIME,UPDATE_TIME) values (?, ?, ?, ?, ?) , (?, ?, ?, ?, ?)
### Cause: java.sql.SQLException: ORA-00933: SQL 命令未正确结束
; bad SQL grammar []; nested exception is java.sql.SQLException: ORA-00933: SQL 命令未正确结束