求助,SQL 命令未正确结束,急啊!
这是控制台的报错信息### The error may involve com.vip.mapper.boss.BossnavattrMapper.createNavAttr_SyncForBatch-Inline
### The error occurred while setting parameters
### SQL: INSERT INTO BossNavAttr_SYNC(ATTRID,NAVID,ATTRALTNAME,ATTRPROPERTY,PARENTATTRID,ORDERFLAG,FULLPATH,FULLNAME,PARENTOPTIONID,MAPID,REDOPTION,ATTRNOTE) select ATTRID,NAVID,ATTRALTNAME,ATTRPROPERTY,PARENTATTRID,ORDERFLAG,FULLPATH,FULLNAME,PARENTOPTIONID,MAPID,REDOPTION,ATTRNOTE from BossNavAttr WHERE MAPID = ? and navid in (249263)
### Cause: java.sql.SQLException: ORA-00933: SQL 命令未正确结束
===========================================
XML里面配置信息是这样:
<insert id="createNavAttr_SyncForBatch" parameterType="Object">
INSERT INTO BossNavAttr_SYNC(ATTRID,NAVID,ATTRALTNAME,ATTRPROPERTY,PARENTATTRID,ORDERFLAG,FULLPATH,FULLNAME,PARENTOPTIONID,MAPID,REDOPTION,ATTRNOTE)
select ATTRID,NAVID,ATTRALTNAME,ATTRPROPERTY,PARENTATTRID,ORDERFLAG,FULLPATH,FULLNAME,PARENTOPTIONID,MAPID,REDOPTION,ATTRNOTE
from BossNavAttr WHERE MAPID = #{mapid} and ${srcString}
</insert>
使用的是MyBatis+SpringMVC,数据库是ORACLE 10g,两张表名字分别是BossNavAttr_SYNC和BossNavAttr,这两张表的字段个数以及字段数据类型都是一样,我想在添加BossNavAttr_SYNC数据时,直接通过id查询BossNavAttr表,将查到的记录直接添加到BossNavAttr_SYNC表,这个SQL语句我在PL/SQL里面能够正常添加,而且查询也有数据,但是在Java里面就一直报错,请问是什么原因啊?