I think it would be best if we had an option to instruct Hibernate never to use the values returned by the database sequence, if the increment_size is greater than 1. This way Hibernate will only use "in-between values", that never clash with the database sequence values which may be used by other applications.
So if the increment_size is 5 and the initial_value is 1, the database will assign the values of:
-
1, 6, 11, 16, 21
-
and Hibernate will only use 2, 3, 4, 5, 7, 8, 9. 10
|