Duplicate Hibernate mapping exception

[Mohammed Yasir]

Hi All,
I've been getting this error for quiet some time in my application.

I have tested the application on local setup it seems to work fine but when i deploy it on dev ENV i get the below error.
The application seems to run fine at certain times and i get the error some times.
i am clueless on where the problem is.
Below is the stack trace

i have checked my Hibernate.cfg.xml file
there are no duplicate entries
I dont get this error all the times.
we create a new session when a particular factory is selected.

2011-10-25 08:40:32,862 ERROR com.myapp.rtvq.hibernate.HibernateSessionFactory - exception during rebuild Session Factory
org.hibernate.MappingException: Could not read mappings from resource: com/myapp/rtvq/hibernate/mappings/Equipment.hbm.xml
	at org.hibernate.cfg.Configuration.addResource(Configuration.java:485)
	at org.hibernate.cfg.Configuration.parseMappingElement(Configuration.java:1465)
	at org.hibernate.cfg.Configuration.parseSessionFactory(Configuration.java:1433)
	at org.hibernate.cfg.Configuration.doConfigure(Configuration.java:1414)
	at org.hibernate.cfg.Configuration.doConfigure(Configuration.java:1390)
	at org.hibernate.cfg.Configuration.configure(Configuration.java:1310)
	at com.myapp.rtvq.hibernate.HibernateSessionFactory.rebuildSessionFactory(HibernateSessionFactory.java:98)
	at com.myapp.rtvq.hibernate.HibernateSessionFactory.getSession(HibernateSessionFactory.java:69)
	at com.myapp.rtvq.hibernate.BaseHibernateDAO.getSession(BaseHibernateDAO.java:14)
	at com.myapp.rtvq.dao.PersonDataDAO.getSession(PersonDataDAO.java:102)
	at com.myapp.rtvq.dao.PersonDataDAO.findByProperty(PersonDataDAO.java:167)
	at com.myapp.rtvq.dao.PersonDataDAO.findById(PersonDataDAO.java:189)
	at com.myapp.rtvq.ejb.PersonManagement.getPersonById(PersonManagement.java:78)
	at com.myapp.rtvq.ejb.PersonManagement_oqnob4_ELOImpl.getPersonById(PersonManagement_oqnob4_ELOImpl.java:321)
	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:585)
	at org.apache.beehive.controls.system.ejb.EJBControlImpl.invoke(EJBControlImpl.java:403)
	at com.myapp.rtvq.control.PersonControlBean.getPersonById(PersonControlBean.java:1297)
	at com.myapp.rtvq.config.RTVQController.onCreate(RTVQController.java:265)
	at home.HomeController.onCreate(HomeController.java:505)
	at home.HomeController.redirect(HomeController.java:317)
	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:585)
	at org.apache.beehive.netui.pageflow.FlowController.invokeActionMethod(FlowController.java:879)
	at org.apache.beehive.netui.pageflow.FlowController.getActionMethodForward(FlowController.java:809)
	at org.apache.beehive.netui.pageflow.FlowController.internalExecute(FlowController.java:478)
	at org.apache.beehive.netui.pageflow.PageFlowController.internalExecute(PageFlowController.java:306)
	at org.apache.beehive.netui.pageflow.FlowController.execute(FlowController.java:336)
	at org.apache.beehive.netui.pageflow.internal.FlowControllerAction.execute(FlowControllerAction.java:52)
	at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
	at org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.access$201(PageFlowRequestProcessor.java:97)
	at org.apache.beehive.netui.pageflow.PageFlowRequestProcessor$ActionRunner.execute(PageFlowRequestProcessor.java:2044)
	at org.apache.beehive.netui.pageflow.interceptor.action.internal.ActionInterceptors.wrapAction(ActionInterceptors.java:91)
	at org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.processActionPerform(PageFlowRequestProcessor.java:2116)
	at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
	at org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.processInternal(PageFlowRequestProcessor.java:556)
	at org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.process(PageFlowRequestProcessor.java:853)
	at org.apache.beehive.netui.pageflow.AutoRegisterActionServlet.process(AutoRegisterActionServlet.java:631)
	at org.apache.beehive.netui.pageflow.PageFlowActionServlet.process(PageFlowActionServlet.java:158)
	at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
	at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:226)
	at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:124)
	at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:283)
	at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:175)
	at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3392)
	at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
	at weblogic.security.service.SecurityManager.runAs(Unknown Source)
	at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2140)
	at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2046)
	at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1366)
	at weblogic.work.ExecuteThread.execute(ExecuteThread.java:200)
	at weblogic.work.ExecuteThread.run(ExecuteThread.java:172)
Caused by: org.hibernate.DuplicateMappingException: Duplicate collection role mapping com.myapp.rtvq.vo.EquipmentVO.skilltypeXrefs
	at org.hibernate.cfg.Mappings.addCollection(Mappings.java:124)
	at org.hibernate.cfg.HbmBinder.createClassProperties(HbmBinder.java:2030)
	at org.hibernate.cfg.HbmBinder.createClassProperties(HbmBinder.java:2005)
	at org.hibernate.cfg.HbmBinder.bindRootPersistentClassCommonValues(HbmBinder.java:368)
	at org.hibernate.cfg.HbmBinder.bindRootClass(HbmBinder.java:282)
	at org.hibernate.cfg.HbmBinder.bindRoot(HbmBinder.java:153)
	at org.hibernate.cfg.Configuration.add(Configuration.java:386)
	at org.hibernate.cfg.Configuration.addInputStream(Configuration.java:427)
	at org.hibernate.cfg.Configuration.addResource(Configuration.java:482)
	... 57 more
2011-10-25 08:40:32,865 ERROR com.myapp.rtvq.dao.PersonDataDAO - find by property name failed
java.lang.NullPointerException
	at com.myapp.rtvq.hibernate.HibernateSessionFactory.getSession(HibernateSessionFactory.java:79)
	at com.myapp.rtvq.hibernate.BaseHibernateDAO.getSession(BaseHibernateDAO.java:14)
	at com.myapp.rtvq.dao.PersonDataDAO.getSession(PersonDataDAO.java:102)
	at com.myapp.rtvq.dao.PersonDataDAO.findByProperty(PersonDataDAO.java:167)
	at com.myapp.rtvq.dao.PersonDataDAO.findBymyappId(PersonDataDAO.java:189)
	at com.myapp.rtvq.ejb.PersonManagement.getPersonById(PersonManagement.java:78)
	at com.myapp.rtvq.ejb.PersonManagement_oqnob4_ELOImpl.getPersonById(PersonManagement_oqnob4_ELOImpl.java:321)
	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:585)
	at org.apache.beehive.controls.system.ejb.EJBControlImpl.invoke(EJBControlImpl.java:403)
	at com.myapp.rtvq.control.PersonControlBean.getPersonById(PersonControlBean.java:1297)
	at com.myapp.rtvq.config.RTVQController.onCreate(RTVQController.java:265)
	at home.HomeController.onCreate(HomeController.java:505)
	at home.HomeController.redirect(HomeController.java:317)
	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:585)
	at org.apache.beehive.netui.pageflow.FlowController.invokeActionMethod(FlowController.java:879)
	at org.apache.beehive.netui.pageflow.FlowController.getActionMethodForward(FlowController.java:809)
	at org.apache.beehive.netui.pageflow.FlowController.internalExecute(FlowController.java:478)
	at org.apache.beehive.netui.pageflow.PageFlowController.internalExecute(PageFlowController.java:306)
	at org.apache.beehive.netui.pageflow.FlowController.execute(FlowController.java:336)
	at org.apache.beehive.netui.pageflow.internal.FlowControllerAction.execute(FlowControllerAction.java:52)
	at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
	at org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.access$201(PageFlowRequestProcessor.java:97)
	at org.apache.beehive.netui.pageflow.PageFlowRequestProcessor$ActionRunner.execute(PageFlowRequestProcessor.java:2044)
	at org.apache.beehive.netui.pageflow.interceptor.action.internal.ActionInterceptors.wrapAction(ActionInterceptors.java:91)
	at org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.processActionPerform(PageFlowRequestProcessor.java:2116)
	at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
	at org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.processInternal(PageFlowRequestProcessor.java:556)
	at org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.process(PageFlowRequestProcessor.java:853)
	at org.apache.beehive.netui.pageflow.AutoRegisterActionServlet.process(AutoRegisterActionServlet.java:631)
	at org.apache.beehive.netui.pageflow.PageFlowActionServlet.process(PageFlowActionServlet.java:158)
	at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
	at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:226)
	at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:124)
	at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:283)
	at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:175)
	at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3392)
	at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
	at weblogic.security.service.SecurityManager.runAs(Unknown Source)
	at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2140)
	at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2046)
	at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1366)
	at weblogic.work.ExecuteThread.execute(ExecuteThread.java:200)
	at weblogic.work.ExecuteThread.run(ExecuteThread.java:172)
2011-10-25 08:40:32,875 ERROR com.myapp.rtvq.config.RTVQController - HUGE ERROR - 
com.myapp.rtvq.exception.PersonDataBOException: Unexpected error retrieving person
	at com.myapp.rtvq.ejb.PersonManagement.getPersonById(PersonManagement.java:93)
	at com.myapp.rtvq.ejb.PersonManagement_oqnob4_ELOImpl.getPersonById(PersonManagement_oqnob4_ELOImpl.java:321)
	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:585)
	at org.apache.beehive.controls.system.ejb.EJBControlImpl.invoke(EJBControlImpl.java:403)
	at com.myapp.rtvq.control.PersonControlBean.getPersonById(PersonControlBean.java:1297)
	at com.myapp.rtvq.config.RTVQController.onCreate(RTVQController.java:265)
	at home.HomeController.onCreate(HomeController.java:505)
	at home.HomeController.redirect(HomeController.java:317)
	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:585)
	at org.apache.beehive.netui.pageflow.FlowController.invokeActionMethod(FlowController.java:879)
	at org.apache.beehive.netui.pageflow.FlowController.getActionMethodForward(FlowController.java:809)
	at org.apache.beehive.netui.pageflow.FlowController.internalExecute(FlowController.java:478)
	at org.apache.beehive.netui.pageflow.PageFlowController.internalExecute(PageFlowController.java:306)
	at org.apache.beehive.netui.pageflow.FlowController.execute(FlowController.java:336)
	at org.apache.beehive.netui.pageflow.internal.FlowControllerAction.execute(FlowControllerAction.java:52)
	at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
	at org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.access$201(PageFlowRequestProcessor.java:97)
	at org.apache.beehive.netui.pageflow.PageFlowRequestProcessor$ActionRunner.execute(PageFlowRequestProcessor.java:2044)
	at org.apache.beehive.netui.pageflow.interceptor.action.internal.ActionInterceptors.wrapAction(ActionInterceptors.java:91)
	at org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.processActionPerform(PageFlowRequestProcessor.java:2116)
	at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
	at org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.processInternal(PageFlowRequestProcessor.java:556)
	at org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.process(PageFlowRequestProcessor.java:853)
	at org.apache.beehive.netui.pageflow.AutoRegisterActionServlet.process(AutoRegisterActionServlet.java:631)
	at org.apache.beehive.netui.pageflow.PageFlowActionServlet.process(PageFlowActionServlet.java:158)
	at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
	at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:226)
	at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:124)
	at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:283)
	at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:175)
	at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3392)
	at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
	at weblogic.security.service.SecurityManager.runAs(Unknown Source)
	at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2140)
	at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2046)
	at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1366)
	at weblogic.work.ExecuteThread.execute(ExecuteThread.java:200)
	at weblogic.work.ExecuteThread.run(ExecuteThread.java:172)
Caused by: com.myapp.rtvq.exception.PersonDataDAOException
	at com.myapp.rtvq.dao.PersonDataDAO.findByProperty(PersonDataDAO.java:183)
	at com.myapp.rtvq.dao.PersonDataDAO.findBymyappId(PersonDataDAO.java:189)
	at com.myapp.rtvq.ejb.PersonManagement.getPersonById(PersonManagement.java:78)
	... 45 more
2011-10-25 08:40:32,877 INFO  home.HomeController - Redirect to home page
2011-10-25 08:40:32,877 ERROR com.myapp.rtvq.config.RTVQController - XXXX- factoryName attribute in session is KOMAROM
2011-10-25 08:40:32,936 ERROR com.myapp.rtvq.hibernate.HibernateSessionFactory - exception during rebuild Session Factory
org.hibernate.MappingException: Could not read mappings from resource: com/myapp/rtvq/hibernate/mappings/Equipment.hbm.xml
	at org.hibernate.cfg.Configuration.addResource(Configuration.java:485)
	at org.hibernate.cfg.Configuration.parseMappingElement(Configuration.java:1465)
	at org.hibernate.cfg.Configuration.parseSessionFactory(Configuration.java:1433)
	at org.hibernate.cfg.Configuration.doConfigure(Configuration.java:1414)
	at org.hibernate.cfg.Configuration.doConfigure(Configuration.java:1390)
	at org.hibernate.cfg.Configuration.configure(Configuration.java:1310)
	at com.myapp.rtvq.hibernate.HibernateSessionFactory.rebuildSessionFactory(HibernateSessionFactory.java:98)
	at com.myapp.rtvq.hibernate.HibernateSessionFactory.getSession(HibernateSessionFactory.java:69)
	at com.myapp.rtvq.hibernate.BaseHibernateDAO.getSession(BaseHibernateDAO.java:14)
	at com.myapp.rtvq.dao.FactoryDAO.getSession(FactoryDAO.java:33)
	at com.myapp.rtvq.dao.FactoryDAO.findByProperty(FactoryDAO.java:95)
	at com.myapp.rtvq.dao.FactoryDAO.findByFactoryName(FactoryDAO.java:107)
	at com.myapp.rtvq.ejb.PersonManagement.getFactoryByName(PersonManagement.java:288)
	at com.myapp.rtvq.ejb.PersonManagement_oqnob4_ELOImpl.getFactoryByName(PersonManagement_oqnob4_ELOImpl.java:1410)
	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:585)
	at org.apache.beehive.controls.system.ejb.EJBControlImpl.invoke(EJBControlImpl.java:403)
	at com.myapp.rtvq.control.PersonControlBean.getFactoryByName(PersonControlBean.java:505)
	at com.myapp.rtvq.config.RTVQController.getFactory(RTVQController.java:811)
	at home.HomeController.getPersonRole(HomeController.java:1892)
	at home.HomeController.redirect(HomeController.java:322)
	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:585)
	at org.apache.beehive.netui.pageflow.FlowController.invokeActionMethod(FlowController.java:879)
	at org.apache.beehive.netui.pageflow.FlowController.getActionMethodForward(FlowController.java:809)
	at org.apache.beehive.netui.pageflow.FlowController.internalExecute(FlowController.java:478)
	at org.apache.beehive.netui.pageflow.PageFlowController.internalExecute(PageFlowController.java:306)
	at org.apache.beehive.netui.pageflow.FlowController.execute(FlowController.java:336)
	at org.apache.beehive.netui.pageflow.internal.FlowControllerAction.execute(FlowControllerAction.java:52)
	at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
	at org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.access$201(PageFlowRequestProcessor.java:97)
	at org.apache.beehive.netui.pageflow.PageFlowRequestProcessor$ActionRunner.execute(PageFlowRequestProcessor.java:2044)
	at org.apache.beehive.netui.pageflow.interceptor.action.internal.ActionInterceptors.wrapAction(ActionInterceptors.java:91)
	at org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.processActionPerform(PageFlowRequestProcessor.java:2116)
	at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
	at org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.processInternal(PageFlowRequestProcessor.java:556)
	at org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.process(PageFlowRequestProcessor.java:853)
	at org.apache.beehive.netui.pageflow.AutoRegisterActionServlet.process(AutoRegisterActionServlet.java:631)
	at org.apache.beehive.netui.pageflow.PageFlowActionServlet.process(PageFlowActionServlet.java:158)
	at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
	at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:226)
	at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:124)
	at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:283)
	at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:175)
	at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3392)
	at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
	at weblogic.security.service.SecurityManager.runAs(Unknown Source)
	at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2140)
	at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2046)
	at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1366)
	at weblogic.work.ExecuteThread.execute(ExecuteThread.java:200)
	at weblogic.work.ExecuteThread.run(ExecuteThread.java:172)
Caused by: org.hibernate.DuplicateMappingException: Duplicate collection role mapping com.myapp.rtvq.vo.EquipmentVO.skilltypeXrefs
	at org.hibernate.cfg.Mappings.addCollection(Mappings.java:124)
	at org.hibernate.cfg.HbmBinder.createClassProperties(HbmBinder.java:2030)
	at org.hibernate.cfg.HbmBinder.createClassProperties(HbmBinder.java:2005)
	at org.hibernate.cfg.HbmBinder.bindRootPersistentClassCommonValues(HbmBinder.java:368)
	at org.hibernate.cfg.HbmBinder.bindRootClass(HbmBinder.java:282)
	at org.hibernate.cfg.HbmBinder.bindRoot(HbmBinder.java:153)
	at org.hibernate.cfg.Configuration.add(Configuration.java:386)
	at org.hibernate.cfg.Configuration.addInputStream(Configuration.java:427)
	at org.hibernate.cfg.Configuration.addResource(Configuration.java:482)
	... 57 more
2011-10-25 08:40:32,939 ERROR com.myapp.rtvq.dao.FactoryDAO - find by property name failed
java.lang.NullPointerException
	at com.myapp.rtvq.hibernate.HibernateSessionFactory.getSession(HibernateSessionFactory.java:79)
	at com.myapp.rtvq.hibernate.BaseHibernateDAO.getSession(BaseHibernateDAO.java:14)
	at com.myapp.rtvq.dao.FactoryDAO.getSession(FactoryDAO.java:33)
	at com.myapp.rtvq.dao.FactoryDAO.findByProperty(FactoryDAO.java:95)
	at com.myapp.rtvq.dao.FactoryDAO.findByFactoryName(FactoryDAO.java:107)
	at com.myapp.rtvq.ejb.PersonManagement.getFactoryByName(PersonManagement.java:288)
	at com.myapp.rtvq.ejb.PersonManagement_oqnob4_ELOImpl.getFactoryByName(PersonManagement_oqnob4_ELOImpl.java:1410)
	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:585)
	at org.apache.beehive.controls.system.ejb.EJBControlImpl.invoke(EJBControlImpl.java:403)
	at com.myapp.rtvq.control.PersonControlBean.getFactoryByName(PersonControlBean.java:505)
	at com.myapp.rtvq.config.RTVQController.getFactory(RTVQController.java:811)
	at home.HomeController.getPersonRole(HomeController.java:1892)
	at home.HomeController.redirect(HomeController.java:322)
	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:585)
	at org.apache.beehive.netui.pageflow.FlowController.invokeActionMethod(FlowController.java:879)
	at org.apache.beehive.netui.pageflow.FlowController.getActionMethodForward(FlowController.java:809)
	at org.apache.beehive.netui.pageflow.FlowController.internalExecute(FlowController.java:478)
	at org.apache.beehive.netui.pageflow.PageFlowController.internalExecute(PageFlowController.java:306)
	at org.apache.beehive.netui.pageflow.FlowController.execute(FlowController.java:336)
	at org.apache.beehive.netui.pageflow.internal.FlowControllerAction.execute(FlowControllerAction.java:52)
	at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
	at org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.access$201(PageFlowRequestProcessor.java:97)
	at org.apache.beehive.netui.pageflow.PageFlowRequestProcessor$ActionRunner.execute(PageFlowRequestProcessor.java:2044)
	at org.apache.beehive.netui.pageflow.interceptor.action.internal.ActionInterceptors.wrapAction(ActionInterceptors.java:91)
	at org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.processActionPerform(PageFlowRequestProcessor.java:2116)
	at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
	at org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.processInternal(PageFlowRequestProcessor.java:556)
	at org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.process(PageFlowRequestProcessor.java:853)
	at org.apache.beehive.netui.pageflow.AutoRegisterActionServlet.process(AutoRegisterActionServlet.java:631)
	at org.apache.beehive.netui.pageflow.PageFlowActionServlet.process(PageFlowActionServlet.java:158)
	at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
	at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:226)
	at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:124)
	at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:283)
	at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:175)
	at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3392)
	at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
	at weblogic.security.service.SecurityManager.runAs(Unknown Source)
	at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2140)
	at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2046)
	at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1366)
	at weblogic.work.ExecuteThread.execute(ExecuteThread.java:200)
	at weblogic.work.ExecuteThread.run(ExecuteThread.java:172)
2011-10-25 08:40:32,942 ERROR com.myapp.rtvq.config.RTVQController - XXXX- Both factory and user objects are null
com.myapp.rtvq.exception.PersonDataBOException: Cannot find factoryKOMAROM
	at com.myapp.rtvq.ejb.PersonManagement.getFactoryByName(PersonManagement.java:290)
	at com.myapp.rtvq.ejb.PersonManagement_oqnob4_ELOImpl.getFactoryByName(PersonManagement_oqnob4_ELOImpl.java:1410)
	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:585)
	at org.apache.beehive.controls.system.ejb.EJBControlImpl.invoke(EJBControlImpl.java:403)
	at com.myapp.rtvq.control.PersonControlBean.getFactoryByName(PersonControlBean.java:505)
	at com.myapp.rtvq.config.RTVQController.getFactory(RTVQController.java:811)
	at home.HomeController.getPersonRole(HomeController.java:1892)
	at home.HomeController.redirect(HomeController.java:322)
	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:585)
	at org.apache.beehive.netui.pageflow.FlowController.invokeActionMethod(FlowController.java:879)
	at org.apache.beehive.netui.pageflow.FlowController.getActionMethodForward(FlowController.java:809)
	at org.apache.beehive.netui.pageflow.FlowController.internalExecute(FlowController.java:478)
	at org.apache.beehive.netui.pageflow.PageFlowController.internalExecute(PageFlowController.java:306)
	at org.apache.beehive.netui.pageflow.FlowController.execute(FlowController.java:336)
	at org.apache.beehive.netui.pageflow.internal.FlowControllerAction.execute(FlowControllerAction.java:52)
	at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
	at org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.access$201(PageFlowRequestProcessor.java:97)
	at org.apache.beehive.netui.pageflow.PageFlowRequestProcessor$ActionRunner.execute(PageFlowRequestProcessor.java:2044)
	at org.apache.beehive.netui.pageflow.interceptor.action.internal.ActionInterceptors.wrapAction(ActionInterceptors.java:91)
	at org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.processActionPerform(PageFlowRequestProcessor.java:2116)
	at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
	at org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.processInternal(PageFlowRequestProcessor.java:556)
	at org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.process(PageFlowRequestProcessor.java:853)
	at org.apache.beehive.netui.pageflow.AutoRegisterActionServlet.process(AutoRegisterActionServlet.java:631)
	at org.apache.beehive.netui.pageflow.PageFlowActionServlet.process(PageFlowActionServlet.java:158)
	at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
	at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:226)
	at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:124)
	at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:283)
	at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:175)
	at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3392)
	at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
	at weblogic.security.service.SecurityManager.runAs(Unknown Source)
	at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2140)
	at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2046)
	at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1366)
	at weblogic.work.ExecuteThread.execute(ExecuteThread.java:200)
	at weblogic.work.ExecuteThread.run(ExecuteThread.java:172)
Caused by: java.lang.NullPointerException
	at com.myapp.rtvq.hibernate.HibernateSessionFactory.getSession(HibernateSessionFactory.java:79)
	at com.myapp.rtvq.hibernate.BaseHibernateDAO.getSession(BaseHibernateDAO.java:14)
	at com.myapp.rtvq.dao.FactoryDAO.getSession(FactoryDAO.java:33)
	at com.myapp.rtvq.dao.FactoryDAO.findByProperty(FactoryDAO.java:95)
	at com.myapp.rtvq.dao.FactoryDAO.findByFactoryName(FactoryDAO.java:107)
	at com.myapp.rtvq.ejb.PersonManagement.getFactoryByName(PersonManagement.java:288)
	... 45 more

package com.myapp.rtvq.hibernate;

import java.util.HashMap;
import java.util.Properties;

import org.apache.log4j.Logger;
import org.hibernate.CacheMode;
import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;

import com.myapp.rtvq.utils.UtilityClass;

public class HibernateSessionFactory {

    /** 
     * Location of hibernate.cfg.xml file.
     * Location should be on the classpath as Hibernate uses  
     * #resourceAsStream style lookup for its configuration file. 
     * The default classpath location of the hibernate config file is 
     * in the default package. Use #setConfigFile() to update 
     * the location of the configuration file for the current session.   
     */
	
	private static final Logger logger = Logger.getLogger(HibernateSessionFactory.class);
	
    private static String CONFIG_FILE_LOCATION = "/com/myapp/rtvq/hibernate/mappings/hibernate.cfg.xml";
    private static String DATASOURCE_CONFIG = "/com/myapp/rtvq/properties/datasource.properties";
	private static final ThreadLocal<Session> threadLocal = new ThreadLocal<Session>();
    private  static Configuration configuration = new Configuration();
    private static org.hibernate.SessionFactory sessionFactory;
    
    private  static HashMap<String,Configuration> configurationMap = new HashMap<String,Configuration>();
    private static HashMap<String,org.hibernate.SessionFactory> sessionFactoryMap = new HashMap<String,org.hibernate.SessionFactory>();
    
    
    private static String configFile = CONFIG_FILE_LOCATION;
    
    private static Properties dataSources ;
    
    static{
    	dataSources = new Properties();
		try {
			dataSources.load(Thread.currentThread().getContextClassLoader()
					.getResourceAsStream(DATASOURCE_CONFIG));
		} catch (Exception e) {
			UtilityClass.printStackTrace(e,HibernateSessionFactory.class);
		}
    }

    private HibernateSessionFactory() {
    }
	
	/**
     * Returns the ThreadLocal Session instance.  Lazy initialize
     * the <code>SessionFactory</code> if needed.
     *
     *  @return Session
     *  @throws HibernateException
     */
    public static Session getSession(String factoryName) throws HibernateException {
        Session session = (Session) threadLocal.get();
        
        SessionFactory sessionFactory = sessionFactoryMap.get(factoryName);

		if (session == null || !session.isOpen()) {
			if (sessionFactory == null) {
				rebuildSessionFactory(factoryName);
			}
			sessionFactory = sessionFactoryMap.get(factoryName);
			session = (sessionFactory != null) ? sessionFactory.openSession()
					: null;
			if(sessionFactory!=null){
				session = sessionFactory.openSession();
				logger.warn("Hibernate Session Opened : " +factoryName+ " : " + session.hashCode());
			}
			
			session.setCacheMode(CacheMode.IGNORE);
			
			threadLocal.set(session);
		}

        return session;
    }

	/**
     *  Rebuild hibernate session factory
     *
     */
	public static void rebuildSessionFactory(String factoryName) {
		try {
			Configuration configuration = configurationMap.get(factoryName);
			if(configuration == null){
				configuration = new Configuration();
				configurationMap.put(factoryName, configuration);
			}
			configuration = configuration.configure(configFile);
			configuration.setProperty("hibernate.connection.datasource", dataSources.getProperty(factoryName));
			
			SessionFactory sessionFactory = configuration.buildSessionFactory();
			sessionFactoryMap.put(factoryName, sessionFactory);
			
		} catch (Exception e) {
			logger.error("exception during rebuild Session Factory", e);
		}
	}

	/**
     *  Close the single hibernate session instance.
     *
     *  @throws HibernateException
     */
    public static void closeSession() throws HibernateException {
        Session session = (Session) threadLocal.get();
        threadLocal.set(null);
        if (session != null) {
        	logger.warn("Hibernate Session Closed" + session.hashCode());
            session.close();
        }
    }

	/**
     *  return session factory
     *
     */
	public static org.hibernate.SessionFactory getSessionFactory() {
		return sessionFactory;
	}

	/**
     *  return session factory
     *
     *	session factory will be rebuilded in the next call
     */
	public static void setConfigFile(String configFile) {
		HibernateSessionFactory.configFile = configFile;
		sessionFactory = null;
	}

	/**
     *  return hibernate configuration
     *
     */
	public static Configuration getConfiguration() {
		return configuration;
	}

}

This is my HibernateSessionFactory

[Rob Spoor]

Welcome to the Ranch!

Could you please UseCodeTags next time? I've added them for you this time; look how much easier it is to read the code.

Also, CarefullyChooseOneForum. I'll move this thread to our ORM forum.