SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [S1000]; error code [0]; --- The error occurred while applying a parameter map. --- Check the ad.selectByStoreIdsWithBLOBS-InlineParameterMap. --- Check the results (failed to retrieve results). --- Cause: java.sql.SQLException: Operation not allowed after ResultSet closed; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred while applying a parameter map. --- Check the ad.selectByStoreIdsWithBLOBS-InlineParameterMap. --- Check the results (failed to retrieve results). --- Cause: java.sql.SQLException: Operation not allowed after ResultSet closed

org.springframework.jdbc.UncategorizedSQLException

/productBrowseView/view/150467_HomeDelivery.pml

hierarchy=2%7CFood%7CPurina+Pro+Plan+Veterinary+Diet%7CDH+Dental+Health

org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [S1000]; error code [0]; --- The error occurred while applying a parameter map. --- Check the ad.selectByStoreIdsWithBLOBS-InlineParameterMap. --- Check the results (failed to retrieve results). --- Cause: java.sql.SQLException: Operation not allowed after ResultSet closed; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred while applying a parameter map. --- Check the ad.selectByStoreIdsWithBLOBS-InlineParameterMap. --- Check the results (failed to retrieve results). --- Cause: java.sql.SQLException: Operation not allowed after ResultSet closed at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:121) 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 com.seqtek.ac.dao.ad.AdDao.selectByStoreIdsWithBLOBS(AdDao.java:13) at com.seqtek.ecompml.ad.AdBean.doAssignLoad(AdBean.java:23) at com.seqtek.ac.domain.marshal.SiteSessionMarshaler.marshal(SiteSessionMarshaler.java:163) at com.seqtek.ac.menus.MenusListBean.marshal(MenusListBean.java:278) at sun.reflect.GeneratedMethodAccessor806.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.seqtek.pml.parser.handlers.content.bean.Bean.setObjectState(Bean.java:172) at com.seqtek.pml.parser.handlers.content.bean.Bean.doPostprocess(Bean.java:147) at com.seqtek.pml.parser.handlers.action.tag.PMLTagHandler.postprocess(PMLTagHandler.java:148) at com.seqtek.pml.parser.Parser.parseDocument(Parser.java:602) at com.seqtek.pml.parser.Parser.parseDocument(Parser.java:651) at com.seqtek.pml.parser.Parser.parseDocument(Parser.java:581) at com.seqtek.pml.parser.Parser.parseXML(Parser.java:469) at com.seqtek.pml.parser.Parser.load(Parser.java:251) at com.seqtek.pml.parser.Parser.load(Parser.java:226) at com.seqtek.pml.module.SpringModularSiteServlet.postRequest(SpringModularSiteServlet.java:178) at com.seqtek.pml.module.SpringModularSiteServlet.doPost(SpringModularSiteServlet.java:97) at com.seqtek.pml.module.SpringModularSiteServlet.doGet(SpringModularSiteServlet.java:83) at javax.servlet.http.HttpServlet.service(HttpServlet.java:624) at javax.servlet.http.HttpServlet.service(HttpServlet.java:731) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.seqtek.pml.module.PmlSiteModuleFilter.doFilter(PmlSiteModuleFilter.java:199) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:738) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:962) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.ha.session.JvmRouteBinderValve.invoke(JvmRouteBinderValve.java:218) at org.apache.catalina.ha.tcp.ReplicationValve.invoke(ReplicationValve.java:333) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1115) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748) Caused by: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred while applying a parameter map. --- Check the ad.selectByStoreIdsWithBLOBS-InlineParameterMap. --- Check the results (failed to retrieve results). --- Cause: java.sql.SQLException: Operation not allowed after ResultSet closed at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:185) at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:615) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:589) 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) ... 51 more Caused by: java.sql.SQLException: Operation not allowed after ResultSet closed at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919) at com.mysql.jdbc.ResultSetImpl.checkClosed(ResultSetImpl.java:803) at com.mysql.jdbc.ResultSetImpl.next(ResultSetImpl.java:6985) at org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:168) at org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:168) at com.ibatis.sqlmap.engine.execution.SqlExecutor.handleResults(SqlExecutor.java:380) at com.ibatis.sqlmap.engine.execution.SqlExecutor.handleMultipleResults(SqlExecutor.java:301) at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:190) at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205) at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173) ... 57 more