Hi
hibernate+oracle9i

create sequence persons_seq
start with 1
increment by 1
nominvalue
nomaxvalue
nocycle
nocache

insert into leonyuan.persons(no,name,sex,birday)
values(persons_seq.nextval,'leon','m',to_date('19790312','yyyymmdd'))

person.hbm.xml:
<id
name="no"
type="java.lang.Integer"
column="NO"
>
<generator class="sequence">
<param name="sequence">persons_seq</param>
</generator>
</id>

test:
Query query = session.createQuery("from Person i");

error:
net.sf.hibernate.MappingException: could not instantiate id generator

This works


The only difference is the class is native and datatype is Long. I don't see why that should be a problem though.
Also, make sure your dialect is correctly set.

I try just what you said,it's ok,but why class="sequence" cannot work?

is a bug or sth else?

Hi
You cant have Class and Param name same, u can have id and value same or property name and bean name same but cant have the class name and the Param same...
i think u got ur answer....