Hi, i am using hibernate 3.2.1

I have an entity wich gets its ID from specific sequence:

@SequenceGenerator(name = "My_SEQ", sequenceName = "seq_sam")

@Entity
public class MyClass
{
int id;
String name;

@Id
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "My_SEQ")
public int getId()
{
}

public void setId(int id)
{
this.id = id;
}

...
}

when i persist a new entity, i can see the nextval call to this sequence, but the id value is not the nextvalue of the sequence. For example if the lastvalue of the sequence is 60600,the id value for my entity is 3234556, the difference between both values is enormous..

I am using jboss 4.2.0.GA, in jboss 4.0.3SP1 this works fine.

thanks

it fails for all my entities that have its own sequence...

is there any new hibernate configuration i am missing?

moreover... none of my sequences have that value (about 3 millions), so i dont know where hibernate is getting that value.. i am very confused

Hi

visit
http://jira.jboss.com/jira/browse/EJBTHREE-139

Amila
(Don't forget to rate if helps)

Thanks for your reply

I had seen that jira, but that is not my problem. I can deploy very well and as i said above, when i persist a new entity with its own sequence, i can see the call to nextval fuction on that sequence, but the value assigned to my entity is not the returned one from nextval.

All the entities that have their own sequence fails... but those wich use default hibernate sequence work perfectly.

I am using jboss 4.2.0.GA, myabe this is causing the problem i dont know, it appears that i am the one who has this problem because i can not be able to find anything about this.

Thanks

i've checked some entities and i found some interesting information:

i divided the new id value generated by hibernate against the correct value generated by sequences and i found that all have as a result the number 50:

Entity A
last correct id: 229845
first bad id: 11492300

result: 50.000217537905980117035393417303

Entity B
last correct id: 65350
first bad id: 3267600
result: 50.001530221882172915072685539403

Entity C
last correct id: 7729
first bad id: 386800
result: 50.0452839953422176219433303144

i am wondering why 50 is the result for each change. As i said, none of the new bad values are on my sequences of default hibernates sequence.

i really dont know what happens whit this.

I also tried with the lastest hibernate version. so i think it is jboss configuration problem...

hibernate-3.2.4.sp1
hibernate-annotations-3.3.0.GA
hibernate-entitymanager-3.3.1.GA

Problem fixed...

allocationSize now has default to 50, it should be 1.