Isn't the allocation size supposed to be the number of sequences it gets each time it accesses the table to reduce the number of times it has to hit the sequence? If so, then I think there are two bugs occurring here:
1) the sequence value is not being adjusted to the "hi" value. If the DB returns 1 and hibernate thinks it got back 50 values, shouldn't the next sequence value be 51
2) hibernate is just multiplying the returned value by the allocation size and not actually using the returned values. (ie. seq = 1, hibernate sets id to 50, next access seq=2, hibernate sets id to 100
|