hibernate oracle sequence produces large gap

I think that the problem comes from the fact that the sequence generator is not really a sequence generator, but a sequence hilo generator, with a default allocation size of 50. as indicated by the documentation : http://docs.jboss.org/hibernate/stable/annotations/reference/en/html_single/#entity-mapping-identifier This means that if the sequence value is 5000, the next generated value will be 5000 * … Read more