-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

View unanswered posts | View active topics


Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]


Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 3 posts ] 
  Previous topic | Next topic 
Author Message
t_a_chen
 Post subject: Can't execute query, connection timed out
PostPosted: Sat Dec 09, 2006 2:27 pm 
Newbie

Joined: Sat Dec 09, 2006 1:56 pm
Posts: 3
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=?)

_________________
Anthony

Top
 Profile  
 
t_a_chen
 Post subject: BTW, many other queries in the same app runs without problem
PostPosted: Sat Dec 09, 2006 2:33 pm 
Newbie

Joined: Sat Dec 09, 2006 1:56 pm
Posts: 3
But this one hangs consistently.

_________________
Anthony

Top
 Profile  
 
t_a_chen
 Post subject: Here is the debug tracing before the code hangs
PostPosted: Mon Dec 11, 2006 12:51 pm 
Newbie

Joined: Sat Dec 09, 2006 1:56 pm
Posts: 3
Here is the debug tracing before the code hangs. I checked the JDBC connection openning and releaseing lines, they all matched up.

...
2006-12-11 01:10:54,452 [WebContainer : 0] DEBUG [org.hibernate.pretty.Printer] - more......
2006-12-11 01:10:54,484 [WebContainer : 0] DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] - executing flush
2006-12-11 01:10:54,516 [WebContainer : 0] DEBUG [org.hibernate.event.def.AbstractFlushingEventListener] - post flush
2006-12-11 01:10:54,548 [WebContainer : 0] DEBUG [org.hibernate.jdbc.JDBCContext] - before transaction completion
2006-12-11 01:10:54,578 [WebContainer : 0] DEBUG [org.hibernate.impl.SessionImpl] - before transaction completion
2006-12-11 01:10:54,609 [WebContainer : 0] DEBUG [org.hibernate.transaction.JDBCTransaction] - re-enabling autocommit
2006-12-11 01:10:54,640 [WebContainer : 0] DEBUG [org.hibernate.transaction.JDBCTransaction] - committed JDBC Connection
2006-12-11 01:10:54,671 [WebContainer : 0] DEBUG [org.hibernate.jdbc.JDBCContext] - after transaction completion
2006-12-11 01:10:54,701 [WebContainer : 0] DEBUG [org.hibernate.jdbc.ConnectionManager] - aggressively releasing JDBC connection
2006-12-11 01:10:54,732 [WebContainer : 0] DEBUG [org.hibernate.jdbc.ConnectionManager] - releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
2006-12-11 01:10:54,763 [WebContainer : 0] DEBUG [org.hibernate.impl.SessionImpl] - after transaction completion
2006-12-11 01:10:54,794 [WebContainer : 0] DEBUG [org.hibernate.jdbc.ConnectionManager] - opening JDBC connection
2006-12-11 01:10:54,826 [WebContainer : 0] DEBUG [org.hibernate.impl.SessionImpl] - setting flush mode to: NEVER
2006-12-11 01:10:56,040 [WebContainer : 0] DEBUG [org.hibernate.impl.SessionImpl] - closing session
2006-12-11 01:10:56,069 [WebContainer : 0] DEBUG [org.hibernate.jdbc.ConnectionManager] - performing cleanup
2006-12-11 01:10:56,095 [WebContainer : 0] DEBUG [org.hibernate.jdbc.ConnectionManager] - releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
2006-12-11 01:10:56,121 [WebContainer : 0] DEBUG [org.hibernate.jdbc.JDBCContext] - after transaction completion
2006-12-11 01:10:56,146 [WebContainer : 0] DEBUG [org.hibernate.jdbc.ConnectionManager] - aggressively releasing JDBC connection
2006-12-11 01:10:56,172 [WebContainer : 0] DEBUG [org.hibernate.impl.SessionImpl] - after transaction completion
2006-12-11 01:12:09,867 [WebContainer : 2] DEBUG [org.hibernate.impl.SessionImpl] - opened session at timestamp: 11658247298
2006-12-11 01:12:09,892 [WebContainer : 2] DEBUG [org.hibernate.impl.SessionImpl] - setting flush mode to: NEVER
2006-12-11 01:12:09,915 [WebContainer : 2] DEBUG [org.hibernate.impl.SessionImpl] - closing session
2006-12-11 01:12:09,935 [WebContainer : 2] DEBUG [org.hibernate.jdbc.ConnectionManager] - connection already null in cleanup : no action
2006-12-11 01:12:15,471 [WebContainer : 0] DEBUG [org.hibernate.impl.SessionImpl] - opened session at timestamp: 11658247354
2006-12-11 01:12:15,501 [WebContainer : 0] DEBUG [org.hibernate.impl.SessionImpl] - setting flush mode to: NEVER
2006-12-11 01:12:15,531 [WebContainer : 0] DEBUG [org.hibernate.impl.SessionImpl] - setting flush mode to: AUTO
2006-12-11 01:12:15,560 [WebContainer : 0] DEBUG [org.hibernate.transaction.JDBCTransaction] - begin
2006-12-11 01:12:15,588 [WebContainer : 0] DEBUG [org.hibernate.jdbc.ConnectionManager] - opening JDBC connection
2006-12-11 01:12:15,617 [WebContainer : 0] DEBUG [org.hibernate.transaction.JDBCTransaction] - current autocommit status: true
2006-12-11 01:12:15,645 [WebContainer : 0] DEBUG [org.hibernate.transaction.JDBCTransaction] - disabling autocommit
2006-12-11 01:12:15,672 [WebContainer : 0] DEBUG [org.hibernate.jdbc.JDBCContext] - after transaction begin
2006-12-11 01:12:15,700 [WebContainer : 0] DEBUG [com.regence.sds.aat.service.impl.MediatorImpl] - Conducting search
2006-12-11 01:12:15,700 [WebContainer : 0] DEBUG [com.regence.sds.aat.service.impl.MediatorImpl] - Conducting search
2006-12-11 01:12:15,730 [WebContainer : 0] DEBUG [com.regence.sds.aat.service.impl.SAARManagerImpl] - Finding saar by search criteria
2006-12-11 01:12:15,730 [WebContainer : 0] DEBUG [com.regence.sds.aat.service.impl.SAARManagerImpl] - Finding saar by search criteria
2006-12-11 01:12:15,785 [WebContainer : 0] DEBUG [org.hibernate.jdbc.AbstractBatcher] - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2006-12-11 01:12:15,824 [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=?) and (stateplan1_.GRP_PLN_IND=? or stateplan1_.INDIVL_PLN_IND=? or stateplan1_.LIFE_PLN_IND=? or stateplan1_.MCARE_PLN_IND=?)
2006-12-11 01:12:15,862 [WebContainer : 0] DEBUG [org.hibernate.jdbc.AbstractBatcher] - preparing statement
2006-12-11 01:12:15,903 [WebContainer : 0] DEBUG [org.hibernate.type.StringType] - binding 'ID' to parameter: 1
2006-12-11 01:12:15,943 [WebContainer : 0] DEBUG [org.hibernate.type.YesNoType] - binding 'true' to parameter: 2
2006-12-11 01:12:15,983 [WebContainer : 0] DEBUG [org.hibernate.type.YesNoType] - binding 'true' to parameter: 3
2006-12-11 01:12:16,023 [WebContainer : 0] DEBUG [org.hibernate.type.YesNoType] - binding 'true' to parameter: 4
2006-12-11 01:12:16,063 [WebContainer : 0] DEBUG [org.hibernate.type.YesNoType] - binding 'true' to parameter: 5

_________________
Anthony

Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 3 posts ] 

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.