| Ошибка отображения страницы. |
| java.sql.SQLException: Invalid state, the Connection object is closed. |
|
Database: mssql Query
"SELECT [cmsSitePage_CMS_SITEPAGE].[A_REDIRECTPAGE] AS [redirectPage], [cmsSitePage_CMS_SITEPAGE].[A_ANONIMACCESS] AS [anonymousAccess], [T635951936].[OUID] AS [redirectPage_id_ouid], [T1950508033].[A_NAME] AS [parent_name], [cmsSitePage_CMS_SITEPAGE].[A_KEYWORDS] AS [keywords], [cmsSitePage_CMS_SITEPAGE].[A_NAME] AS [name], [cmsSitePage_CMS_SITEPAGE].[OUID] AS [id_ouid], [cmsSitePage_CMS_SITEPAGE].[A_CACHEONPROXY] AS [cacheOnProxy], [cmsSitePage_CMS_SITEPAGE].[A_TEMPLATE] AS [template], [cmsSitePage_CMS_SITEPAGE].[A_PARENT] AS [parent], [T635951936].[A_CODE] AS [redirectPage_code], [cmsSitePage_CMS_SITEPAGE].[A_DESIGN] AS [design], [T778320585].[A_NAME] AS [noAccessPage_name], [T778320585].[OUID] AS [noAccessPage_id_ouid], [cmsSitePage_CMS_SITEPAGE].[A_DESCR] AS [description], [T1950508033].[OUID] AS [parent_id_ouid], [cmsSitePage_CMS_SITEPAGE].[A_PRINTTEMPL] AS [printTempl], [design_cmsDesign_CMS_DESIGN].[A_CODE] AS [design_code], [cmsSitePage_CMS_SITEPAGE].[A_NOACCESSPAGE] AS [noAccessPage], [cmsSitePage_CMS_SITEPAGE].[A_MAX_AGE] AS [maxAge], [cmsSitePage_CMS_SITEPAGE].[A_CODE] AS [code], [cmsSitePage_CMS_SITEPAGE].[A_REDIRECT_URL] AS [redirectUrl], [design_cmsDesign_CMS_DESIGN].[OUID] AS [design_id_ouid], [cmsSitePage_CMS_SITEPAGE].[A_HIDDEN] AS [hidden], [cmsSitePage_CMS_SITEPAGE].[A_MIN_AGE] AS [minAge], [cmsSitePage_CMS_SITEPAGE].[A_CACHE] AS [cache] FROM [CMS_SITEPAGE] [cmsSitePage_CMS_SITEPAGE] left JOIN [CMS_DESIGN] [design_cmsDesign_CMS_DESIGN] inner JOIN [SXOBJ] [design_cmsDesign_SXOBJ] ON [design_cmsDesign_CMS_DESIGN].[OUID]=[design_cmsDesign_SXOBJ].[OUID] ON [cmsSitePage_CMS_SITEPAGE].[A_DESIGN]=[design_cmsDesign_CMS_DESIGN].[OUID] left JOIN [CMS_SITEPAGE] [T778320585] inner JOIN [SXOBJ] [noAccessPage_cmsSitePage_SXOBJ] ON [T778320585].[OUID]=[noAccessPage_cmsSitePage_SXOBJ].[OUID] ON [cmsSitePage_CMS_SITEPAGE].[A_NOACCESSPAGE]=[T778320585].[OUID] left JOIN [CMS_SITEPAGE] [T635951936] inner JOIN [SXOBJ] [redirectPage_cmsSitePage_SXOBJ] ON [T635951936].[OUID]=[redirectPage_cmsSitePage_SXOBJ].[OUID] ON [cmsSitePage_CMS_SITEPAGE].[A_REDIRECTPAGE]=[T635951936].[OUID] left JOIN [CMS_SITEPAGE] [T1950508033] inner JOIN [SXOBJ] [parent_cmsSitePage_SXOBJ] ON [T1950508033].[OUID]=[parent_cmsSitePage_SXOBJ].[OUID] ON [cmsSitePage_CMS_SITEPAGE].[A_PARENT]=[T1950508033].[OUID] WHERE ([cmsSitePage_CMS_SITEPAGE].[A_CODE]= 'social/root/ppmi/Realisation/2027')
-- sx.datastore.db.SXDb.getStackTraceAsString:2998
-- sx.datastore.db.SXDb.executeQuery:683
-- sx.datastore.db.SXDb.selectPS:776
-- sx.datastore.db.SXDb.selectPS:761
-- sx.datastore.impl.sitex2.SXDsSitex2.executeQuery:3277
-- sx.datastore.impl.sitex2.SXDsSitex2._getObjList:2205
-- sx.datastore.SXDs.getObjList:382
-- sx.datastore.params.SXObjListParams.getObjList:2471
-- sx.cms.CmsServlet.getSitePage:1455
-- sx.cms.CmsServlet.getPage:1374
-- sx.cms.CmsServlet.processPage:929
-- sx.cms.CmsServlet.parallelProcessPage:578
-- sx.cms.CmsServlet.runGet:542
-- sx.cms.CmsServlet.service:468"
|
Подробности
sx.datastore.db.SXDbException: Error while query execution: Invalid state, the Connection object is closed. at sx.datastore.db.SXDb.executeQuery(SXDb.java:723) at sx.datastore.db.SXDb.selectPS(SXDb.java:776) at sx.datastore.db.SXDb.selectPS(SXDb.java:761) at sx.datastore.impl.sitex2.SXDsSitex2.executeQuery(SXDsSitex2.java:3277) at sx.datastore.impl.sitex2.SXDsSitex2._getObjList(SXDsSitex2.java:2205) at sx.datastore.SXDs.getObjList(SXDs.java:382) at sx.datastore.params.SXObjListParams.getObjList(SXObjListParams.java:2471) at sx.cms.CmsServlet.getSitePage(CmsServlet.java:1455) at sx.cms.CmsServlet.getPage(CmsServlet.java:1374) at sx.cms.CmsServlet.processPage(CmsServlet.java:929) at sx.cms.CmsServlet.parallelProcessPage(CmsServlet.java:578) at sx.cms.CmsServlet.runGet(CmsServlet.java:542) at sx.cms.CmsServlet.service(CmsServlet.java:468) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.apache.catalina.filters.HttpHeaderSecurityFilter.doFilter(HttpHeaderSecurityFilter.java:126) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at sx.sec.CertAccessFilter.doFilter(CertAccessFilter.java:112) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at sx.sec.SystemAccessFilter.doFilter(SystemAccessFilter.java:397) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:94) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:604) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:502) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1152) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:684) at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2527) at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2516) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) Caused by: java.sql.SQLException: Invalid state, the Connection object is closed. at net.sourceforge.jtds.jdbc.ConnectionJDBC2.checkOpen(ConnectionJDBC2.java:1707) at net.sourceforge.jtds.jdbc.ConnectionJDBC2.prepareStatement(ConnectionJDBC2.java:2409) at sun.reflect.GeneratedMethodAccessor51.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:126) at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109) at org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:80) at com.sun.proxy.$Proxy4.prepareStatement(Unknown Source) at sx.datastore.jdbc.SXConnectionWrapper.prepareStatement(SXConnectionWrapper.java:292) at sx.datastore.db.SXDb.executeQuery(SXDb.java:709) ... 43 more |