[hibernate-issues] [Hibernate-JIRA] Closed: (HHH-611) ID generator using Oracle-style sequences with increment

ID generator using Oracle-style sequences with increment -------------------------------------------------------- Key: HHH-611 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-611 Project: Hibernate Core Issue Type: Patch Affects Versions: 3.0.5 Environment: Hibernate 3, Oracle Reporter: Binil Thomas Assignee: Steve Ebersole Priority: Minor Attachments: caching-sequence-test.patch, caching-sequence.patch The org.hibernate.id.SequenceGenerator can be used to generate id's based on Oracle-style database sequences. But in its current form, this id generator does not use 'increment' option. It will hit the DB everytime it is used. A more efficient implementation is the org.hibernate.id.SequenceHiLoGenerator. This does not go to the DB often, but the id's generated by it can clash with those generated by other applications if they follow the DB sequence. In our applications, we have an Oracle sequence with increment 50 for each table - we would want all inserts into a table to pick the ID from the corresponding sequence. I am submitting a patch with an ID generator which accomplishes this.