hibernate version : 2.1.6

Full stack trace of any exception that occurs:
net.sf.hibernate.HibernateException: Found two representations of same collection: intra.novartis.pharma.smt.dao.RecordVO.businessCaseAttachSet


oracle 10g


I'm lost, someone has this error ?

Regards,

Franck

If you want help, supply us with more information. (Use the template)

Hibernate version: 2.1.6

Full stack trace of any exception that occurs:

SEVERE: org.springframework.orm.hibernate.HibernateSystemException: Found two representations of same collection: intra.novartis.pharma.smt.dao.RecordVO.businessCaseAttachSet; nested exception is net.sf.hibernate.HibernateException: Found two representations of same collection: intra.novartis.pharma.smt.dao.RecordVO.businessCaseAttachSet
net.sf.hibernate.HibernateException: Found two representations of same collection: intra.novartis.pharma.smt.dao.RecordVO.businessCaseAttachSet
at net.sf.hibernate.impl.SessionImpl.updateReachableCollection(SessionImpl.java:2870)
at net.sf.hibernate.impl.FlushVisitor.processCollection(FlushVisitor.java:32)
at net.sf.hibernate.impl.AbstractVisitor.processValue(AbstractVisitor.java:69)
at net.sf.hibernate.impl.AbstractVisitor.processValues(AbstractVisitor.java:36)
at net.sf.hibernate.impl.SessionImpl.flushEntity(SessionImpl.java:2592)
at net.sf.hibernate.impl.SessionImpl.flushEntities(SessionImpl.java:2458)
at net.sf.hibernate.impl.SessionImpl.flushEverything(SessionImpl.java:2260)
at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2239)
at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61)
at org.springframework.orm.hibernate.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:460)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:373)
at org.springframework.transaction.interceptor.TransactionAspectSupport.doCommitTransactionAfterReturning(TransactionAspectSupport.java:241)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:66)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:138)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:596)
at intra.novartis.pharma.smt.domain.CommonFacade$$EnhancerByCGLIB$$8788f31a.saveNewVersionOfMaintenanceRequest(<generated>)
at intra.novartis.pharma.smt.webapp.MaintenanceRequestAction.submit(MaintenanceRequestAction.java:173)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:276)
at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:196)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:996)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:419)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:315)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6452)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:118)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3661)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2630)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:219)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:178)


Name and version of the database you are using:

Oracle 10g

The generated SQL (show_sql=true):

Hibernate: select f.SMT_FILE_ID as SMT_FILE1_, f.SMT_FILE_NAME as SMT_FILE2_, f.SMT_FILE_MIME as SMT_FILE3_, f.SMT_VALUE as SMT_VALUE from SMT_FILE f where (f.SMT_FILE_ID in(select bc.SMT_FILE_ID from SMT_BUSINESS_CASE_ATTACH bc where (bc.SMT_RECORD_ID=? )))
Hibernate: select f.SMT_FILE_ID as SMT_FILE1_, f.SMT_FILE_NAME as SMT_FILE2_, f.SMT_FILE_MIME as SMT_FILE3_, f.SMT_VALUE as SMT_VALUE from SMT_FILE f where (f.SMT_FILE_ID in(select pr.SMT_FILE_ID from SMT_PRODUCT_ATTACH pr where (pr.SMT_RECORD_ID=? )))
Hibernate: select propertyvo0_.NAME as NAME0_, propertyvo0_.VALUE as VALUE0_ from SMT_PROPERTY propertyvo0_ where propertyvo0_.NAME=?
Hibernate: select recordvo0_.SMT_RECORD_ID as SMT_RECO1_8_, recordvo0_.VERSION as VERSION8_, recordvo0_.LAST_UPDATE as LAST_UPD3_8_, recordvo0_.BUSINESS_REQUIREMENTS as BUSINESS4_8_, recordvo0_.LOCAL_IMPACTS as LOCAL_IM5_8_, recordvo0_.INTEGRATION as INTEGRAT6_8_, recordvo0_.PRODUCT_NAME as PRODUCT_7_8_, recordvo0_.VENDOR_NAME as VENDOR_N8_8_, recordvo0_.APPROVAL_DATE as APPROVAL9_8_, recordvo0_.REVIEW_COMMENTS as REVIEW_10_8_, recordvo0_.PRODUCT_SPEC as PRODUCT11_8_, recordvo0_.APPROVAL_COMMENTS as APPROVA12_8_, recordvo0_.STATUS as STATUS8_, recordvo0_.RETIREMENT_COMMENTS as RETIREM14_8_, recordvo0_.ARCHIVING_DATE as ARCHIVI15_8_, recordvo0_.CREATION_DATE as CREATIO16_8_, recordvo0_.CATEGORY_ID as CATEGOR17_8_, recordvo0_.OWNEDBY as OWNEDBY8_, recordvo0_.APPROVEDBY as APPROVEDBY8_, recordvo0_.REQUESTEDBY as REQUEST20_8_, recordvo0_.RECORD_GROUP as RECORD_21_8_, categoryvo1_.SMT_CATEGORY_ID as SMT_CATE1_0_, categoryvo1_.SMT_CATEGORY_NAME as SMT_CATE2_0_, categoryvo1_.APPROVEDBY as APPROVEDBY0_, uservo2_.LOGIN as LOGIN1_, uservo2_.FIRSTNAME as FIRSTNAME1_, uservo2_.LASTNAME as LASTNAME1_, uservo2_.MAIL as MAIL1_, uservo2_.PASSWORD as PASSWORD1_, exceptionv3_.SMT_RECORD_ID as SMT_RECO1_2_, standardvo4_.SMT_RECORD_ID as SMT_RECO1_3_, standardvo4_.CONTRACT as CONTRACT3_, standardvo4_.CONTRACT_RESPONSIBLE as CONTRACT3_3_, standardvo4_.SUPPORT as SUPPORT3_, standardvo4_.TRAINING as TRAINING3_, standardvo4_.REVIEW_PERIOD as REVIEW_P6_3_, standardvo4_.UPDATE_PERIOD as UPDATE_P7_3_, standardvo4_.PLANNED_RETIREMENT as PLANNED_8_3_, uservo5_.LOGIN as LOGIN4_, uservo5_.FIRSTNAME as FIRSTNAME4_, uservo5_.LASTNAME as LASTNAME4_, uservo5_.MAIL as MAIL4_, uservo5_.PASSWORD as PASSWORD4_, uservo6_.LOGIN as LOGIN5_, uservo6_.FIRSTNAME as FIRSTNAME5_, uservo6_.LASTNAME as LASTNAME5_, uservo6_.MAIL as MAIL5_, uservo6_.PASSWORD as PASSWORD5_, uservo7_.LOGIN as LOGIN6_, uservo7_.FIRSTNAME as FIRSTNAME6_, uservo7_.LASTNAME as LASTNAME6_, uservo7_.MAIL as MAIL6_, uservo7_.PASSWORD as PASSWORD6_, recordgrou8_.SMT_RECORD_GROUP_ID as SMT_RECO1_7_ from SMT_RECORD recordvo0_ left outer join SMT_CATEGORY categoryvo1_ on recordvo0_.CATEGORY_ID=categoryvo1_.SMT_CATEGORY_ID left outer join SMT_USER uservo2_ on categoryvo1_.APPROVEDBY=uservo2_.LOGIN left outer join SMT_EXCEPTION exceptionv3_ on recordvo0_.SMT_RECORD_ID=exceptionv3_.SMT_RECORD_ID left outer join SMT_STANDARD standardvo4_ on recordvo0_.SMT_RECORD_ID=standardvo4_.SMT_RECORD_ID left outer join SMT_USER uservo5_ on recordvo0_.OWNEDBY=uservo5_.LOGIN left outer join SMT_USER uservo6_ on recordvo0_.APPROVEDBY=uservo6_.LOGIN left outer join SMT_USER uservo7_ on recordvo0_.REQUESTEDBY=uservo7_.LOGIN left outer join SMT_RECORD_GROUP recordgrou8_ on recordvo0_.RECORD_GROUP=recordgrou8_.SMT_RECORD_GROUP_ID where recordvo0_.SMT_RECORD_ID=?
Hibernate: select referstose0_.SMT_RECORD_ID as SMT_RECO1___, referstose0_.SMT_STANDARD_AREA_ID as SMT_STAN2___, referstose0_.SMT_RECORD_ID as SMT_RECO1_0_, referstose0_.SMT_STANDARD_AREA_ID as SMT_STAN2_0_ from SMT_REFERS_TO referstose0_ where referstose0_.SMT_RECORD_ID=?

.....


Hibernate: select filevo0_.SMT_FILE_ID as SMT_FILE1_0_, filevo0_.SMT_FILE_NAME as SMT_FILE2_0_, filevo0_.SMT_FILE_MIME as SMT_FILE3_0_, filevo0_.SMT_VALUE as SMT_VALUE0_ from SMT_FILE filevo0_ where filevo0_.SMT_FILE_ID=?
Hibernate: select productatt0_.SMT_RECORD_ID as SMT_RECO1_0_, productatt0_.SMT_FILE_ID as SMT_FILE2_0_ from SMT_PRODUCT_ATTACH productatt0_ where productatt0_.SMT_RECORD_ID=? and productatt0_.SMT_FILE_ID=?
Hibernate: select generatess0_.SMT_RECORD_ID as SMT_RECO1___, generatess0_.SMT_EMAIL_ID as SMT_EMAI2___, generatess0_.SMT_RECORD_ID as SMT_RECO1_0_, generatess0_.SMT_EMAIL_ID as SMT_EMAI2_0_ from SMT_GENERATES generatess0_ where generatess0_.SMT_RECORD_ID=?
Hibernate: select getsset0_.SMT_RECORD_ID as SMT_RECO2___, getsset0_.SMT_RISK_ID as SMT_RISK1___, getsset0_.SMT_RISK_ID as SMT_RISK1_0_, getsset0_.SMT_RECORD_ID as SMT_RECO2_0_ from SMT_GETS getsset0_ where getsset0_.SMT_RECORD_ID=?
Hibernate: select makesset0_.SMT_RECORD_ID as SMT_RECO2___, makesset0_.SMT_ACTION_ID as SMT_ACTI1___, makesset0_.SMT_ACTION_ID as SMT_ACTI1_0_, makesset0_.SMT_RECORD_ID as SMT_RECO2_0_ from SMT_MAKES makesset0_ where makesset0_.SMT_RECORD_ID=?
Hibernate: select productatt0_.SMT_RECORD_ID as SMT_RECO1___, productatt0_.SMT_FILE_ID as SMT_FILE2___, productatt0_.SMT_RECORD_ID as SMT_RECO1_0_, productatt0_.SMT_FILE_ID as SMT_FILE2_0_ from SMT_PRODUCT_ATTACH productatt0_ where productatt0_.SMT_RECORD_ID=?
Hibernate: select recordvo0_.SMT_RECORD_ID as SMT_RECO1_8_, recordvo0_.VERSION as VERSION8_, recordvo0_.LAST_UPDATE as LAST_UPD3_8_, recordvo0_.BUSINESS_REQUIREMENTS as BUSINESS4_8_, recordvo0_.LOCAL_IMPACTS as LOCAL_IM5_8_, recordvo0_.INTEGRATION as INTEGRAT6_8_, recordvo0_.PRODUCT_NAME as PRODUCT_7_8_, recordvo0_.VENDOR_NAME as VENDOR_N8_8_, recordvo0_.APPROVAL_DATE as APPROVAL9_8_, recordvo0_.REVIEW_COMMENTS as REVIEW_10_8_, recordvo0_.PRODUCT_SPEC as PRODUCT11_8_, recordvo0_.APPROVAL_COMMENTS as APPROVA12_8_, recordvo0_.STATUS as STATUS8_, recordvo0_.RETIREMENT_COMMENTS as RETIREM14_8_, recordvo0_.ARCHIVING_DATE as ARCHIVI15_8_, recordvo0_.CREATION_DATE as CREATIO16_8_, recordvo0_.CATEGORY_ID as CATEGOR17_8_, recordvo0_.OWNEDBY as OWNEDBY8_, recordvo0_.APPROVEDBY as APPROVEDBY8_, recordvo0_.REQUESTEDBY as REQUEST20_8_, recordvo0_.RECORD_GROUP as RECORD_21_8_, categoryvo1_.SMT_CATEGORY_ID as SMT_CATE1_0_, categoryvo1_.SMT_CATEGORY_NAME as SMT_CATE2_0_, categoryvo1_.APPROVEDBY as APPROVEDBY0_, uservo2_.LOGIN as LOGIN1_, uservo2_.FIRSTNAME as FIRSTNAME1_, uservo2_.LASTNAME as LASTNAME1_, uservo2_.MAIL as MAIL1_, uservo2_.PASSWORD as PASSWORD1_, exceptionv3_.SMT_RECORD_ID as SMT_RECO1_2_, standardvo4_.SMT_RECORD_ID as SMT_RECO1_3_, standardvo4_.CONTRACT as CONTRACT3_, standardvo4_.CONTRACT_RESPONSIBLE as CONTRACT3_3_, standardvo4_.SUPPORT as SUPPORT3_, standardvo4_.TRAINING as TRAINING3_, standardvo4_.REVIEW_PERIOD as REVIEW_P6_3_, standardvo4_.UPDATE_PERIOD as UPDATE_P7_3_, standardvo4_.PLANNED_RETIREMENT as PLANNED_8_3_, uservo5_.LOGIN as LOGIN4_, uservo5_.FIRSTNAME as FIRSTNAME4_, uservo5_.LASTNAME as LASTNAME4_, uservo5_.MAIL as MAIL4_, uservo5_.PASSWORD as PASSWORD4_, uservo6_.LOGIN as LOGIN5_, uservo6_.FIRSTNAME as FIRSTNAME5_, uservo6_.LASTNAME as LASTNAME5_, uservo6_.MAIL as MAIL5_, uservo6_.PASSWORD as PASSWORD5_, uservo7_.LOGIN as LOGIN6_, uservo7_.FIRSTNAME as FIRSTNAME6_, uservo7_.LASTNAME as LASTNAME6_, uservo7_.MAIL as MAIL6_, uservo7_.PASSWORD as PASSWORD6_, recordgrou8_.SMT_RECORD_GROUP_ID as SMT_RECO1_7_ from SMT_RECORD recordvo0_ left outer join SMT_CATEGORY categoryvo1_ on recordvo0_.CATEGORY_ID=categoryvo1_.SMT_CATEGORY_ID left outer join SMT_USER uservo2_ on categoryvo1_.APPROVEDBY=uservo2_.LOGIN left outer join SMT_EXCEPTION exceptionv3_ on recordvo0_.SMT_RECORD_ID=exceptionv3_.SMT_RECORD_ID left outer join SMT_STANDARD standardvo4_ on recordvo0_.SMT_RECORD_ID=standardvo4_.SMT_RECORD_ID left outer join SMT_USER uservo5_ on recordvo0_.OWNEDBY=uservo5_.LOGIN left outer join SMT_USER uservo6_ on recordvo0_.APPROVEDBY=uservo6_.LOGIN left outer join SMT_USER uservo7_ on recordvo0_.REQUESTEDBY=uservo7_.LOGIN left outer join SMT_RECORD_GROUP recordgrou8_ on recordvo0_.RECORD_GROUP=recordgrou8_.SMT_RECORD_GROUP_ID where recordvo0_.SMT_RECORD_ID=?
Hibernate: select referstose0_.SMT_RECORD_ID as SMT_RECO1___, referstose0_.SMT_STANDARD_AREA_ID as SMT_STAN2___, referstose0_.SMT_RECORD_ID as SMT_RECO1_0_, referstose0_.SMT_STANDARD_AREA_ID as SMT_STAN2_0_ from SMT_REFERS_TO referstose0_ where referstose0_.SMT_RECORD_ID=?
Hibernate: select standardar0_.SMT_STANDARD_AREA_ID as SMT_STAN1_0_, standardar0_.SMT_STANDARD_AREA_NAME as SMT_STAN2_0_, standardar0_.SMT_STANDARD_AREA_DESC as SMT_STAN3_0_, standardar0_.SMT_STANDARD_AREA_APPROVED as SMT_STAN4_0_ from SMT_STANDARD_AREA standardar0_ where standardar0_.SMT_STANDARD_AREA_ID=?
Hibernate: select referstose0_.SMT_STANDARD_AREA_ID as SMT_STAN2___, referstose0_.SMT_RECORD_ID as SMT_RECO1___, referstose0_.SMT_RECORD_ID as SMT_RECO1_0_, referstose0_.SMT_STANDARD_AREA_ID as SMT_STAN2_0_ from SMT_REFERS_TO referstose0_ where referstose0_.SMT_STANDARD_AREA_ID=?
Hibernate: select recordvo0_.SMT_RECORD_ID as SMT_RECO1_8_, recordvo0_.VERSION as VERSION8_, recordvo0_.LAST_UPDATE as LAST_UPD3_8_, recordvo0_.BUSINESS_REQUIREMENTS as BUSINESS4_8_, recordvo0_.LOCAL_IMPACTS as LOCAL_IM5_8_, recordvo0_.INTEGRATION as INTEGRAT6_8_, recordvo0_.PRODUCT_NAME as PRODUCT_7_8_, recordvo0_.VENDOR_NAME as VENDOR_N8_8_, recordvo0_.APPROVAL_DATE as APPROVAL9_8_, recordvo0_.REVIEW_COMMENTS as REVIEW_10_8_, recordvo0_.PRODUCT_SPEC as PRODUCT11_8_, recordvo0_.APPROVAL_COMMENTS as APPROVA12_8_, recordvo0_.STATUS as STATUS8_, recordvo0_.RETIREMENT_COMMENTS as RETIREM14_8_, recordvo0_.ARCHIVING_DATE as ARCHIVI15_8_, recordvo0_.CREATION_DATE as CREATIO16_8_, recordvo0_.CATEGORY_ID as CATEGOR17_8_, recordvo0_.OWNEDBY as OWNEDBY8_, recordvo0_.APPROVEDBY as APPROVEDBY8_, recordvo0_.REQUESTEDBY as REQUEST20_8_, recordvo0_.RECORD_GROUP as RECORD_21_8_, categoryvo1_.SMT_CATEGORY_ID as SMT_CATE1_0_, categoryvo1_.SMT_CATEGORY_NAME as SMT_CATE2_0_, categoryvo1_.APPROVEDBY as APPROVEDBY0_, uservo2_.LOGIN as LOGIN1_, uservo2_.FIRSTNAME as FIRSTNAME1_, uservo2_.LASTNAME as LASTNAME1_, uservo2_.MAIL as MAIL1_, uservo2_.PASSWORD as PASSWORD1_, exceptionv3_.SMT_RECORD_ID as SMT_RECO1_2_, standardvo4_.SMT_RECORD_ID as SMT_RECO1_3_, standardvo4_.CONTRACT as CONTRACT3_, standardvo4_.CONTRACT_RESPONSIBLE as CONTRACT3_3_, standardvo4_.SUPPORT as SUPPORT3_, standardvo4_.TRAINING as TRAINING3_, standardvo4_.REVIEW_PERIOD as REVIEW_P6_3_, standardvo4_.UPDATE_PERIOD as UPDATE_P7_3_, standardvo4_.PLANNED_RETIREMENT as PLANNED_8_3_, uservo5_.LOGIN as LOGIN4_, uservo5_.FIRSTNAME as FIRSTNAME4_, uservo5_.LASTNAME as LASTNAME4_, uservo5_.MAIL as MAIL4_, uservo5_.PASSWORD as PASSWORD4_, uservo6_.LOGIN as LOGIN5_, uservo6_.FIRSTNAME as FIRSTNAME5_, uservo6_.LASTNAME as LASTNAME5_, uservo6_.MAIL as MAIL5_, uservo6_.PASSWORD as PASSWORD5_, uservo7_.LOGIN as LOGIN6_, uservo7_.FIRSTNAME as FIRSTNAME6_, uservo7_.LASTNAME as LASTNAME6_, uservo7_.MAIL as MAIL6_, uservo7_.PASSWORD as PASSWORD6_, recordgrou8_.SMT_RECORD_GROUP_ID as SMT_RECO1_7_ from SMT_RECORD recordvo0_ left outer join SMT_CATEGORY categoryvo1_ on recordvo0_.CATEGORY_ID=categoryvo1_.SMT_CATEGORY_ID left outer join SMT_USER uservo2_ on categoryvo1_.APPROVEDBY=uservo2_.LOGIN left outer join SMT_EXCEPTION exceptionv3_ on recordvo0_.SMT_RECORD_ID=exceptionv3_.SMT_RECORD_ID left outer join SMT_STANDARD standardvo4_ on recordvo0_.SMT_RECORD_ID=standardvo4_.SMT_RECORD_ID left outer join SMT_USER uservo5_ on recordvo0_.OWNEDBY=uservo5_.LOGIN left outer join SMT_USER uservo6_ on recordvo0_.APPROVEDBY=uservo6_.LOGIN left outer join SMT_USER uservo7_ on recordvo0_.REQUESTEDBY=uservo7_.LOGIN left outer join SMT_RECORD_GROUP recordgrou8_ on recordvo0_.RECORD_GROUP=recordgrou8_.SMT_RECORD_GROUP_ID where recordvo0_.SMT_RECORD_ID=?
Hibernate: select recordvo0_.SMT_RECORD_ID as SMT_RECO1_8_, recordvo0_.VERSION as VERSION8_, recordvo0_.LAST_UPDATE as LAST_UPD3_8_, recordvo0_.BUSINESS_REQUIREMENTS as BUSINESS4_8_, recordvo0_.LOCAL_IMPACTS as LOCAL_IM5_8_, recordvo0_.INTEGRATION as INTEGRAT6_8_, recordvo0_.PRODUCT_NAME as PRODUCT_7_8_, recordvo0_.VENDOR_NAME as VENDOR_N8_8_, recordvo0_.APPROVAL_DATE as APPROVAL9_8_, recordvo0_.REVIEW_COMMENTS as REVIEW_10_8_, recordvo0_.PRODUCT_SPEC as PRODUCT11_8_, recordvo0_.APPROVAL_COMMENTS as APPROVA12_8_, recordvo0_.STATUS as STATUS8_, recordvo0_.RETIREMENT_COMMENTS as RETIREM14_8_, recordvo0_.ARCHIVING_DATE as ARCHIVI15_8_, recordvo0_.CREATION_DATE as CREATIO16_8_, recordvo0_.CATEGORY_ID as CATEGOR17_8_, recordvo0_.OWNEDBY as OWNEDBY8_, recordvo0_.APPROVEDBY as APPROVEDBY8_, recordvo0_.REQUESTEDBY as REQUEST20_8_, recordvo0_.RECORD_GROUP as RECORD_21_8_, categoryvo1_.SMT_CATEGORY_ID as SMT_CATE1_0_, categoryvo1_.SMT_CATEGORY_NAME as SMT_CATE2_0_, categoryvo1_.APPROVEDBY as APPROVEDBY0_, uservo2_.LOGIN as LOGIN1_, uservo2_.FIRSTNAME as FIRSTNAME1_, uservo2_.LASTNAME as LASTNAME1_, uservo2_.MAIL as MAIL1_, uservo2_.PASSWORD as PASSWORD1_, exceptionv3_.SMT_RECORD_ID as SMT_RECO1_2_, standardvo4_.SMT_RECORD_ID as SMT_RECO1_3_, standardvo4_.CONTRACT as CONTRACT3_, standardvo4_.CONTRACT_RESPONSIBLE as CONTRACT3_3_, standardvo4_.SUPPORT as SUPPORT3_, standardvo4_.TRAINING as TRAINING3_, standardvo4_.REVIEW_PERIOD as REVIEW_P6_3_, standardvo4_.UPDATE_PERIOD as UPDATE_P7_3_, standardvo4_.PLANNED_RETIREMENT as PLANNED_8_3_, uservo5_.LOGIN as LOGIN4_, uservo5_.FIRSTNAME as FIRSTNAME4_, uservo5_.LASTNAME as LASTNAME4_, uservo5_.MAIL as MAIL4_, uservo5_.PASSWORD as PASSWORD4_, uservo6_.LOGIN as LOGIN5_, uservo6_.FIRSTNAME as FIRSTNAME5_, uservo6_.LASTNAME as LASTNAME5_, uservo6_.MAIL as MAIL5_, uservo6_.PASSWORD as PASSWORD5_, uservo7_.LOGIN as LOGIN6_, uservo7_.FIRSTNAME as FIRSTNAME6_, uservo7_.LASTNAME as LASTNAME6_, uservo7_.MAIL as MAIL6_, uservo7_.PASSWORD as PASSWORD6_, recordgrou8_.SMT_RECORD_GROUP_ID as SMT_RECO1_7_ from SMT_RECORD recordvo0_ left outer join SMT_CATEGORY categoryvo1_ on recordvo0_.CATEGORY_ID=categoryvo1_.SMT_CATEGORY_ID left outer join SMT_USER uservo2_ on categoryvo1_.APPROVEDBY=uservo2_.LOGIN left outer join SMT_EXCEPTION exceptionv3_ on recordvo0_.SMT_RECORD_ID=exceptionv3_.SMT_RECORD_ID left outer join SMT_STANDARD standardvo4_ on recordvo0_.SMT_RECORD_ID=standardvo4_.SMT_RECORD_ID left outer join SMT_USER uservo5_ on recordvo0_.OWNEDBY=uservo5_.LOGIN left outer join SMT_USER uservo6_ on recordvo0_.APPROVEDBY=uservo6_.LOGIN left outer join SMT_USER uservo7_ on recordvo0_.REQUESTEDBY=uservo7_.LOGIN left outer join SMT_RECORD_GROUP recordgrou8_ on recordvo0_.RECORD_GROUP=recordgrou8_.SMT_RECORD_GROUP_ID where recordvo0_.SMT_RECORD_ID=?
Hibernate: select referstose0_.SMT_RECORD_ID as SMT_RECO1___, referstose0_.SMT_STANDARD_AREA_ID as SMT_STAN2___, referstose0_.SMT_RECORD_ID as SMT_RECO1_0_, referstose0_.SMT_STANDARD_AREA_ID as SMT_STAN2_0_ from SMT_REFERS_TO referstose0_ where referstose0_.SMT_RECORD_ID=?
Hibernate: select referstose0_.SMT_RECORD_ID as SMT_RECO1___, referstose0_.SMT_STANDARD_AREA_ID as SMT_STAN2___, referstose0_.SMT_RECORD_ID as SMT_RECO1_0_, referstose0_.SMT_STANDARD_AREA_ID as SMT_STAN2_0_ from SMT_REFERS_TO referstose0_ where referstose0_.SMT_RECORD_ID=?
Hibernate: select containsse0_.SMT_STANDARD_AREA_ID as SMT_STAN1___, containsse0_.SMT_CATEGORY_ID as SMT_CATE2___, containsse0_.SMT_STANDARD_AREA_ID as SMT_STAN1_0_, containsse0_.SMT_CATEGORY_ID as SMT_CATE2_0_ from SMT_CONTAINS containsse0_ where containsse0_.SMT_STANDARD_AREA_ID=?
Hibernate: select recordsset0_.RECORD_GROUP as RECORD_21___, recordsset0_.SMT_RECORD_ID as SMT_RECO1___, recordsset0_.SMT_RECORD_ID as SMT_RECO1_7_, recordsset0_.VERSION as VERSION7_, recordsset0_.LAST_UPDATE as LAST_UPD3_7_, recordsset0_.BUSINESS_REQUIREMENTS as BUSINESS4_7_, recordsset0_.LOCAL_IMPACTS as LOCAL_IM5_7_, recordsset0_.INTEGRATION as INTEGRAT6_7_, recordsset0_.PRODUCT_NAME as PRODUCT_7_7_, recordsset0_.VENDOR_NAME as VENDOR_N8_7_, recordsset0_.APPROVAL_DATE as APPROVAL9_7_, recordsset0_.REVIEW_COMMENTS as REVIEW_10_7_, recordsset0_.PRODUCT_SPEC as PRODUCT11_7_, recordsset0_.APPROVAL_COMMENTS as APPROVA12_7_, recordsset0_.STATUS as STATUS7_, recordsset0_.RETIREMENT_COMMENTS as RETIREM14_7_, recordsset0_.ARCHIVING_DATE as ARCHIVI15_7_, recordsset0_.CREATION_DATE as CREATIO16_7_, recordsset0_.CATEGORY_ID as CATEGOR17_7_, recordsset0_.OWNEDBY as OWNEDBY7_, recordsset0_.APPROVEDBY as APPROVEDBY7_, recordsset0_.REQUESTEDBY as REQUEST20_7_, recordsset0_.RECORD_GROUP as RECORD_21_7_, categoryvo1_.SMT_CATEGORY_ID as SMT_CATE1_0_, categoryvo1_.SMT_CATEGORY_NAME as SMT_CATE2_0_, categoryvo1_.APPROVEDBY as APPROVEDBY0_, uservo2_.LOGIN as LOGIN1_, uservo2_.FIRSTNAME as FIRSTNAME1_, uservo2_.LASTNAME as LASTNAME1_, uservo2_.MAIL as MAIL1_, uservo2_.PASSWORD as PASSWORD1_, exceptionv3_.SMT_RECORD_ID as SMT_RECO1_2_, standardvo4_.SMT_RECORD_ID as SMT_RECO1_3_, standardvo4_.CONTRACT as CONTRACT3_, standardvo4_.CONTRACT_RESPONSIBLE as CONTRACT3_3_, standardvo4_.SUPPORT as SUPPORT3_, standardvo4_.TRAINING as TRAINING3_, standardvo4_.REVIEW_PERIOD as REVIEW_P6_3_, standardvo4_.UPDATE_PERIOD as UPDATE_P7_3_, standardvo4_.PLANNED_RETIREMENT as PLANNED_8_3_, uservo5_.LOGIN as LOGIN4_, uservo5_.FIRSTNAME as FIRSTNAME4_, uservo5_.LASTNAME as LASTNAME4_, uservo5_.MAIL as MAIL4_, uservo5_.PASSWORD as PASSWORD4_, uservo6_.LOGIN as LOGIN5_, uservo6_.FIRSTNAME as FIRSTNAME5_, uservo6_.LASTNAME as LASTNAME5_, uservo6_.MAIL as MAIL5_, uservo6_.PASSWORD as PASSWORD5_, uservo7_.LOGIN as LOGIN6_, uservo7_.FIRSTNAME as FIRSTNAME6_, uservo7_.LASTNAME as LASTNAME6_, uservo7_.MAIL as MAIL6_, uservo7_.PASSWORD as PASSWORD6_ from SMT_RECORD recordsset0_ left outer join SMT_CATEGORY categoryvo1_ on recordsset0_.CATEGORY_ID=categoryvo1_.SMT_CATEGORY_ID left outer join SMT_USER uservo2_ on categoryvo1_.APPROVEDBY=uservo2_.LOGIN left outer join SMT_EXCEPTION exceptionv3_ on recordsset0_.SMT_RECORD_ID=exceptionv3_.SMT_RECORD_ID left outer join SMT_STANDARD standardvo4_ on recordsset0_.SMT_RECORD_ID=standardvo4_.SMT_RECORD_ID left outer join SMT_USER uservo5_ on recordsset0_.OWNEDBY=uservo5_.LOGIN left outer join SMT_USER uservo6_ on recordsset0_.APPROVEDBY=uservo6_.LOGIN left outer join SMT_USER uservo7_ on recordsset0_.REQUESTEDBY=uservo7_.LOGIN where recordsset0_.RECORD_GROUP=?

Also you mapping files (only for the relevant classes) and the code.

Two representation of the collection 'businessCaseAttachSet' were found. Are you passing one in and then loading another?

My mapping files :

* Record.hbm.xml :

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd" >

<hibernate-mapping>
<class name="intra.novartis.pharma.smt.dao.RecordVO" table="SMT_RECORD" >
<id name="recordId" type="java.lang.Integer" column="SMT_RECORD_ID" >
<generator class="sequence">
<param name="sequence">SMT_RECORD_SEQ</param>
</generator>
</id>
<property name="version" type="java.lang.String" column="VERSION" length="20" />
<property name="lastUpdate" type="java.sql.Date" column="LAST_UPDATE" length="7"
/>
<property name="businessRequirements" type="java.lang.String"
column="BUSINESS_REQUIREMENTS" length="4000" />
<property name="localImpacts" type="java.lang.String" column="LOCAL_IMPACTS"
length="4000" />
<property name="integration" type="java.lang.String" column="INTEGRATION"
length="4000" />
<property name="productName" type="java.lang.String" column="PRODUCT_NAME"
length="255" />
<property name="vendorName" type="java.lang.String" column="VENDOR_NAME"
length="255" />
<property name="approvalDate" type="java.sql.Date" column="APPROVAL_DATE"
length="7" />
<property name="reviewComments" type="java.lang.String" column="REVIEW_COMMENTS"
length="4000" />
<property name="productSpec" type="java.lang.String" column="PRODUCT_SPEC"
length="4000" />
<property name="approvalComments" type="java.lang.String"
column="APPROVAL_COMMENTS" length="4000" />
<property name="status" type="java.lang.String" column="STATUS" length="255" />
<property name="retirementComments" type="java.lang.String"
column="RETIREMENT_COMMENTS" length="4000" />
<property name="archivingDate" type="java.sql.Date" column="ARCHIVING_DATE"
length="7" />
<property name="creationDate" type="java.sql.Date" column="CREATION_DATE"
length="7" />
<!-- associations -->
<!-- bi-directional many-to-one association to SmtCategory -->
<many-to-one name="categoryByCategory"
class="intra.novartis.pharma.smt.dao.CategoryVO" not-null="true" >
<column name="CATEGORY_ID" />
</many-to-one>
<!-- bi-directional one-to-many association to SmtGenerat -->
<set name="generatesSet" lazy="true" inverse="true" >
<key>
<column name="SMT_RECORD_ID" />
</key>
<one-to-many class="intra.novartis.pharma.smt.dao.GeneratesVO" />
</set>
<!-- bi-directional one-to-many association to SmtGet -->
<set name="getsSet" lazy="true" inverse="true" >
<key>
<column name="SMT_RECORD_ID" />
</key>
<one-to-many class="intra.novartis.pharma.smt.dao.GetsVO" />
</set>
<!-- bi-directional one-to-many association to SmtMak -->
<set name="makesSet" lazy="true" inverse="true" >
<key>
<column name="SMT_RECORD_ID" />
</key>
<one-to-many class="intra.novartis.pharma.smt.dao.MakesVO" />
</set>
<!-- bi-directional one-to-one association to SmtException -->
<one-to-one name="exception" class="intra.novartis.pharma.smt.dao.ExceptionVO"
outer-join="auto" />
<!-- bi-directional one-to-many association to SmtProductAttach -->
<set name="productAttachSet" lazy="true" inverse="true" >
<key>
<column name="SMT_RECORD_ID" />
</key>
<one-to-many class="intra.novartis.pharma.smt.dao.ProductAttachVO" />
</set>
<!-- bi-directional one-to-one association to SmtStandard -->
<one-to-one name="standard" class="intra.novartis.pharma.smt.dao.StandardVO"
outer-join="auto" />
<!-- bi-directional one-to-many association to SmtBusinessCaseAttach -->
<set name="businessCaseAttachSet" lazy="true" inverse="true" >
<key>
<column name="SMT_RECORD_ID" />
</key>
<one-to-many class="intra.novartis.pharma.smt.dao.BusinessCaseAttachVO" />
</set>
<!-- bi-directional one-to-many association to SmtRefersTo -->
<set name="refersToSet" lazy="false" inverse="true" >
<key>
<column name="SMT_RECORD_ID" />
</key>
<one-to-many class="intra.novartis.pharma.smt.dao.RefersToVO" />
</set>
<!-- bi-directional many-to-one association to SmtUser -->
<many-to-one name="userByOwnedBy" class="intra.novartis.pharma.smt.dao.UserVO"
not-null="true" >
<column name="OWNEDBY" />
</many-to-one>
<!-- bi-directional many-to-one association to SmtUser -->
<many-to-one name="userByApprovedBy"
class="intra.novartis.pharma.smt.dao.UserVO" not-null="true" >
<column name="APPROVEDBY" />
</many-to-one>
<!-- bi-directional many-to-one association to SmtUser -->
<many-to-one name="userByRequestedBy"
class="intra.novartis.pharma.smt.dao.UserVO" not-null="true" >
<column name="REQUESTEDBY" />
</many-to-one>
<!-- bi-directional many-to-one association to RecordGroup -->
<many-to-one name="recordGroup"
class="intra.novartis.pharma.smt.dao.RecordGroupVO" not-null="true"
unique="false" outer-join="auto" update="true" insert="true">
<column name="RECORD_GROUP" />
</many-to-one>
</class>
</hibernate-mapping>

* BusinessCaseAttach.hbm.xml :

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd" >

<hibernate-mapping>
<class name="intra.novartis.pharma.smt.dao.BusinessCaseAttachVO"
table="SMT_BUSINESS_CASE_ATTACH">
<composite-id name="comp_id" class="intra.novartis.pharma.smt.dao.BusinessCaseAttachPK">
<!-- bi-directional many-to-one association to SmtRecord -->
<key-many-to-one name="record" class="intra.novartis.pharma.smt.dao.RecordVO" >
<column name="SMT_RECORD_ID" />
</key-many-to-one>
<!-- bi-directional many-to-one association to SmtFile -->
<key-many-to-one name="file" class="intra.novartis.pharma.smt.dao.FileVO">
<column name="SMT_FILE_ID" />
</key-many-to-one>
</composite-id>
</class>
</hibernate-mapping>

and my code source, I have a Java class which call my facade (in this facade I perforn the code) :

* toto.java :

void test(){
...

this.getCommonFacade().saveNewVersionOfMaintenanceRequest( Constants.SUBMITED_MAINTENANCE_REQUEST,requester,recordVO, maintenanceRequestForm.getRecordVO(), maintenanceRequestForm.getUserVO(), finalCategoryVO, maintenanceRequestForm.getSelectedRisk(), maintenanceRequestForm.getStandardAreaList(), maintenanceRequestForm.getStandardVO(), maintenanceRequestForm.getOldBusiness1(), getFileVOFromFormFile(maintenanceRequestForm.getBusinessCaseFormFile1()),maintenanceRequestForm.getOldBusiness2(), getFileVOFromFormFile(maintenanceRequestForm.getBusinessCaseFormFile2()), maintenanceRequestForm.getOldProduct1(), getFileVOFromFormFile(maintenanceRequestForm.getProductFormFile1()), maintenanceRequestForm.getOldProduct2(), getFileVOFromFormFile(maintenanceRequestForm.getProductFormFile2()));

...
}

and In my facade :

* CommonFacadejava :

public void saveNewVersionOfMaintenanceRequest(String status, UserVO requester, RecordVO recordVO, RecordVO recordVOFromForm, UserVO userVO, CategoryVO categoryVO, Integer[] selectedRisk, Integer[] standardAreaList, StandardVO standardVO, Integer oldBusinessId1, FileVO businessCaseFile1, Integer oldBusinessId2, FileVO businessCaseFile2, Integer oldProductId1, FileVO productFile1, Integer oldProductId2, FileVO productFile2) {
commonDAO.saveOrUpdateUser(requester);
//UserVO
commonDAO.saveOrUpdateUser(userVO);
//RecordVO
recordVO.setCategoryByCategory(categoryVO);
recordVO.setReviewComments(recordVOFromForm.getReviewComments());
recordVO.setBusinessRequirements(recordVOFromForm.getBusinessRequirements());
recordVO.setIntegration(recordVOFromForm.getIntegration());
recordVO.setLocalImpacts(recordVOFromForm.getLocalImpacts());
recordVO.setProductName(recordVOFromForm.getProductName());
recordVO.setProductSpec(recordVOFromForm.getProductSpec());
recordVO.setVendorName(recordVOFromForm.getVendorName());
recordVO.setVersion(recordVOFromForm.getVersion());
recordVO.setUserByOwnedBy(userVO);
recordVO.setUserByRequestedBy(requester);
recordVO.setLastUpdate(new Date());
recordVO.setCreationDate(new Date());

if(!(StringUtils.isNullOrEmpty(recordVO.getRecordId().toString())) && !(recordVO.getStatus().equals(Constants.USED))) {
recordVO.setStatus(status);
commonDAO.saveOrUpdateRecord(recordVO);
//StandardVO
standardVO.setRecord(recordVO);
commonDAO.saveOrUpdateStandard(standardVO);
commonDAO.deleteOldGets(recordVO.getRecordId());
commonDAO.deleteOldRefersTOByRecord(recordVO.getRecordId());
}
else {
recordVO.setStatus(status);
commonDAO.save(recordVO);
//StandardVO
standardVO.setRecord(recordVO);
standardVO.setRecordId(recordVO.getRecordId());
commonDAO.save(standardVO);
}

//SelectedRisks
for (int i = 0; i < selectedRisk.length; i++)
commonDAO.save(new GetsVO(new GetsPK((RiskVO)commonDAO.get(RiskVO.class, selectedRisk[i]), recordVO)));
//RefersToVOs
for (int i = 0; i < standardAreaList.length; i++)
commonDAO.save(new RefersToVO(new RefersToPK(recordVO, (StandardAreaVO)commonDAO.get(StandardAreaVO.class, standardAreaList[i]))));
//Files
this.businessProcess(recordVO, oldBusinessId1, businessCaseFile1);
this.businessProcess(recordVO, oldBusinessId2, businessCaseFile2);
this.productProcess( recordVO, oldProductId1, productFile1);
this.productProcess( recordVO, oldProductId2, productFile2);


Thanks