Result set already closed error Weblogic XA TM
Hi,
We are getting Result set already closed error. Problem with the error is, it comes intermittently and at different places. Not able to figure out the cause of the error.
We are using weblogic transaction manager with XA driver.
PFB logs.
- 2013-05-10 09:46:15,991 [[ACTIVE] ExecuteThread: '15' for queue: 'weblogic.kernel.Default (self-tuning)'] INFO (collection.collectionLandingPage.CustomerInfoForAccountCentricSearch) Determinant value for Table CI_PER_EMPLOYMENT_DTLS ----08
- 2013-05-10 09:46:16,071 [[ACTIVE] ExecuteThread: '15' for queue: 'weblogic.kernel.Default (self-tuning)'] INFO (collection.collectionLandingPage.CustomerInfoForAccountCentricSearch) Determinant value for Table CI_PER_NAME_DTLS ----08
- 2013-05-10 09:46:16,071 [[ACTIVE] ExecuteThread: '15' for queue: 'weblogic.kernel.Default (self-tuning)'] INFO (collection.collectionLandingPage.CustomerInfoForAccountCentricSearch) Determinant value for Table CI_CONTACT_PREF ----08
- 2013-05-10 09:46:16,101 [[ACTIVE] ExecuteThread: '15' for queue: 'weblogic.kernel.Default (self-tuning)'] INFO (collection.collectionLandingPage.CustomerInfoForAccountCentricSearch) Determinant value for Table CI_PER_ADDR ----UBank_1
- 2013-05-10 09:46:16,101 [[ACTIVE] ExecuteThread: '15' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR (support.context.FrameworkSession) Error getting entity
org.hibernate.exception.GenericJDBCException: could not load an entity: [com.splwg.domain.database.table.Constraint__#component[constraintId,customizationOwner]{constraintId=C1_CXF296R1 , customizationOwner=C1 }]
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.loadEntity(Loader.java:2041)
at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:86)
at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:76)
at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3293)
at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:496)
at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:477)
at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:227)
at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:285)
at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:152)
at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:1090)
at org.hibernate.impl.SessionImpl.get(SessionImpl.java:1005)
at org.hibernate.impl.SessionImpl.get(SessionImpl.java:998)
at com.splwg.base.support.context.FrameworkSession.get(FrameworkSession.java:711)
at com.splwg.base.support.impl.AbstractBindableQuery.getStringIdPropertySize(AbstractBindableQuery.java:403)
at com.splwg.base.support.impl.AbstractBindableQuery.bindLikableStringProperty(AbstractBindableQuery.java:369)
at com.splwg.ccb.domain.collection.collectionLandingPage.CustomerInfoForAccountCentricSearch.read(CustomerInfoForAccountCentricSearch.java:424)
at com.splwg.base.support.pagemaintenance.AbstractPageMaintenance.readItem(AbstractPageMaintenance.java:91)
at com.splwg.base.support.service.JavaPageReadService$1.execute(JavaPageReadService.java:29)
at com.splwg.base.support.service.JavaPageReadService$1.execute(JavaPageReadService.java:25)
at com.splwg.base.support.context.FlushDisabledExecutable.doWithFlushesDisabled(FlushDisabledExecutable.java:33)
at com.splwg.base.support.service.JavaPageReadService.read(JavaPageReadService.java:33)
at com.splwg.base.support.service.PageReadService.privateExecute(PageReadService.java:56)
at com.splwg.base.support.service.PageReadService.execute(PageReadService.java:39)
at com.splwg.base.api.service.ServiceDispatcher.readItemInSession(ServiceDispatcher.java:627)
at com.splwg.base.api.businessService.BusinessServiceProcessor.readPage(BusinessServiceProcessor.java:171)
at com.splwg.base.api.businessService.BusinessServiceProcessor.executePage(BusinessServiceProcessor.java:118)
at com.splwg.base.api.businessService.BusinessServiceProcessor.instanceExecuteAsFW(BusinessServiceProcessor.java:87)
at com.splwg.base.api.businessService.BusinessServiceDispatcher$2.run(BusinessServiceDispatcher.java:91)
at com.splwg.base.api.businessService.BusinessServiceDispatcher$JumpToFWRunner.run(BusinessServiceDispatcher.java:121)
at com.splwg.base.support.interception.SessionInterceptionManager.notifyGenericCallStackJump(SessionInterceptionManager.java:268)
at com.splwg.base.support.context.FrameworkSession.notifyGenericCallStackJump(FrameworkSession.java:1544)
at com.splwg.base.api.businessService.BusinessServiceDispatcher.executeCallStackJump(BusinessServiceDispatcher.java:106)
at com.splwg.base.api.businessService.BusinessServiceDispatcher.instanceExecute(BusinessServiceDispatcher.java:94)
at com.splwg.base.api.businessService.BusinessServiceDispatcher.execute(BusinessServiceDispatcher.java:48)
at com.splwg.serviceclient.LocalServiceDispatcher$1.executeService(LocalServiceDispatcher.java:66)
at com.splwg.serviceclient.LocalServiceDispatcher$1.executeService(LocalServiceDispatcher.java:1)
at com.splwg.serviceclient.LocalServiceSessionHelper$1.execute(LocalServiceSessionHelper.java:25)
at com.splwg.base.support.context.SessionExecutable.doInNewSession(SessionExecutable.java:41)
at com.splwg.serviceclient.LocalServiceSessionHelper.doItInNewSession(LocalServiceSessionHelper.java:29)
at com.splwg.serviceclient.LocalServiceDispatcher.executeBS(LocalServiceDispatcher.java:70)
at com.ofss.fc.domain.collection.service.CollectionDomainService.executeBS(CollectionDomainService.java:82)
at com.ofss.fc.app.collection.service.customerinfo.CollectionCustomerInfoDetailsService.executeBS(CollectionCustomerInfoDetailsService.java:116)
at com.ofss.fc.app.collection.service.customerinfo.CollectionCustomerInfoDetailsService.read(CollectionCustomerInfoDetailsService.java:61)
at com.ofss.fc.app.collection.service.customerinfo.CollectionCustomerSumAggregationService.read(CollectionCustomerSumAggregationService.java:38)
at com.ofss.fc.app.collection.service.customerinfo.CustomerSumAggregationApplicationService.read_aroundBody0(CustomerSumAggregationApplicationService.java:58)
at com.ofss.fc.app.collection.service.customerinfo.CustomerSumAggregationApplicationService.read_aroundBody1$advice(CustomerSumAggregationApplicationService.java:229)
at com.ofss.fc.app.collection.service.customerinfo.CustomerSumAggregationApplicationService.read(CustomerSumAggregationApplicationService.java:1)
at com.ofss.fc.app.collection.service.customerinfo.service.json.CustomerSumAggregationApplicationServiceJSONFacade.read(CustomerSumAggregationApplicationServiceJSONFacade.java:86)
at com.ofss.fc.app.collection.service.customerinfo.service.json.CustomerSumAggregationApplicationServiceJSONFacade.process(CustomerSumAggregationApplicationServiceJSONFacade.java:43)
at com.ofss.fc.channel.branch.service.ServiceManager.processJSONRequest(ServiceManager.java:170)
at com.ofss.fc.channel.branch.service.ServiceManager.process(ServiceManager.java:84)
at com.ofss.fc.channel.branch.service.ServiceManager.processRequest(ServiceManager.java:53)
at com.ofss.fc.channel.branch.net.http.HTTPListener.processMessage(HTTPListener.java:260)
at com.ofss.fc.channel.branch.net.http.HTTPListener.handleMessage(HTTPListener.java:316)
at com.ofss.fc.channel.branch.net.http.HTTPListener.doPost(HTTPListener.java:149)
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:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:442)
at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:442)
at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:139)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3730)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2273)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
Caused by: java.sql.SQLException: Result set already closed
at weblogic.jdbc.wrapper.ResultSet.checkResultSet(ResultSet.java:144)
at weblogic.jdbc.wrapper.ResultSet.preInvocationHandler(ResultSet.java:97)
at weblogic.jdbc.wrapper.ResultSet_oracle_jdbc_driver_OracleResultSetImpl.getLong(Unknown Source)
at org.hibernate.type.descriptor.sql.BigIntTypeDescriptor$2.doExtract(BigIntTypeDescriptor.java:61)
at org.hibernate.type.descriptor.sql.BasicExtractor.extract(BasicExtractor.java:65)
at org.hibernate.type.AbstractStandardBasicType.hydrate(AbstractStandardBasicType.java:331)
at org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:2283)
at org.hibernate.loader.Loader.getRow(Loader.java:1355)
at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:76)
at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3293)
at org.hibernate.event.LoadEvent.isAssociationFetch(LoadEvent.java:65)
at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:503)
at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:477)
at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:152)
at org.hibernate.impl.SessionImpl.get(SessionImpl.java:998)
at com.splwg.base.support.context.FrameworkSession.get(FrameworkSession.java:711)
at com.splwg.base.support.impl.AbstractBindableQuery.bindLikableStringProperty(AbstractBindableQuery.java:369)
at com.splwg.ccb.domain.collection.collectionLandingPage.CustomerInfoForAccountCentricSearch.read(CustomerInfoForAccountCentricSearch.java:425)
at com.splwg.base.support.pagemaintenance.AbstractPageMaintenance.readItem(AbstractPageMaintenance.java:91)
at com.splwg.base.support.service.JavaPageReadService.read(JavaPageReadService.java:33)
at com.splwg.base.support.service.PageReadService.privateExecute(PageReadService.java:57)
at com.splwg.base.api.businessService.BusinessServiceProcessor.readPage(BusinessServiceProcessor.java:171)
at com.splwg.base.api.businessService.BusinessServiceProcessor.executePage(BusinessServiceProcessor.java:118)
at com.splwg.base.api.businessService.BusinessServiceDispatcher$2.run(BusinessServiceDispatcher.java:91)
at com.splwg.serviceclient.LocalServiceDispatcher$1.executeService(LocalServiceDispatcher.java:66)
at com.splwg.serviceclient.LocalServiceDispatcher$1.executeService(LocalServiceDispatcher.java:1)
at com.splwg.serviceclient.LocalServiceSessionHelper$1.execute(LocalServiceSessionHelper.java:25)
at com.splwg.base.support.context.SessionExecutable.doInNewSession(SessionExecutable.java:41)
at com.ofss.fc.domain.collection.service.CollectionDomainService.executeBS(CollectionDomainService.java:82)
at com.ofss.fc.app.collection.service.customerinfo.CollectionCustomerInfoDetailsService.executeBS(CollectionCustomerInfoDetailsService.java:116)
at com.ofss.fc.app.collection.service.customerinfo.CollectionCustomerInfoDetailsService.read(CollectionCustomerInfoDetailsService.java:62)
at com.ofss.fc.app.collection.service.customerinfo.CollectionCustomerSumAggregationService.read(CollectionCustomerSumAggregationService.java:38)
at com.ofss.fc.app.collection.service.customerinfo.CustomerSumAggregationApplicationService.read_aroundBody0(CustomerSumAggregationApplicationService.java:58)
at com.ofss.fc.app.collection.service.customerinfo.service.json.CustomerSumAggregationApplicationServiceJSONFacade.read(CustomerSumAggregationApplicationServiceJSONFacade.java:86)
at com.ofss.fc.app.collection.service.customerinfo.service.json.CustomerSumAggregationApplicationServiceJSONFacade.process(CustomerSumAggregationApplicationServiceJSONFacade.java:43)
at com.ofss.fc.channel.branch.service.ServiceManager.processJSONRequest(ServiceManager.java:171)
at com.ofss.fc.channel.branch.service.ServiceManager.processRequest(ServiceManager.java:53)
at com.ofss.fc.channel.branch.net.http.HTTPListener.handleMessage(HTTPListener.java:316)
at com.ofss.fc.channel.branch.net.http.HTTPListener.doPost(HTTPListener.java:149)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:821)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:27)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:139)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)
... 1 more
- 2013-05-10 09:46:16,111 [[ACTIVE] ExecuteThread: '15' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR (api.service.ServiceExecutionPolicy) Encountered exception, session marked for rollback
- 2013-05-10 09:46:16,111 [[ACTIVE] ExecuteThread: '15' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR (support.context.SessionExecutable) Caught exception from SessionExecutable.execute()