Hi All.

I have a simple Entity whose field id is as follows
@Id @GeneratedValue(strategy=GenerationType.AUTO) Long id;

This works fine. a sequence previously created by hibernate is used to generate a value for id column in database.

if I do this
alter table pessoa alter id set default nextval('seqpessoa');

then change the generation strategy to:
@Id @GeneratedValue(strategy=GenerationType.IDENTITY) Long id;

I get an error message "Unable to get the value for id column after inserting". Strange is that the sequence value is incremented. But no row in database is commited.

Anybody suggests a way to use user-defined sequences with hibernate??


Tnx in advance!!!

What is <generator class= option you are using ?

Test by dropping and re-create the sequence.

Are you using the sequence against data loaded from any other tables?
I mean sometimes your sequence may not in be in sync with data loaded in the table. Or your sequence may find duplicate value for id which exists already in table.

Sun

Hi

I have created a sequence by doing the following:
create sequence seqpessoa;

then did the following:
@Id @GeneratedValue(generator="seqpessoa", strategy=GenerationType.SEQUENCE) Long id;

I get an exception:
Exception in thread "main" javax.persistence.PersistenceException: org.hibernate.AnnotationException: Unknown Id.generator: seqpessoa


I dropped table so, sequence isnt out of sync with id column!
Strange isnt it??

Is this a bug?

Check this.
http://jira.jboss.com/jira/browse/EJBTHREE-139

Yeahhh.

Bugs