hibernate 操作数据库时,
当添加操作时报 Oracle操作ORA-02289: 序列不存在
hibernate描述文件
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="com.cn.bean.ArcArchiveApply" table="ARC_ARCHIVE_APPLY" schema="AMS_RECEPTION" optimistic-lock="version">
<id name="id" type="java.lang.Long">
<column name="ID" />
<generator class="sequence">
<param name="sequence">AMS_RECEPTION.SEQ_ID</param>
</generator>
</id>
<!--中间略.....-->
<property name="createTime" type="java.util.Date">
<column name="CREATE_TIME" length="7" />
</property>
<property name="createUser" type="java.lang.Long">
<column name="CREATE_USER" />
</property>
</class>
</hibernate-mapping>
当对apply表进行插入操作时候
会去数据库查询你的序列的下一个Nextval做为主键值进行插入。
解决办法没有序列先创建
-- Create sequence
create sequence SEQ_ID
minvalue 2000
maxvalue 9999999999
start with 2020
increment by 1
cache 20;