<p>Am I the only one obessesed enough to copy the code? lol</p>
<p>javax.xml.ws.soap.SOAPFaultException: SqlMapClient operation; uncategorized SQLException for SQL ; SQL state [null]; error code [17008];<br>
— The error occurred in ApplicationChecklistItem.ibatis.xml.<br>
— The error occurred while executing query.<br>
— Check the select ci.seq<em>3C, ci.checklist</em>seq, ci.common<em>id emplid, vd.adm</em>appl<em>nbr, ci.chklst</em>item<em>cd, ci.item</em>status, ci.due<em>dt, ci.name association</em>name, cit.descr, cit.descrshort, cit.descrlong from SYSADM.PS<em>PERSON</em>CHECKLST CK, sysadm.ps<em>person</em>chk<em>item ci, sysadm.PS</em>VAR<em>DATA</em>ADMA vd, sysadm.PS<em>SCC</em>CKLSITM<em>TBL cit, PS</em>CHKLST<em>ITEM</em>VW2 citv where CK.COMMON<em>ID=CI.COMMON</em>ID and ck.seq<em>3C = ci.seq</em>3C AND CK.common<em>id = vd.common</em>id and ck.var<em>data</em>seq=vd.var<em>data</em>seq and ci.chklst<em>item</em>cd = citv.chklst<em>item</em>cd and cit.chklst<em>item</em>cd = citv.chklst<em>item</em>cd AND ci.ITEM<em>STATUS NOT IN (‘C’,‘P’,‘X’,‘W’) AND CK.ADMIN</em>FUNCTION =‘ADMA’ AND CK.CHECKLIST<em>CD IN ( SELECT CHECKLIST</em>CD FROM PS<em>CS</em>CHKLST<em>TBL S WHERE S.SCC</em>TODO<em>SS</em>DISP = ‘Y’ AND S.INSTITUTION = CK.INSTITUTION AND S.EFFDT = ( SELECT MAX(S1.EFFDT) FROM PS<em>CS</em>CHKLST<em>TBL S1 WHERE S.INSTITUTION = S1.INSTITUTION AND S.CHECKLIST</em>CD = S1.CHECKLIST<em>CD AND S1.EFFDT <= SYSDATE)) and ci.common</em>id = ? and vd.adm<em>appl</em>nbr = ? .<br>
— Check the SQL Statement (preparation failed).<br>
— Cause: java.sql.SQLException: Closed Connection; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:<br>
— The error occurred in ApplicationChecklistItem.ibatis.xml.<br>
— The error occurred while executing query.<br>
— Check the select ci.seq<em>3C, ci.checklist</em>seq, ci.common<em>id emplid, vd.adm</em>appl<em>nbr, ci.chklst</em>item<em>cd, ci.item</em>status, ci.due<em>dt, ci.name association</em>name, cit.descr, cit.descrshort, cit.descrlong from SYSADM.PS<em>PERSON</em>CHECKLST CK, sysadm.ps<em>person</em>chk<em>item ci, sysadm.PS</em>VAR<em>DATA</em>ADMA vd, sysadm.PS<em>SCC</em>CKLSITM<em>TBL cit, PS</em>CHKLST<em>ITEM</em>VW2 citv where CK.COMMON<em>ID=CI.COMMON</em>ID and ck.seq<em>3C = ci.seq</em>3C AND CK.common<em>id = vd.common</em>id and ck.var<em>data</em>seq=vd.var<em>data</em>seq and ci.chklst<em>item</em>cd = citv.chklst<em>item</em>cd and cit.chklst<em>item</em>cd = citv.chklst<em>item</em>cd AND ci.ITEM<em>STATUS NOT IN (‘C’,‘P’,‘X’,‘W’) AND CK.ADMIN</em>FUNCTION =‘ADMA’ AND CK.CHECKLIST<em>CD IN ( SELECT CHECKLIST</em>CD FROM PS<em>CS</em>CHKLST<em>TBL S WHERE S.SCC</em>TODO<em>SS</em>DISP = ‘Y’ AND S.INSTITUTION = CK.INSTITUTION AND S.EFFDT = ( SELECT MAX(S1.EFFDT) FROM PS<em>CS</em>CHKLST<em>TBL S1 WHERE S.INSTITUTION = S1.INSTITUTION AND S.CHECKLIST</em>CD = S1.CHECKLIST<em>CD AND S1.EFFDT <= SYSDATE)) and ci.common</em>id = ? and vd.adm<em>appl</em>nbr = ? .<br>
— Check the SQL Statement (preparation failed).<br>
— Cause: java.sql.SQLException: Closed Connection
at com.sun.xml.ws.fault.SOAP11Fault.getProtocolException(SOAP11Fault.java:188)
at com.sun.xml.ws.fault.SOAPFaultBuilder.createException(SOAPFaultBuilder.java:116)
at com.sun.xml.ws.client.sei.SyncMethodHandler.invoke(SyncMethodHandler.java:119)
at com.sun.xml.ws.client.sei.SyncMethodHandler.invoke(SyncMethodHandler.java:89)
at com.sun.xml.ws.client.sei.SEIStub.invoke(SEIStub.java:118)
at $Proxy95.getApplicationChecklist(Unknown Source)
at edu.unc.its.portal.category.controller.ApplicationsViewController.handleRequest(ApplicationsViewController.java:47)
at edu.unc.its.portal.springframework.web.portlet.mvc.ExceptionController.handleRenderRequestInternal(ExceptionController.java:22)
at org.springframework.web.portlet.mvc.AbstractController.handleRenderRequest(AbstractController.java:219)
at org.springframework.web.portlet.mvc.SimpleControllerHandlerAdapter.handleRender(SimpleControllerHandlerAdapter.java:52)
at org.springframework.web.portlet.DispatcherPortlet.doRenderService(DispatcherPortlet.java:811)
at org.springframework.web.portlet.FrameworkPortlet.processRequest(FrameworkPortlet.java:483)
at org.springframework.web.portlet.FrameworkPortlet.doDispatch(FrameworkPortlet.java:453)
at javax.portlet.GenericPortlet.render(GenericPortlet.java:233)
at com.sun.portal.portletcontainer.appengine.PortletAppEngineServlet.service(PortletAppEngineServlet.java:389)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
at sun.reflect.GeneratedMethodAccessor114.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:292)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:325)
at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:208)
at org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:420)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:333)
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:91)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:197)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at com.sun.portal.portletcontainer.appengine.PortletAppEngineFilter.doFilter(PortletAppEngineFilter.java:105)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246)
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:91)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:197)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationDispatcher.doInvoke(ApplicationDispatcher.java:873)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:723)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:679)
at org.apache.catalina.core.ApplicationDispatcher.access$100(ApplicationDispatcher.java:123)
at org.apache.catalina.core.ApplicationDispatcher$PrivilegedInclude.run(ApplicationDispatcher.java:154)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:585)
at com.sun.portal.portletcontainer.impl.PortletContainer.invokePAE(PortletContainer.java:790)
at com.sun.portal.portletcontainer.impl.PortletContainer.invokePAE(PortletContainer.java:673)
at com.sun.portal.portletcontainer.impl.PortletContainer.getMarkup(PortletContainer.java:209)
at com.sun.portal.providers.window.WindowProvider.getPortletContent(WindowProvider.java:382)
at com.sun.portal.providers.window.WindowProvider.getContentInternal(WindowProvider.java:247)
at com.sun.portal.providers.window.WindowProvider.getContent(WindowProvider.java:212)
at com.sun.portal.providers.portletwindow.PortletWindowProvider.getContent(PortletWindowProvider.java:109)
at com.sun.portal.desktop.context.ReusableProviderCaller.run(ReusableProviderCaller.java:206)
Caused by: org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL ; SQL state [null]; error code [17008];<br>
— The error occurred in ApplicationChecklistItem.ibatis.xml.<br>
— The error occurred while executing query.<br>
— Check the select ci.seq<em>3C, ci.checklist</em>seq, ci.common<em>id emplid, vd.adm</em>appl<em>nbr, ci.chklst</em>item<em>cd, ci.item</em>status, ci.due<em>dt, ci.name association</em>name, cit.descr, cit.descrshort, cit.descrlong from SYSADM.PS<em>PERSON</em>CHECKLST CK, sysadm.ps<em>person</em>chk<em>item ci, sysadm.PS</em>VAR<em>DATA</em>ADMA vd, sysadm.PS<em>SCC</em>CKLSITM<em>TBL cit, PS</em>CHKLST<em>ITEM</em>VW2 citv where CK.COMMON<em>ID=CI.COMMON</em>ID and ck.seq<em>3C = ci.seq</em>3C AND CK.common<em>id = vd.common</em>id and ck.var<em>data</em>seq=vd.var<em>data</em>seq and ci.chklst<em>item</em>cd = citv.chklst<em>item</em>cd and cit.chklst<em>item</em>cd = citv.chklst<em>item</em>cd AND ci.ITEM<em>STATUS NOT IN (‘C’,‘P’,‘X’,‘W’) AND CK.ADMIN</em>FUNCTION =‘ADMA’ AND CK.CHECKLIST<em>CD IN ( SELECT CHECKLIST</em>CD FROM PS<em>CS</em>CHKLST<em>TBL S WHERE S.SCC</em>TODO<em>SS</em>DISP = ‘Y’ AND S.INSTITUTION = CK.INSTITUTION AND S.EFFDT = ( SELECT MAX(S1.EFFDT) FROM PS<em>CS</em>CHKLST<em>TBL S1 WHERE S.INSTITUTION = S1.INSTITUTION AND S.CHECKLIST</em>CD = S1.CHECKLIST<em>CD AND S1.EFFDT <= SYSDATE)) and ci.common</em>id = ? and vd.adm<em>appl</em>nbr = ? .<br>
— Check the SQL Statement (preparation failed).<br>
— Cause: java.sql.SQLException: Closed Connection; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:<br>
— The error occurred in ApplicationChecklistItem.ibatis.xml.<br>
— The error occurred while executing query.<br>
— Check the select ci.seq<em>3C, ci.checklist</em>seq, ci.common<em>id emplid, vd.adm</em>appl<em>nbr, ci.chklst</em>item<em>cd, ci.item</em>status, ci.due<em>dt, ci.name association</em>name, cit.descr, cit.descrshort, cit.descrlong from SYSADM.PS<em>PERSON</em>CHECKLST CK, sysadm.ps<em>person</em>chk<em>item ci, sysadm.PS</em>VAR<em>DATA</em>ADMA vd, sysadm.PS<em>SCC</em>CKLSITM<em>TBL cit, PS</em>CHKLST<em>ITEM</em>VW2 citv where CK.COMMON<em>ID=CI.COMMON</em>ID and ck.seq<em>3C = ci.seq</em>3C AND CK.common<em>id = vd.common</em>id and ck.var<em>data</em>seq=vd.var<em>data</em>seq and ci.chklst<em>item</em>cd = citv.chklst<em>item</em>cd and cit.chklst<em>item</em>cd = citv.chklst<em>item</em>cd AND ci.ITEM<em>STATUS NOT IN (‘C’,‘P’,‘X’,‘W’) AND CK.ADMIN</em>FUNCTION =‘ADMA’ AND CK.CHECKLIST<em>CD IN ( SELECT CHECKLIST</em>CD FROM PS<em>CS</em>CHKLST<em>TBL S WHERE S.SCC</em>TODO<em>SS</em>DISP = ‘Y’ AND S.INSTITUTION = CK.INSTITUTION AND S.EFFDT = ( SELECT MAX(S1.EFFDT) FROM PS<em>CS</em>CHKLST<em>TBL S1 WHERE S.INSTITUTION = S1.INSTITUTION AND S.CHECKLIST</em>CD = S1.CHECKLIST<em>CD AND S1.EFFDT <= SYSDATE)) and ci.common</em>id = ? and vd.adm<em>appl</em>nbr = ? .<br>
— Check the SQL Statement (preparation failed).<br>
— Cause: java.sql.SQLException: Closed Connection
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:124)
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:322)
at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:212)
at org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResult(SqlMapClientTemplate.java:249)
at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapClientTemplate.java:296)
at edu.unc.its.services.admission.application.dao.ApplicationChecklistItemDao.getChecklistItemsByEmplIdAndApplicationNumber(ApplicationChecklistItemDao.java:21)
at edu.unc.its.services.admission.application.service.AdmissionsApplicationService.getApplicationChecklist(AdmissionsApplicationService.java:69)
at edu.unc.its.services.admission.application.service.AdmissionsApplicationWebService.getApplicationChecklist(AdmissionsApplicationWebService.java:40)
at sun.reflect.GeneratedMethodAccessor137.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.sun.enterprise.webservice.InstanceResolverImpl$1.invoke(InstanceResolverImpl.java:112)
at com.sun.xml.ws.server.InvokerTube$2.invoke(InvokerTube.java:146)
at com.sun.xml.ws.server.sei.EndpointMethodHandler.invoke(EndpointMethodHandler.java:257)
at com.sun.xml.ws.server.sei.SEIInvokerTube.processRequest(SEIInvokerTube.java:93)
at com.sun.xml.ws.api.pipe.Fiber.<strong>doRun(Fiber.java:595)
at com.sun.xml.ws.api.pipe.Fiber._doRun(Fiber.java:554)
at com.sun.xml.ws.api.pipe.Fiber.doRun(Fiber.java:539)
at com.sun.xml.ws.api.pipe.Fiber.runSync(Fiber.java:436)
at com.sun.xml.ws.api.pipe.helper.AbstractTubeImpl.process(AbstractTubeImpl.java:106)
at com.sun.enterprise.webservice.MonitoringPipe.process(MonitoringPipe.java:147)
at com.sun.xml.ws.api.pipe.helper.PipeAdapter.processRequest(PipeAdapter.java:115)
at com.sun.xml.ws.api.pipe.Fiber.</strong>doRun(Fiber.java:595)
at com.sun.xml.ws.api.pipe.Fiber.<em>doRun(Fiber.java:554)
at com.sun.xml.ws.api.pipe.Fiber.doRun(Fiber.java:539)
at com.sun.xml.ws.api.pipe.Fiber.runSync(Fiber.java:436)
at com.sun.xml.ws.api.pipe.helper.AbstractTubeImpl.process(AbstractTubeImpl.java:106)
at com.sun.enterprise.webservice.CommonServerSecurityPipe$1.run(CommonServerSecurityPipe.java:236)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
at com.sun.enterprise.webservice.CommonServerSecurityPipe.processRequest(CommonServerSecurityPipe.java:232)
at com.sun.enterprise.webservice.CommonServerSecurityPipe.process(CommonServerSecurityPipe.java:133)
at com.sun.xml.ws.api.pipe.helper.PipeAdapter.processRequest(PipeAdapter.java:115)
at com.sun.xml.ws.api.pipe.Fiber.</em><em>doRun(Fiber.java:595)
at com.sun.xml.ws.api.pipe.Fiber.</em>doRun(Fiber.java:554)
at com.sun.xml.ws.api.pipe.Fiber.doRun(Fiber.java:539)
at com.sun.xml.ws.api.pipe.Fiber.runSync(Fiber.java:436)
at com.sun.xml.ws.server.WSEndpointImpl$2.process(WSEndpointImpl.java:243)
at com.sun.xml.ws.transport.http.HttpAdapter$HttpToolkit.handle(HttpAdapter.java:444)
at com.sun.xml.ws.transport.http.HttpAdapter.handle(HttpAdapter.java:244)
at com.sun.xml.ws.transport.http.servlet.ServletAdapter.handle(ServletAdapter.java:135)
at com.sun.enterprise.webservice.JAXWSServlet.doPost(JAXWSServlet.java:177)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:754)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
at sun.reflect.GeneratedMethodAccessor78.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:292)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:325)
at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:208)
at org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:420)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:315)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:287)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:218)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:648)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:593)
at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:94)
at com.sun.enterprise.web.PESessionLockingStandardPipeline.invoke(PESessionLockingStandardPipeline.java:98)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:222)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:648)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:593)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:587)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1096)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:166)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:648)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:593)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:587)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1096)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:288)
at com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.invokeAdapter(DefaultProcessorTask.java:647)
at com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.doProcess(DefaultProcessorTask.java:579)
at com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.process(DefaultProcessorTask.java:831)
at com.sun.enterprise.web.connector.grizzly.DefaultReadTask.executeProcessorTask(DefaultReadTask.java:341)
at com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadTask.java:263)
at com.sun.enterprise.web.connector.grizzly.DefaultReadTask.doTask(DefaultReadTask.java:214)
at com.sun.enterprise.web.connector.grizzly.TaskBase.run(TaskBase.java:265)
at com.sun.enterprise.web.connector.grizzly.ssl.SSLWorkerThread.run(SSLWorkerThread.java:106)
Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:<br>
— The error occurred in ApplicationChecklistItem.ibatis.xml.<br>
— The error occurred while executing query.<br>
— Check the select ci.seq<em>3C, ci.checklist</em>seq, ci.common<em>id emplid, vd.adm</em>appl<em>nbr, ci.chklst</em>item<em>cd, ci.item</em>status, ci.due<em>dt, ci.name association</em>name, cit.descr, cit.descrshort, cit.descrlong from SYSADM.PS<em>PERSON</em>CHECKLST CK, sysadm.ps<em>person</em>chk<em>item ci, sysadm.PS</em>VAR<em>DATA</em>ADMA vd, sysadm.PS<em>SCC</em>CKLSITM<em>TBL cit, PS</em>CHKLST<em>ITEM</em>VW2 citv where CK.COMMON<em>ID=CI.COMMON</em>ID and ck.seq<em>3C = ci.seq</em>3C AND CK.common<em>id = vd.common</em>id and ck.var<em>data</em>seq=vd.var<em>data</em>seq and ci.chklst<em>item</em>cd = citv.chklst<em>item</em>cd and cit.chklst<em>item</em>cd = citv.chklst<em>item</em>cd AND ci.ITEM<em>STATUS NOT IN (‘C’,‘P’,‘X’,‘W’) AND CK.ADMIN</em>FUNCTION =‘ADMA’ AND CK.CHECKLIST<em>CD IN ( SELECT CHECKLIST</em>CD FROM PS<em>CS</em>CHKLST<em>TBL S WHERE S.SCC</em>TODO<em>SS</em>DISP = ‘Y’ AND S.INSTITUTION = CK.INSTITUTION AND S.EFFDT = ( SELECT MAX(S1.EFFDT) FROM PS<em>CS</em>CHKLST<em>TBL S1 WHERE S.INSTITUTION = S1.INSTITUTION AND S.CHECKLIST</em>CD = S1.CHECKLIST<em>CD AND S1.EFFDT <= SYSDATE)) and ci.common</em>id = ? and vd.adm<em>appl</em>nbr = ? .<br>
— Check the SQL Statement (preparation failed).<br>
— Cause: java.sql.SQLException: Closed Connection
at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:201)
at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForList(MappedStatement.java:139)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:567)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:541)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
at org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(SqlMapClientTemplate.java:298)
at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:209)
… 76 more
Caused by: java.sql.SQLException: Closed Connection
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
at oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:840)
at oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:759)
at oracle.jdbc.OracleConnectionWrapper.prepareStatement(OracleConnectionWrapper.java:92)
at com.sun.gjc.spi.base.ConnectionHolder.prepareStatement(ConnectionHolder.java:475)
at sun.reflect.GeneratedMethodAccessor115.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.java:225)
at $Proxy111.prepareStatement(Unknown Source)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.prepareStatement(SqlExecutor.java:497)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:175)
at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteQuery(MappedStatement.java:221)
at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:189)
… 82 more</p>