Error Executing Database Query.
|
[Macromedia][SQLServer JDBC Driver]A problem occurred when attempting to contact the server (Server returned: Connection reset). Please ensure that the server parameters passed to the driver are correct and that the server is running. Also ensure that the maximum number of connections have not been exceeded for this server.
|
|
The error occurred in C:/websites/Skicountry/functions/cms.cfc: line 215
Called from C:/websites/Skicountry/category.cfm: line 15
Called from |SQLServer|6.0.0.1282|: line 1048
Called from |SQLServer|6.0.0.1282|: line 980
Called from |SQLServer|6.0.0.1282|: line 1132
Called from |SQLServer|6.0.0.1282|: line 840
Called from |SQLServer|6.0.0.1282|: line 727
Called from |SQLServer|6.0.0.1282|: line 1772
Called from |SQLServer|6.0.0.1282|: line 155
Called from |SQLServer|6.0.0.1282|: line 4600
Called from |SQLServer|6.0.0.1282|: line 1376
Called from |SQLServer|6.0.0.1282|: line 2505
Called from |SQLServer|6.0.0.1282|: line 1358
Called from |SQLServer|6.0.0.1282|: line 4478
Called from |SQLServer|6.0.0.1282|: line 1048
Called from |SQLServer|6.0.0.1282|: line 980
Called from |SQLServer|6.0.0.1282|: line 1132
Called from |SQLServer|6.0.0.1282|: line 840
Called from |SQLServer|6.0.0.1282|: line 727
Called from |SQLServer|6.0.0.1282|: line 1772
Called from |SQLServer|6.0.0.1282|: line 155
Called from |SQLServer|6.0.0.1282|: line 4600
Called from |SQLServer|6.0.0.1282|: line 1376
Called from |SQLServer|6.0.0.1282|: line 2505
Called from |SQLServer|6.0.0.1282|: line 1358
Called from |SQLServer|6.0.0.1282|: line 4478
Called from C:/websites/Skicountry/functions/cms.cfc: line 215
Called from C:/websites/Skicountry/category.cfm: line 15
|
213 : SELECT contentID, active, Body, METAKEYWORDS, METADESC, parentID, path, HTMLTITLE, releaseDate, FileName, Title, menuTitle, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, Type, KEYPOINTS
214 : FROM tcontent
215 : WHERE <Cfif isDefined("arguments.thisParent") and len(arguments.thisParent)>(parentID = '#arguments.thisParent#') and </cfif>(urltitle = '#arguments.thisTitle#') AND (active = 1) AND ( (display = 1) or (display=2 and displaystart<='#DateFormat(now(),"YYYY-MM-DD")# #TimeFormat(now(),"HH:MM:SS")#.0' and displaystop>='#DateFormat(now(),"YYYY-MM-DD")# #TimeFormat(now(),"HH:MM:SS")#.0')
216 : )
217 : </cfquery>
|
|
SQLSTATE |
08S01 |
EXCEPTIONS |
<small><i>not set</i></small> |
DATASOURCE |
muraDB |
SQL |
SELECT contentID, active, Body, METAKEYWORDS, METADESC, parentID, path, HTMLTITLE, releaseDate, FileName, Title, menuTitle, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, Type, KEYPOINTS
FROM tcontent
WHERE (urltitle = 'komperdell') AND (active = 1) AND ( (display = 1) or (display=2 and displaystart<='2024-11-25 03:00:33.0' and displaystop>='2024-11-25 03:00:33.0')
) |
|
Resources:
|
Browser |
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
Remote Address |
18.117.103.185 |
Referrer |
https://skicountrysports.com/kids-ski-poles/browse/price/50-to-100/brand/komperdell/orderby/s |
Date/Time |
25-Nov-24 03:00 AM |
|
Stack Trace
|
at cfcms2ecfc1924588780$funcGETCOMPONENTBYTITLE.runFunction(C:/websites/Skicountry/functions/cms.cfc:215) at cfcategory2ecfm1749867363.runPage(C:/websites/Skicountry/category.cfm:15) at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1048) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1132) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:840) at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:727) at macromedia.jdbc.sqlserver.base.BaseConnection.a(|SQLServer|6.0.0.1282|:1772) at macromedia.jdbc.sqlserver.tds.g.b(|SQLServer|6.0.0.1282|:155) at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4600) at macromedia.jdbc.sqlserver.SQLServerImplStatement.cb(|SQLServer|6.0.0.1282|:1376) at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2505) at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478)
at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1048) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1132) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:840) at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:727) at macromedia.jdbc.sqlserver.base.BaseConnection.a(|SQLServer|6.0.0.1282|:1772) at macromedia.jdbc.sqlserver.tds.g.b(|SQLServer|6.0.0.1282|:155) at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4600) at macromedia.jdbc.sqlserver.SQLServerImplStatement.cb(|SQLServer|6.0.0.1282|:1376) at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2505) at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478) at cfcms2ecfc1924588780$funcGETCOMPONENTBYTITLE.runFunction(C:/websites/Skicountry/functions/cms.cfc:215) at cfcategory2ecfm1749867363.runPage(C:/websites/Skicountry/category.cfm:15)
java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]A problem occurred when attempting to contact the server (Server returned: Connection reset). Please ensure that the server parameters passed to the driver are correct and that the server is running. Also ensure that the maximum number of connections have not been exceeded for this server.
at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1048)
at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980)
at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1132)
at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:840)
at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:727)
at macromedia.jdbc.sqlserver.base.BaseConnection.a(|SQLServer|6.0.0.1282|:1772)
at macromedia.jdbc.sqlserver.tds.g.b(|SQLServer|6.0.0.1282|:155)
at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4600)
at macromedia.jdbc.sqlserver.SQLServerImplStatement.cb(|SQLServer|6.0.0.1282|:1376)
at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2505)
at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358)
at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478)
at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
at coldfusion.sql.Executive.executeQuery(Executive.java:1613)
at coldfusion.sql.Executive.executeQuery(Executive.java:1355)
at coldfusion.sql.Executive.executeQuery(Executive.java:1285)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247)
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:876)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821)
at cfcms2ecfc1924588780$funcGETCOMPONENTBYTITLE.runFunction(C:\websites\Skicountry\functions\cms.cfc:215)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:553)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:310)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4264)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4227)
at cfcategory2ecfm1749867363.runPage(C:\websites\Skicountry\category.cfm:15)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:613)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:162)
at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
at coldfusion.CfmServlet.service(CfmServlet.java:231)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:355)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:450)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:928)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1794)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:834)
|
|