hibernate oracle sequence produces large gap

by

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 * 50 = 250000. Add the cache value of the sequence to the equation, and it might explain your huge initial gap.

Check the value of the sequence. It should be less than the last generated identifier. Be careful not to reinitialize the sequence to this last generated value + 1, because the generated valus would grow exponentially (we’ve had this problem, and had negative integer ids due to overflow)

More Related Contents:

  1. HIbernate issue with Oracle Trigger for generating id from a sequence
  2. No more data to read from socket error
  3. Spring boot Hibernate error “Access to DialectResolutionInfo cannot be null when ‘hibernate.dialect’ not set” when working with multiple data sources
  4. Oracle: difference between max(id)+1 and sequence.nextval
  5. ORA-04091: table [blah] is mutating, trigger/function may not see it
  6. Difference between LockModeType Jpa
  7. ANYONE CAN TELL ME THAT WHY THIS CODE IS GIVING ME AN ERROR OF TABLE OT CLUSTER KEY WORD IS MISSING? [closed]
  8. How do I escape a reserved word in Oracle?
  9. How to put more than 1000 values into an Oracle IN clause [duplicate]
  10. ORA-30926: unable to get a stable set of rows in the source tables
  11. How to best split csv strings in oracle 9i
  12. TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
  13. How does the JPA @SequenceGenerator annotation work
  14. ORA-01017 Invalid Username/Password when connecting to 11g database from 9i client
  15. Oracle JDBC and Oracle CHAR data type
  16. Does Oracle have an equivalent of SQL Server’s table variables?
  17. Faster alternative in Oracle to SELECT COUNT(*) FROM sometable
  18. Oracle date difference to get number of years
  19. oracle PL/SQL how to calculate range ip for IPv6 cidr
  20. Autoincrement in oracle to already created table
  21. Trying to export a Oracle via PL/SQL gives a date of 0000-00-00
  22. Oracle: how to add minutes to a timestamp?
  23. How to drop multiple interval partitions based on date?
  24. ORA-01830: date format picture ends before converting entire input string / Select sum where date query
  25. Connection cannot be cast to oracle.jdbc.OracleConnection
  26. merge update oracle unable to get a stable set of rows
  27. How to get the week day name from a date?
  28. DBMS_JOB vs DBMS_SCHEDULER
  29. How to generate a GUID in Oracle?
  30. Escaping single quote in PLSQL

Leave a Comment