When I want to insert one item for different users, I get the following exception after about 95 inserts:
Code:
Hibernate: insert into CSRELDTAT.CSURRG (AANT05, CAAN05, DLKD05, DOCU05, DTCR05, DTWZ05, EENH05, FKLN05, FKNR05, GBRK05, KDCT05, KDFA05, KDPR05, KDUB05, OMSC05, OSIN05, OSIT05, TOBD05, USCR05, USWZ05, VFKN05, VFLN05, DATE05, FIRM05, GEBR05, LNNR05, PROJ05, PRRG05) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
10:59:51,047 WARN JDBCExceptionReporter:100 - SQL Error: -406, SQLState: 22023
10:59:51,047 ERROR JDBCExceptionReporter:101 - [SQL0406] Conversiefout bij toewijzing aan kolom DTCR05.
10:59:51,048 ERROR AbstractFlushingEventListener:324 - Could not synchronize database state with session
org.hibernate.exception.DataException: could not insert: [be.cs.nightvision.domain.UurRegistratieEntity]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:100)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2295)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2688)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137)
at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:54)
at org.maldiva.persistence.dao.impl.GenericDAOImpl.create(GenericDAOImpl.java:79)
at be.cs.nightvision.service.impl.UurRegistratieServiceImpl.insertUurRegistratie(UurRegistratieServiceImpl.java:193)
at be.cs.nightvision.test.UurRegistratieTestClass.main(UurRegistratieTestClass.java:118)
Caused by: java.sql.SQLException: [SQL0406] Conversiefout bij toewijzing aan kolom DTCR05.
at com.ibm.as400.access.JDError.throwSQLException(JDError.java:650)
at com.ibm.as400.access.JDError.throwSQLException(JDError.java:621)
at com.ibm.as400.access.AS400JDBCStatement.commonExecute(AS400JDBCStatement.java:914)
at com.ibm.as400.access.AS400JDBCPreparedStatement.executeUpdate(AS400JDBCPreparedStatement.java:1189)
at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:46)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2275)
... 14 more
Exception in thread "main" javax.persistence.RollbackException: Error while commiting the transaction
at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:71)
at org.maldiva.persistence.dao.impl.GenericDAOImpl.create(GenericDAOImpl.java:79)
at be.cs.nightvision.service.impl.UurRegistratieServiceImpl.insertUurRegistratie(UurRegistratieServiceImpl.java:193)
at be.cs.nightvision.test.UurRegistratieTestClass.main(UurRegistratieTestClass.java:118)
Caused by: org.hibernate.exception.DataException: could not insert: [be.cs.nightvision.domain.UurRegistratieEntity]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:100)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2295)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2688)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137)
at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:54)
... 3 more
Caused by: java.sql.SQLException: [SQL0406] Conversiefout bij toewijzing aan kolom DTCR05.
at com.ibm.as400.access.JDError.throwSQLException(JDError.java:650)
at com.ibm.as400.access.JDError.throwSQLException(JDError.java:621)
at com.ibm.as400.access.AS400JDBCStatement.commonExecute(AS400JDBCStatement.java:914)
at com.ibm.as400.access.AS400JDBCPreparedStatement.executeUpdate(AS400JDBCPreparedStatement.java:1189)
at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:46)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2275)
... 14 more
Nothing changes but he starts the give errors after a while. Anyone who has some ideas? Would be appreciated.