Numeric Overflow Error getting next sequence in the JBoss ON Server Log
Issue
- Seeing below error in JBoss ON Server log:
2015-11-03 13:01:14,430 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 17026, SQLState: 99999
2015-11-03 13:01:14,430 ERROR [org.hibernate.util.JDBCExceptionReporter] Numeric Overflow
Environment
- Red Hat JBoss Operations Network (ON) 3.1.2
- Oracle Database
- Full error in log:
org.hibernate.exception.GenericJDBCException: could not get next sequence value
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:96)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:99)
at org.hibernate.event.def.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:131)
at org.hibernate.event.def.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:87)
at org.hibernate.event.def.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:38)
at org.hibernate.impl.SessionImpl.firePersist(SessionImpl.java:618)
at org.hibernate.impl.SessionImpl.persist(SessionImpl.java:592)
at org.hibernate.impl.SessionImpl.persist(SessionImpl.java:596)
at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:212)
... 133 more
Caused by: java.sql.SQLException: Numeric Overflow
at oracle.jdbc.driver.NumberCommonAccessor.throwOverflow(NumberCommonAccessor.java:4381)
at oracle.jdbc.driver.NumberCommonAccessor.getInt(NumberCommonAccessor.java:132)
at oracle.jdbc.driver.OracleResultSetImpl.getInt(OracleResultSetImpl.java:942)
at org.jboss.resource.adapter.jdbc.WrappedResultSet.getInt(WrappedResultSet.java:685)
at org.hibernate.id.IdentifierGeneratorFactory.get(IdentifierGeneratorFactory.java:84)
at org.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:78)
... 141 more
2015-11-03 13:32:52,279 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 17026, SQLState: 99999
2015-11-03 13:32:52,281 ERROR [org.hibernate.util.JDBCExceptionReporter] Numeric Overflow
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.
