Oracle Mybatis插入时报错 java.sql.SQLSyntaxErrorException: ORA-02287: 此处不允许序号

差一线牧神

于 2025-06-10 08:04:21 发布

阅读量219

点赞数 3

CC 4.0 BY-SA版权

文章标签： oracle mybatis java

本文链接：https://blog.youkuaiyun.com/weixin_39189588/article/details/148538049

原因：插入的类用了分页

public class AluminumWireRecord extends PageDomain

Mybatis是这样

 <selectKey keyProperty="id" order="BEFORE" resultType="java.lang.Long">
      SELECT SEQ_ALUMINUM_WIRE_RECORD.Nextval  FROM DUAL
    </selectKey>
    <!--@mbg.generated-->
    insert into ALUMINUM_WIRE_RECORD

在执行插入的时候先执行了SELECT SEQ_ALUMINUM_WIRE_RECORD.Nextval FROM DUAL

SELECT
	* 
FROM
	( SELECT TMP_PAGE.*, ROWNUM PAGEHELPER_ROW_ID FROM 
( SELECT SEQ_ALUMINUM_WIRE_RECORD.Nextval FROM DUAL )
 TMP_PAGE ) 
WHERE
	PAGEHELPER_ROW_ID <= 10 
	AND PAGEHELPER_ROW_ID > 0

解决：取消分页就行

  PageHelper.startPage(0, 0, false, null, true);
  aluminumWireRecordMapper.insertSelective(addAluminumWireRecord);