I run into this urgent showstopper with a query hanging for minutes and eventually a connection time out exception is thrown. This is a struts/spring/hibernate application running on WAS 6.1, with an Oracle 10g backend. Same code runs fine on WAS 5.1 against the same database. Please Help! Any advice is appreciated!
Hibernate version:
3.0
Mapping documents:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="com.regence.sds.aat.model" >
<class name="SAAR" table="SAAR">
<id name="id" column="SAAR_ID" type="long" unsaved-value="0">
<generator class="sequence">
<param name="sequence">AAT_ID_SEQ</param>
</generator>
</id>
<many-to-one name="workflowState" class="WorkflowState" column="WORKFLOW_ST_ID"/>
<property name="saarType" column="SAAR_TYP_CD" type="long"/>
<property name="requestUserId" column="RQSTR_USER_ID_CD" type="string" length="10"/>
<property name="salesRepName" column="SALES_REPRSNTV_NAME_TXT" type="string" length="40"/>
<property name="agencyName" column="AGCY_NAME_TXT" type="string" length="35"/>
<property name="agentFirstName" column="AGT_FST_NAME_TXT" type="string" length="15"/>
<property name="agentMiddleName" column="AGT_MID_NAME_TXT" type="string" length="1"/>
<property name="agentLastName" column="AGT_LST_NAME_TXT" type="string" length="35"/>
<property name="emailAddress" column="EMAIL_ADDR_TXT" type="string" length="60"/>
<property name="phoneNumber" column="PH_NUM_TXT" type="string" length="20"/>
<property name="phoneNumberExtension" column="PH_EXTSN_NUM_TXT" type="string" length="10"/>
<property name="agentCociId" column="AGT_COCI_ID_CD" type="string" length="13" />
<property name="agentCoceId" column="AGT_COCE_ID_CD" type="string" length="13" />
<property name="agencyCociId" column="AGCY_COCI_ID_CD" type="string" length="13" />
<property name="agencyCoceId" column="AGCY_COCE_ID_CD" type="string" length="13" />
<set name="statePlans" lazy="true" cascade="all" order-by="AFFLT_ID asc" >
<key column="SAAR_ID" not-null="true"/>
<one-to-many class="StatePlan"/>
</set>
<set name="notes" lazy="true" cascade="all" order-by="PGM_JRNL_CREAT_DT asc">
<key column="SAAR_ID" not-null="true"/>
<one-to-many class="ProgressJournal"/>
</set>
</class>
</hibernate-mapping>
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="com.regence.sds.aat.model.State" table="AFFLT">
<id name="id" column="AFFLT_ID" type="long" unsaved-value="0">
<generator class="sequence">
<param name="sequence">AAT_ID_SEQ</param>
</generator>
</id>
<property name="code" column="AFFLT_CD" type="string" length="2"/>
<property name="name" column="AFFLT_NAME_TXT" type="string" length="40"/>
<property name="statusChangeEmailRecipient" column="RECPNT_NTFCN_EMAIL_TXT" type="string" length="60"/>
<property name="notifyOnPendingStatusChange" column="NTFY_PENDG_IND" type="yes_no"/>
<property name="notifyOnActiveStatusChange" column="NTFY_ACTV_IND" type="yes_no"/>
<property name="notifyOnTerminatedStatusChange" column="NTFY_TRMNTD_IND" type="yes_no"/>
<property name="notifyOnInactiveStatusChange" column="NTFY_INACTV_IND" type="yes_no"/>
<property name="notifyOnAnyStatusChange" column="NTFY_ANY_IND" type="yes_no"/>
<property name="notifyOnSalesCompletion" column="NTFY_COMPLT_IND" type="yes_no"/>
</class>
</hibernate-mapping>
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="com.regence.sds.aat.model" >
<class name="StatePlan" table="SAAR_PLN_ST">
<id name="id" column="SAAR_PLN_ST_ID" type="long" unsaved-value="0">
<generator class="sequence">
<param name="sequence">AAT_ID_SEQ</param>
</generator>
</id>
<many-to-one name="state" class="State" column="AFFLT_ID"/>
<property name="groupPlanInd" column="GRP_PLN_IND" type="yes_no"/>
<property name="individalPlanInd" column="INDIVL_PLN_IND" type="yes_no"/>
<property name="medicarePlanInd" column="MCARE_PLN_IND" type="yes_no"/>
<property name="lifePlanInd" column="LIFE_PLN_IND" type="yes_no"/>
<property name="eoCoverageFormCompltInd" column="EO_FORM_COMPLT_IND" type="yes_no"/>
<property name="affiliationFormCompltInd" column="AFFLTN_FORM_COMPLT_IND" type="yes_no"/>
<property name="contractFormCompltInd" column="CNTRCT_FORM_COMPLT_IND" type="yes_no"/>
<property name="trainCertFormCompltInd" column="TRNG_CERTN_FORM_COMPLT_IND" type="yes_no"/>
<property name="licenseFormCompltInd" column="LIC_FORM_COMPLT_IND" type="yes_no"/>
<set name="planProgress" cascade="all">
<key column="SAAR_PLN_ST_ID" not-null="true"/>
<one-to-many class="StatePlanProgressSteps"/>
</set>
</class>
</hibernate-mapping>
Code between sessionFactory.openSession() and session.close():
Full stack trace of any exception that occurs:
2006-12-08 21:00:42,676 [WebContainer : 0] DEBUG [org.hibernate.jdbc.AbstractBatcher] - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2006-12-08 21:00:42,723 [WebContainer : 0] DEBUG [org.hibernate.SQL] - select this_.SAAR_ID as SAAR1_0_2_, this_.WORKFLOW_ST_ID as WORKFLOW2_0_2_, this_.SAAR_TYP_CD as SAAR3_0_2_, this_.RQSTR_USER_ID_CD as RQSTR4_0_2_, this_.SALES_REPRSNTV_NAME_TXT as SALES5_0_2_, this_.AGCY_NAME_TXT as AGCY6_0_2_, this_.AGT_FST_NAME_TXT as AGT7_0_2_, this_.AGT_MID_NAME_TXT as AGT8_0_2_, this_.AGT_LST_NAME_TXT as AGT9_0_2_, this_.EMAIL_ADDR_TXT as EMAIL10_0_2_, this_.PH_NUM_TXT as PH11_0_2_, this_.PH_EXTSN_NUM_TXT as PH12_0_2_, this_.AGT_COCI_ID_CD as AGT13_0_2_, this_.AGT_COCE_ID_CD as AGT14_0_2_, this_.AGCY_COCI_ID_CD as AGCY15_0_2_, this_.AGCY_COCE_ID_CD as AGCY16_0_2_, stateplan1_.SAAR_PLN_ST_ID as SAAR1_1_0_, stateplan1_.AFFLT_ID as AFFLT2_1_0_, stateplan1_.GRP_PLN_IND as GRP3_1_0_, stateplan1_.INDIVL_PLN_IND as INDIVL4_1_0_, stateplan1_.MCARE_PLN_IND as MCARE5_1_0_, stateplan1_.LIFE_PLN_IND as LIFE6_1_0_, stateplan1_.EO_FORM_COMPLT_IND as EO7_1_0_, stateplan1_.AFFLTN_FORM_COMPLT_IND as AFFLTN8_1_0_, stateplan1_.CNTRCT_FORM_COMPLT_IND as CNTRCT9_1_0_, stateplan1_.TRNG_CERTN_FORM_COMPLT_IND as TRNG10_1_0_, stateplan1_.LIC_FORM_COMPLT_IND as LIC11_1_0_, state2_.AFFLT_ID as AFFLT1_5_1_, state2_.AFFLT_CD as AFFLT2_5_1_, state2_.AFFLT_NAME_TXT as AFFLT3_5_1_, state2_.RECPNT_NTFCN_EMAIL_TXT as RECPNT4_5_1_, state2_.NTFY_PENDG_IND as NTFY5_5_1_, state2_.NTFY_ACTV_IND as NTFY6_5_1_, state2_.NTFY_TRMNTD_IND as NTFY7_5_1_, state2_.NTFY_INACTV_IND as NTFY8_5_1_, state2_.NTFY_ANY_IND as NTFY9_5_1_, state2_.NTFY_COMPLT_IND as NTFY10_5_1_ from AAT.SAAR this_, AAT.SAAR_PLN_ST stateplan1_, AAT.AFFLT state2_ where this_.SAAR_ID=stateplan1_.SAAR_ID and stateplan1_.AFFLT_ID=state2_.AFFLT_ID and (state2_.AFFLT_CD=?)
2006-12-08 21:00:42,768 [WebContainer : 0] DEBUG [org.hibernate.jdbc.AbstractBatcher] - preparing statement
2006-12-08 21:00:43,132 [WebContainer : 0] DEBUG [org.hibernate.type.StringType] - binding 'ID' to parameter: 1
2006-12-08 21:06:48,294 [Non-deferrable Alarm : 0] DEBUG [com.regence.sds.aat.web.action.UserContainer] - Being unbound...
2006-12-08 21:06:48,294 [Non-deferrable Alarm : 0] DEBUG [com.regence.sds.aat.web.action.UserContainer] - Being unbound...
2006-12-08 21:06:48,319 [Non-deferrable Alarm : 0] DEBUG [com.regence.sds.aat.web.action.UserContainer] - Setting current user to null. User: aat_admin_user
2006-12-08 21:06:48,319 [Non-deferrable Alarm : 0] DEBUG [com.regence.sds.aat.web.action.UserContainer] - Setting current user to null. User: aat_admin_user
2006-12-08 21:06:48,341 [Non-deferrable Alarm : 0] DEBUG [com.regence.sds.aat.web.action.UserContainer] - Current user has been set to null...
2006-12-08 21:06:48,341 [Non-deferrable Alarm : 0] DEBUG [com.regence.sds.aat.web.action.UserContainer] - Current user has been set to null...
2006-12-08 21:09:45,925 [WebContainer : 0] WARN [org.hibernate.jdbc.AbstractBatcher] - exception clearing maxRows/queryTimeout
com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: Statement is closed.
at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.runtimeXIfNotClosed(WSJdbcStatement.java:1505)
at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.getMaxRows(WSJdbcStatement.java:974)
at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:225)
at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:162)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1683)
at org.hibernate.loader.Loader.doQuery(Loader.java:662)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2145)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
at org.hibernate.loader.Loader.list(Loader.java:2024)
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1552)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
at com.regence.sds.aat.dao.hibernate.SAARDAOHibernate$6.doInHibernate(SAARDAOHibernate.java:289)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:358)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:331)
at com.regence.sds.aat.dao.hibernate.SAARDAOHibernate.findSaar(SAARDAOHibernate.java:100)
at com.regence.sds.aat.service.impl.SAARManagerImpl.findSaar(SAARManagerImpl.java:231)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:64)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:615)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:292)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)
at $Proxy3.findSaar(Unknown Source)
at com.regence.sds.aat.service.impl.MediatorImpl.getSearchResults(MediatorImpl.java:1210)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:64)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:615)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:292)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)
at $Proxy4.getSearchResults(Unknown Source)
at com.regence.sds.aat.web.action.SearchAction.execute(SearchAction.java:55)
at org.springframework.web.struts.DelegatingActionProxy.execute(DelegatingActionProxy.java:106)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:449)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:264)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1176)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:472)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:966)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:907)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:145)
at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:174)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:130)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:87)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:701)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:646)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:475)
at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:463)
at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3129)
at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:238)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:811)
at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1433)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:93)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:465)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:394)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:102)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:152)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:213)
at com.ibm.io.async.AbstractAsyncFuture.fireCompletionActions(AbstractAsyncFuture.java:195)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:194)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:741)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:863)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1510)
2006-12-08 21:09:46,028 [WebContainer : 0] DEBUG [org.hibernate.jdbc.AbstractBatcher] - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2006-12-08 21:09:46,076 [WebContainer : 0] DEBUG [org.hibernate.jdbc.AbstractBatcher] - closing statement
2006-12-08 21:09:46,124 [WebContainer : 0] DEBUG [org.hibernate.util.JDBCExceptionReporter] - could not execute query [select this_.SAAR_ID as SAAR1_0_2_, this_.WORKFLOW_ST_ID as WORKFLOW2_0_2_, this_.SAAR_TYP_CD as SAAR3_0_2_, this_.RQSTR_USER_ID_CD as RQSTR4_0_2_, this_.SALES_REPRSNTV_NAME_TXT as SALES5_0_2_, this_.AGCY_NAME_TXT as AGCY6_0_2_, this_.AGT_FST_NAME_TXT as AGT7_0_2_, this_.AGT_MID_NAME_TXT as AGT8_0_2_, this_.AGT_LST_NAME_TXT as AGT9_0_2_, this_.EMAIL_ADDR_TXT as EMAIL10_0_2_, this_.PH_NUM_TXT as PH11_0_2_, this_.PH_EXTSN_NUM_TXT as PH12_0_2_, this_.AGT_COCI_ID_CD as AGT13_0_2_, this_.AGT_COCE_ID_CD as AGT14_0_2_, this_.AGCY_COCI_ID_CD as AGCY15_0_2_, this_.AGCY_COCE_ID_CD as AGCY16_0_2_, stateplan1_.SAAR_PLN_ST_ID as SAAR1_1_0_, stateplan1_.AFFLT_ID as AFFLT2_1_0_, stateplan1_.GRP_PLN_IND as GRP3_1_0_, stateplan1_.INDIVL_PLN_IND as INDIVL4_1_0_, stateplan1_.MCARE_PLN_IND as MCARE5_1_0_, stateplan1_.LIFE_PLN_IND as LIFE6_1_0_, stateplan1_.EO_FORM_COMPLT_IND as EO7_1_0_, stateplan1_.AFFLTN_FORM_COMPLT_IND as AFFLTN8_1_0_, stateplan1_.CNTRCT_FORM_COMPLT_IND as CNTRCT9_1_0_, stateplan1_.TRNG_CERTN_FORM_COMPLT_IND as TRNG10_1_0_, stateplan1_.LIC_FORM_COMPLT_IND as LIC11_1_0_, state2_.AFFLT_ID as AFFLT1_5_1_, state2_.AFFLT_CD as AFFLT2_5_1_, state2_.AFFLT_NAME_TXT as AFFLT3_5_1_, state2_.RECPNT_NTFCN_EMAIL_TXT as RECPNT4_5_1_, state2_.NTFY_PENDG_IND as NTFY5_5_1_, state2_.NTFY_ACTV_IND as NTFY6_5_1_, state2_.NTFY_TRMNTD_IND as NTFY7_5_1_, state2_.NTFY_INACTV_IND as NTFY8_5_1_, state2_.NTFY_ANY_IND as NTFY9_5_1_, state2_.NTFY_COMPLT_IND as NTFY10_5_1_ from AAT.SAAR this_, AAT.SAAR_PLN_ST stateplan1_, AAT.AFFLT state2_ where this_.SAAR_ID=stateplan1_.SAAR_ID and stateplan1_.AFFLT_ID=state2_.AFFLT_ID and (state2_.AFFLT_CD=?)]
com.ibm.websphere.ce.cm.StaleConnectionException: Io exception: Connection timed out
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:67)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:521)
at com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapExceptionHelper(GenericDataStoreHelper.java:523)
at com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapException(GenericDataStoreHelper.java:578)
at com.ibm.ws.rsadapter.jdbc.WSJdbcUtil.mapException(WSJdbcUtil.java:903)
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeQuery(WSJdbcPreparedStatement.java:570)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1669)
at org.hibernate.loader.Loader.doQuery(Loader.java:662)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2145)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
at org.hibernate.loader.Loader.list(Loader.java:2024)
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1552)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
at com.regence.sds.aat.dao.hibernate.SAARDAOHibernate$6.doInHibernate(SAARDAOHibernate.java:289)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:358)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:331)
at com.regence.sds.aat.dao.hibernate.SAARDAOHibernate.findSaar(SAARDAOHibernate.java:100)
at com.regence.sds.aat.service.impl.SAARManagerImpl.findSaar(SAARManagerImpl.java:231)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:64)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:615)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:292)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)
at $Proxy3.findSaar(Unknown Source)
at com.regence.sds.aat.service.impl.MediatorImpl.getSearchResults(MediatorImpl.java:1210)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:64)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:615)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:292)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)
at $Proxy4.getSearchResults(Unknown Source)
at com.regence.sds.aat.web.action.SearchAction.execute(SearchAction.java:55)
at org.springframework.web.struts.DelegatingActionProxy.execute(DelegatingActionProxy.java:106)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:449)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:264)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1176)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:472)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:966)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:907)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:145)
at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:174)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:130)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:87)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:701)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:646)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:475)
at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:463)
at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3129)
at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:238)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:811)
at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1433)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:93)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:465)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:394)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:102)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:152)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:213)
at com.ibm.io.async.AbstractAsyncFuture.fireCompletionActions(AbstractAsyncFuture.java:195)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:194)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:741)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:863)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1510)
2006-12-08 21:09:46,216 [WebContainer : 0] WARN [org.hibernate.util.JDBCExceptionReporter] - SQL Error: 17002, SQLState: null
2006-12-08 21:09:46,260 [WebContainer : 0] ERROR [org.hibernate.util.JDBCExceptionReporter] - Io exception: Connection timed out
2006-12-08 21:09:46,305 [WebContainer : 0] WARN [org.hibernate.util.JDBCExceptionReporter] - SQL Error: 17002, SQLState: null
2006-12-08 21:09:46,350 [WebContainer : 0] ERROR [org.hibernate.util.JDBCExceptionReporter] - Io exception: Connection timed out
2006-12-08 21:09:46,397 [WebContainer : 0] DEBUG [org.hibernate.transaction.JDBCTransaction] - rollback
2006-12-08 21:09:46,437 [WebContainer : 0] DEBUG [org.hibernate.transaction.JDBCTransaction] - re-enabling autocommit
2006-12-08 21:09:46,478 [WebContainer : 0] ERROR [org.hibernate.transaction.JDBCTransaction] - Could not toggle autocommit
com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: Connection is closed.
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.runtimeXIfNotClosed(WSJdbcConnection.java:2566)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.setAutoCommit(WSJdbcConnection.java:2650)
at org.hibernate.transaction.JDBCTransaction.toggleAutoCommit(JDBCTransaction.java:194)
at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:186)
at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:162)
at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:509)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:578)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:555)
at org.springframework.transaction.interceptor.TransactionAspectSupport.doCloseTransactionAfterThrowing(TransactionAspectSupport.java:276)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:100)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)
at $Proxy4.getSearchResults(Unknown Source)
at com.regence.sds.aat.web.action.SearchAction.execute(SearchAction.java:55)
at org.springframework.web.struts.DelegatingActionProxy.execute(DelegatingActionProxy.java:106)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:449)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:264)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1176)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:472)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:966)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:907)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:145)
at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:174)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:130)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:87)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:701)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:646)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:475)
at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:463)
at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3129)
at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:238)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:811)
at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1433)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:93)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:465)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:394)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:102)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:152)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:213)
at com.ibm.io.async.AbstractAsyncFuture.fireCompletionActions(AbstractAsyncFuture.java:195)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:194)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:741)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:863)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1510)
2006-12-08 21:09:46,596 [WebContainer : 0] ERROR [org.hibernate.transaction.JDBCTransaction] - JDBC rollback failed
com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: Connection is closed.
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.runtimeXIfNotClosed(WSJdbcConnection.java:2566)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.rollback(WSJdbcConnection.java:2533)
at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:183)
at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:162)
at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:509)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:578)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:555)
at org.springframework.transaction.interceptor.TransactionAspectSupport.doCloseTransactionAfterThrowing(TransactionAspectSupport.java:276)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:100)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)
at $Proxy4.getSearchResults(Unknown Source)
at com.regence.sds.aat.web.action.SearchAction.execute(SearchAction.java:55)
at org.springframework.web.struts.DelegatingActionProxy.execute(DelegatingActionProxy.java:106)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:449)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:264)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1176)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:472)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:966)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:907)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:145)
at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:174)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:130)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:87)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:701)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:646)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:475)
at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:463)
at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3129)
at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:238)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:811)
at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1433)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:93)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:465)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:394)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:102)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:152)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:213)
at com.ibm.io.async.AbstractAsyncFuture.fireCompletionActions(AbstractAsyncFuture.java:195)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:194)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:741)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:863)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1510)
2006-12-08 21:09:46,751 [WebContainer : 0] DEBUG [org.hibernate.jdbc.JDBCContext] - after transaction completion
2006-12-08 21:09:46,790 [WebContainer : 0] DEBUG [org.hibernate.jdbc.ConnectionManager] - aggressively releasing JDBC connection
2006-12-08 21:09:46,835 [WebContainer : 0] DEBUG [org.hibernate.jdbc.ConnectionManager] - releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
2006-12-08 21:09:46,885 [WebContainer : 0] DEBUG [org.hibernate.impl.SessionImpl] - after transaction completion
2006-12-08 21:09:46,940 [WebContainer : 0] DEBUG [org.hibernate.jdbc.ConnectionManager] - opening JDBC connection
2006-12-08 21:09:47,320 [WebContainer : 0] DEBUG [org.hibernate.impl.SessionImpl] - setting flush mode to: NEVER
2006-12-08 21:09:47,360 [WebContainer : 0] ERROR [org.springframework.transaction.interceptor.TransactionInterceptor] - Application exception overridden by rollback exception
org.springframework.dao.DataAccessResourceFailureException: Hibernate operation: could not execute query; SQL [select this_.SAAR_ID as SAAR1_0_2_, this_.WORKFLOW_ST_ID as WORKFLOW2_0_2_, this_.SAAR_TYP_CD as SAAR3_0_2_, this_.RQSTR_USER_ID_CD as RQSTR4_0_2_, this_.SALES_REPRSNTV_NAME_TXT as SALES5_0_2_, this_.AGCY_NAME_TXT as AGCY6_0_2_, this_.AGT_FST_NAME_TXT as AGT7_0_2_, this_.AGT_MID_NAME_TXT as AGT8_0_2_, this_.AGT_LST_NAME_TXT as AGT9_0_2_, this_.EMAIL_ADDR_TXT as EMAIL10_0_2_, this_.PH_NUM_TXT as PH11_0_2_, this_.PH_EXTSN_NUM_TXT as PH12_0_2_, this_.AGT_COCI_ID_CD as AGT13_0_2_, this_.AGT_COCE_ID_CD as AGT14_0_2_, this_.AGCY_COCI_ID_CD as AGCY15_0_2_, this_.AGCY_COCE_ID_CD as AGCY16_0_2_, stateplan1_.SAAR_PLN_ST_ID as SAAR1_1_0_, stateplan1_.AFFLT_ID as AFFLT2_1_0_, stateplan1_.GRP_PLN_IND as GRP3_1_0_, stateplan1_.INDIVL_PLN_IND as INDIVL4_1_0_, stateplan1_.MCARE_PLN_IND as MCARE5_1_0_, stateplan1_.LIFE_PLN_IND as LIFE6_1_0_, stateplan1_.EO_FORM_COMPLT_IND as EO7_1_0_, stateplan1_.AFFLTN_FORM_COMPLT_IND as AFFLTN8_1_0_, stateplan1_.CNTRCT_FORM_COMPLT_IND as CNTRCT9_1_0_, stateplan1_.TRNG_CERTN_FORM_COMPLT_IND as TRNG10_1_0_, stateplan1_.LIC_FORM_COMPLT_IND as LIC11_1_0_, state2_.AFFLT_ID as AFFLT1_5_1_, state2_.AFFLT_CD as AFFLT2_5_1_, state2_.AFFLT_NAME_TXT as AFFLT3_5_1_, state2_.RECPNT_NTFCN_EMAIL_TXT as RECPNT4_5_1_, state2_.NTFY_PENDG_IND as NTFY5_5_1_, state2_.NTFY_ACTV_IND as NTFY6_5_1_, state2_.NTFY_TRMNTD_IND as NTFY7_5_1_, state2_.NTFY_INACTV_IND as NTFY8_5_1_, state2_.NTFY_ANY_IND as NTFY9_5_1_, state2_.NTFY_COMPLT_IND as NTFY10_5_1_ from AAT.SAAR this_, AAT.SAAR_PLN_ST stateplan1_, AAT.AFFLT state2_ where this_.SAAR_ID=stateplan1_.SAAR_ID and stateplan1_.AFFLT_ID=state2_.AFFLT_ID and (state2_.AFFLT_CD=?)]; Io exception: Connection timed out; nested exception is com.ibm.websphere.ce.cm.StaleConnectionException: Io exception: Connection timed out
com.ibm.websphere.ce.cm.StaleConnectionException: Io exception: Connection timed out
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:67)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:521)
at com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapExceptionHelper(GenericDataStoreHelper.java:523)
at com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapException(GenericDataStoreHelper.java:578)
at com.ibm.ws.rsadapter.jdbc.WSJdbcUtil.mapException(WSJdbcUtil.java:903)
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeQuery(WSJdbcPreparedStatement.java:570)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1669)
at org.hibernate.loader.Loader.doQuery(Loader.java:662)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2145)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
at org.hibernate.loader.Loader.list(Loader.java:2024)
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1552)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
at com.regence.sds.aat.dao.hibernate.SAARDAOHibernate$6.doInHibernate(SAARDAOHibernate.java:289)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:358)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:331)
at com.regence.sds.aat.dao.hibernate.SAARDAOHibernate.findSaar(SAARDAOHibernate.java:100)
at com.regence.sds.aat.service.impl.SAARManagerImpl.findSaar(SAARManagerImpl.java:231)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:64)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:615)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:292)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)
at $Proxy3.findSaar(Unknown Source)
at com.regence.sds.aat.service.impl.MediatorImpl.getSearchResults(MediatorImpl.java:1210)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:64)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:615)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:292)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)
at $Proxy4.getSearchResults(Unknown Source)
at com.regence.sds.aat.web.action.SearchAction.execute(SearchAction.java:55)
at org.springframework.web.struts.DelegatingActionProxy.execute(DelegatingActionProxy.java:106)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:449)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:264)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1176)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:472)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:966)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:907)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:145)
at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:174)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:130)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:87)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:701)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:646)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:475)
at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:463)
at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3129)
at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:238)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:811)
at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1433)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:93)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:465)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:394)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:102)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:152)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:213)
at com.ibm.io.async.AbstractAsyncFuture.fireCompletionActions(AbstractAsyncFuture.java:195)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:194)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:741)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:863)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1510)
2006-12-08 21:09:47,403 [WebContainer : 0] ERROR [com.regence.sds.aat.web.util.ActionExceptionHandler] - Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: JDBC rollback failed
org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: JDBC rollback failed
org.hibernate.TransactionException: JDBC rollback failed
at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:170)
at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:509)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:578)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:555)
at org.springframework.transaction.interceptor.TransactionAspectSupport.doCloseTransactionAfterThrowing(TransactionAspectSupport.java:276)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:100)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)
at $Proxy4.getSearchResults(Unknown Source)
at com.regence.sds.aat.web.action.SearchAction.execute(SearchAction.java:55)
at org.springframework.web.struts.DelegatingActionProxy.execute(DelegatingActionProxy.java:106)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:449)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:264)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1176)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:472)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:966)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:907)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:145)
at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:174)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:130)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:87)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:701)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:646)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:475)
at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:463)
at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3129)
at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:238)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:811)
at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1433)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:93)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:465)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:394)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:102)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:152)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:213)
at com.ibm.io.async.AbstractAsyncFuture.fireCompletionActions(AbstractAsyncFuture.java:195)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:194)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:741)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:863)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1510)
Caused by:
com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: Connection is closed.
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.runtimeXIfNotClosed(WSJdbcConnection.java:2566)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.rollback(WSJdbcConnection.java:2533)
at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:183)
at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:162)
... 44 more
2006-12-08 21:09:47,403 [WebContainer : 0] ERROR [com.regence.sds.aat.web.util.ActionExceptionHandler] - Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: JDBC rollback failed
org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: JDBC rollback failed
org.hibernate.TransactionException: JDBC rollback failed
at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:170)
at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:509)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:578)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:555)
at org.springframework.transaction.interceptor.TransactionAspectSupport.doCloseTransactionAfterThrowing(TransactionAspectSupport.java:276)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:100)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)
at $Proxy4.getSearchResults(Unknown Source)
at com.regence.sds.aat.web.action.SearchAction.execute(SearchAction.java:55)
at org.springframework.web.struts.DelegatingActionProxy.execute(DelegatingActionProxy.java:106)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:449)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:264)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1176)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:472)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:966)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:907)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:145)
at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:174)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:130)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:87)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:701)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:646)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:475)
at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:463)
at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3129)
at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:238)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:811)
at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1433)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:93)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:465)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:394)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:102)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:152)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:213)
at com.ibm.io.async.AbstractAsyncFuture.fireCompletionActions(AbstractAsyncFuture.java:195)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:194)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:741)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:863)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1510)
Caused by:
com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: Connection is closed.
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.runtimeXIfNotClosed(WSJdbcConnection.java:2566)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.rollback(WSJdbcConnection.java:2533)
at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:183)
at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:162)
... 44 more
2006-12-08 21:09:47,479 [WebContainer : 0] ERROR [com.regence.sds.aat.web.util.ActionExceptionHandler] - Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: JDBC rollback failed
org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: JDBC rollback failed
org.hibernate.TransactionException: JDBC rollback failed
at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:170)
at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:509)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:578)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:555)
at org.springframework.transaction.interceptor.TransactionAspectSupport.doCloseTransactionAfterThrowing(TransactionAspectSupport.java:276)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:100)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)
at $Proxy4.getSearchResults(Unknown Source)
at com.regence.sds.aat.web.action.SearchAction.execute(SearchAction.java:55)
at org.springframework.web.struts.DelegatingActionProxy.execute(DelegatingActionProxy.java:106)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:449)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:264)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1176)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:472)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:966)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:907)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:145)
at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:174)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:130)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:87)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:701)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:646)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:475)
at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:463)
at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3129)
at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:238)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:811)
at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1433)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:93)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:465)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:394)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:102)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:152)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:213)
at com.ibm.io.async.AbstractAsyncFuture.fireCompletionActions(AbstractAsyncFuture.java:195)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:194)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:741)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:863)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1510)
Caused by:
com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: Connection is closed.
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.runtimeXIfNotClosed(WSJdbcConnection.java:2566)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.rollback(WSJdbcConnection.java:2533)
at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:183)
at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:162)
... 44 more
Name and version of the database you are using:
Oracle 10g
The generated SQL (show_sql=true):
select this_.SAAR_ID as SAAR1_0_2_, this_.WORKFLOW_ST_ID as WORKFLOW2_0_2_, this_.SAAR_TYP_CD as SAAR3_0_2_, this_.RQSTR_USER_ID_CD as RQSTR4_0_2_, this_.SALES_REPRSNTV_NAME_TXT as SALES5_0_2_, this_.AGCY_NAME_TXT as AGCY6_0_2_, this_.AGT_FST_NAME_TXT as AGT7_0_2_, this_.AGT_MID_NAME_TXT as AGT8_0_2_, this_.AGT_LST_NAME_TXT as AGT9_0_2_, this_.EMAIL_ADDR_TXT as EMAIL10_0_2_, this_.PH_NUM_TXT as PH11_0_2_, this_.PH_EXTSN_NUM_TXT as PH12_0_2_, this_.AGT_COCI_ID_CD as AGT13_0_2_, this_.AGT_COCE_ID_CD as AGT14_0_2_, this_.AGCY_COCI_ID_CD as AGCY15_0_2_, this_.AGCY_COCE_ID_CD as AGCY16_0_2_, stateplan1_.SAAR_PLN_ST_ID as SAAR1_1_0_, stateplan1_.AFFLT_ID as AFFLT2_1_0_, stateplan1_.GRP_PLN_IND as GRP3_1_0_, stateplan1_.INDIVL_PLN_IND as INDIVL4_1_0_, stateplan1_.MCARE_PLN_IND as MCARE5_1_0_, stateplan1_.LIFE_PLN_IND as LIFE6_1_0_, stateplan1_.EO_FORM_COMPLT_IND as EO7_1_0_, stateplan1_.AFFLTN_FORM_COMPLT_IND as AFFLTN8_1_0_, stateplan1_.CNTRCT_FORM_COMPLT_IND as CNTRCT9_1_0_, stateplan1_.TRNG_CERTN_FORM_COMPLT_IND as TRNG10_1_0_, stateplan1_.LIC_FORM_COMPLT_IND as LIC11_1_0_, state2_.AFFLT_ID as AFFLT1_5_1_, state2_.AFFLT_CD as AFFLT2_5_1_, state2_.AFFLT_NAME_TXT as AFFLT3_5_1_, state2_.RECPNT_NTFCN_EMAIL_TXT as RECPNT4_5_1_, state2_.NTFY_PENDG_IND as NTFY5_5_1_, state2_.NTFY_ACTV_IND as NTFY6_5_1_, state2_.NTFY_TRMNTD_IND as NTFY7_5_1_, state2_.NTFY_INACTV_IND as NTFY8_5_1_, state2_.NTFY_ANY_IND as NTFY9_5_1_, state2_.NTFY_COMPLT_IND as NTFY10_5_1_ from AAT.SAAR this_, AAT.SAAR_PLN_ST stateplan1_, AAT.AFFLT state2_ where this_.SAAR_ID=stateplan1_.SAAR_ID and stateplan1_.AFFLT_ID=state2_.AFFLT_ID and (state2_.AFFLT_CD=?) and (stateplan1_.GRP_PLN_IND=? or stateplan1_.INDIVL_PLN_IND=? or stateplan1_.LIFE_PLN_IND=? or stateplan1_.MCARE_PLN_IND=?)
Login
FAQ
Search