oracle中由于没有auto-increment,所以用hibernate产生序列时用native时就有问题。
08-11-03 23:59:09 WARN org.hibernate.util.JDBCExceptionReporter 77 SQL Error: 2289, SQLState: 42000
2008-11-03 23:59:09 ERROR org.hibernate.util.JDBCExceptionReporter 78 ORA-02289: 序列不存在
org.springframework.dao.InvalidDataAccessResourceUsageException: could not get next sequence value; nested exception is org.hibernate.exception.SQLGrammarException: could not get next sequence value
1.建立表格:
create table tb_role(
roleID number(10) not null auto_increment primary key,
roleName varchar2(20) not null
);
2.建立从1开始的序列:
CREATE SEQUENCE wgj_sequence START WITH 1 INCREMENT BY 1;
3.建立触发器:
CREATE OR REPLACE TRIGGER "ROLETGE" BEFORE INSERT ON tb_role FOR EACH ROW
BEGIN
SELECT wgj_sequence.NextVAl INTO :new.roleID FROM dual;
END;
<id name="roleId" type="java.lang.Integer">
<column name="roleID" length="10"/>
<generator class="sequence">
<param name="sequence">wgj_sequence</param>
</generator>
</id>
或者用hibernate的sequence。要自己建一个
CREATE SEQUENCE hibernate_sequence START WITH 1 INCREMENT BY 1;
<id name="roleId" type="java.lang.Integer">
<column name="roleID" length="10"/>
<generator class="native"/>
</id>
查询hibernate_sequence是否建立成功
select hibernate_sequence.nextval from dual;
上面2个选一个。不能2个都用否则,会+2而不是增长1