Hi all,

I am kinda new in Hibernate. And currently I am trying to do some coding which involve 2 object Report and Screening. The Screening will have an field call REPORT_ID which serve as foreign key link to the Report ID. And one Report may contain one to many Screening.

I have try implement the code with only one screening contain inside the Report and it is working perfectly. But when the Report contain more than one Screening, i had hit error which is stated as below. Any suggestion on my case? Thanks for the advise and have a nice day to you all :).

Full stack trace of any exception that occurs:
14281 [main] WARN JDBCExceptionReporter - SQL Error: 17041, SQLState: null
14281 [main] ERROR JDBCExceptionReporter - Missing IN or OUT parameter at index:: 9
javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not insert: [com.kenexa.kr.integration.external.backgroundcheck.bean.BGReport.ScreeningsResultEntity]
at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:629)
at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:218)
at com.kenexa.kr.data.dao.integration.BGCheckDaoServiceImpl.saveReportResult(BGCheckDaoServiceImpl.java:19)
at com.kenexa.kr.integration.external.backgroundcheck.BGCheckProcessor.ShowBackgroudReport(BGCheckProcessor.java:233)
at com.kenexa.kr.integration.external.backgroundcheck.BGCheckManager.ShowBackgroudReport(BGCheckManager.java:72)
at com.test.TestingSterling2.main(TestingSterling2.java:25)
Caused by: org.hibernate.exception.GenericJDBCException: could not insert: [com.kenexa.kr.integration.external.backgroundcheck.bean.BGReport.ScreeningsResultEntity]
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.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:40)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2154)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2634)
at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:48)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:298)
at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107)
at org.hibernate.event.def.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:131)
at org.hibernate.event.def.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:87)
at org.hibernate.impl.SessionImpl.firePersist(SessionImpl.java:609)
at org.hibernate.impl.SessionImpl.persist(SessionImpl.java:601)
at org.hibernate.engine.CascadingAction$8.cascade(CascadingAction.java:295)
at org.hibernate.engine.Cascade.cascadeToOne(Cascade.java:268)
at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:216)
at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:169)
at org.hibernate.engine.Cascade.cascadeCollectionElements(Cascade.java:296)
at org.hibernate.engine.Cascade.cascadeCollection(Cascade.java:242)
at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:219)
at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:169)
at org.hibernate.engine.Cascade.cascade(Cascade.java:130)
at org.hibernate.event.def.AbstractSaveEventListener.cascadeAfterSave(AbstractSaveEventListener.java:456)
at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:334)
at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107)
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)
... 4 more
Caused by: java.sql.SQLException: Missing IN or OUT parameter at index:: 9
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)
at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1703)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3279)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3367)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
at org.hibernate.id.SequenceIdentityGenerator$Delegate.executeAndExtract(SequenceIdentityGenerator.java:80)
at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:33)
... 35 more

Name and version of the database you are using:
Oracle 10g

The generated SQL (show_sql=true):
Hibernate:
insert
into
KR_INT_STERLING_BGREPORT
(ID, ORDER_ID, REDIRECT_URL, REFERENCE_ID, ORDER_STATUS, STATUS_SCORE, DATE_ORDER_RECEIVED, DATE_ORDER_CLOSED)
values
( KRSEQ_INT_STERLING_BGREPORT .nextval, ?, ?, ?, ?, ?, ?, ?)
Hibernate:
insert
into
KR_INT_STERLING_SCREENING
(ID, BGREPORT_ID, TYPE, REFERENCE_ID, ORDER_STATUS, RESULT_STATUS, RESULT, OPEN_DATE, CLOSE_DATE)
values
( KRSEQ_INT_STERLING_SCREENING .nextval, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate:
insert
into
KR_INT_STERLING_SCREENING
(ID, BGREPORT_ID, TYPE, REFERENCE_ID, ORDER_STATUS, RESULT_STATUS, RESULT, OPEN_DATE, CLOSE_DATE)
values
( KRSEQ_INT_STERLING_SCREENING .nextval, ?, ?, ?, ?, ?, ?, ?, ?)