oracle中用hibernate

 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