SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; --- The error occurred in com/seqtek/ac/dao/ad/sqlmap/ad_SqlMap.xml. --- The error occurred while executing query. --- Check the select ad.id, ad.type, ad_type.name typeAsString, ad.store_id, ad.value from ad, ad_asg, ad_type where ad.id = ad_asg.ad_id and ad_type.id = ad.type and ad_asg.store_id in ( ? , ? , ? ) . --- Check the SQL Statement (preparation failed). --- Cause: java.sql.SQLException: Connection is closed.; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in com/seqtek/ac/dao/ad/sqlmap/ad_SqlMap.xml. --- The error occurred while executing query. --- Check the select ad.id, ad.type, ad_type.name typeAsString, ad.store_id, ad.value from ad, ad_asg, ad_type where ad.id = ad_asg.ad_id and ad_type.id = ad.type and ad_asg.store_id in ( ? , ? , ? ) . --- Check the SQL Statement (preparation failed). --- Cause: java.sql.SQLException: Connection is closed.

org.springframework.jdbc.UncategorizedSQLException

/productBrowseView/view/62482_HomeDelivery.pml

hierarchy=2%7CAll+Dog%7CHeartworm%7CTopical+Solutions

org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; --- The error occurred in com/seqtek/ac/dao/ad/sqlmap/ad_SqlMap.xml. --- The error occurred while executing query. --- Check the select ad.id, ad.type, ad_type.name typeAsString, ad.store_id, ad.value from ad, ad_asg, ad_type where ad.id = ad_asg.ad_id and ad_type.id = ad.type and ad_asg.store_id in ( ? , ? , ? ) . --- Check the SQL Statement (preparation failed). --- Cause: java.sql.SQLException: Connection is closed.; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in com/seqtek/ac/dao/ad/sqlmap/ad_SqlMap.xml. --- The error occurred while executing query. --- Check the select ad.id, ad.type, ad_type.name typeAsString, ad.store_id, ad.value from ad, ad_asg, ad_type where ad.id = ad_asg.ad_id and ad_type.id = ad.type and ad_asg.store_id in ( ? , ? , ? ) . --- Check the SQL Statement (preparation failed). --- Cause: java.sql.SQLException: Connection is 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.GeneratedMethodAccessor437.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:318) 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 in com/seqtek/ac/dao/ad/sqlmap/ad_SqlMap.xml. --- The error occurred while executing query. --- Check the select ad.id, ad.type, ad_type.name typeAsString, ad.store_id, ad.value from ad, ad_asg, ad_type where ad.id = ad_asg.ad_id and ad_type.id = ad.type and ad_asg.store_id in ( ? , ? , ? ) . --- Check the SQL Statement (preparation failed). --- Cause: java.sql.SQLException: Connection is 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: Connection is closed. at org.apache.commons.dbcp.DelegatingConnection.checkOpen(DelegatingConnection.java:291) at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:183) at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:278) at com.ibatis.sqlmap.engine.execution.SqlExecutor.prepareStatement(SqlExecutor.java:494) at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:176) 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