Error!
Process cannot be completed.

Error Occurred While Processing Request The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.

The following information is meant for the website developer for debugging purposes.

Error Occurred While Processing Request

Error Executing Database Query.

[Macromedia][SQLServer JDBC Driver]Object has been closed.

The error occurred in C:/home/clearwaterpools.ca/secure_html/securityWatchURL.cfm: line 9
Called from C:/home/clearwaterpools.ca/secure_html/config/application_set.cfm: line 267
Called from C:/home/clearwaterpools.ca/secure_html/Application.cfm: line 1
Called from C:/home/clearwaterpools.ca/secure_html/securityWatchURL.cfm: line 9
Called from C:/home/clearwaterpools.ca/secure_html/config/application_set.cfm: line 267
Called from C:/home/clearwaterpools.ca/secure_html/Application.cfm: line 1

7 : <!--- Input Sanitation --->	
8 : <cfset chkURL = HTTP_HOST & SCRIPT_NAME & "?" & QUERY_STRING>
9 : <cfquery datasource="#dbdatasource#" username="#dbusername#" password="#dbpassword#" name="getsanitation">
10 : 	select id, sanitationString
11 : 	from SW_InputSanitation

SQLSTATE	HY000
EXCEPTIONS	<small><i>not set</i></small>
DATASOURCE	clearwater
SQL	select id, sanitationString from SW_InputSanitation where urlstring = 1 AND active = 1

Resources:

Check the ColdFusion documentation to verify that you are using the correct syntax.
Search the Knowledge Base to find a solution to your problem.

Browser	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote Address	3.144.71.142
Referrer
Date/Time	09-May-24 07:44 AM

Stack Trace

at cfsecurityWatchURL2ecfm2102944603.runPage(C:/home/clearwaterpools.ca/secure_html/securityWatchURL.cfm:9) at cfapplication_set2ecfm709187378.runPage(C:/home/clearwaterpools.ca/secure_html/config/application_set.cfm:267) at cfApplication2ecfm135772079.runPage(C:/home/clearwaterpools.ca/secure_html/Application.cfm:1) at cfsecurityWatchURL2ecfm2102944603.runPage(C:/home/clearwaterpools.ca/secure_html/securityWatchURL.cfm:9) at cfapplication_set2ecfm709187378.runPage(C:/home/clearwaterpools.ca/secure_html/config/application_set.cfm:267) at cfApplication2ecfm135772079.runPage(C:/home/clearwaterpools.ca/secure_html/Application.cfm:1)

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Object has been closed.
	at macromedia.jdbc.sqlserverbase.BaseExceptions.b(BaseExceptions.java:1106)
	at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:977)
	at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:1115)
	at macromedia.jdbc.sqlserverbase.BaseExceptions.aw(BaseExceptions.java:658)
	at macromedia.jdbc.sqlserverbase.BaseConnection.getMetaData(BaseConnection.java:2437)
	at coldfusion.server.j2ee.sql.JRunConnection.getMetaData(JRunConnection.java:508)
	at coldfusion.server.j2ee.sql.JRunConnectionHandle.getMetaData(JRunConnectionHandle.java:137)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1386)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1365)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1295)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:877)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:822)
	at cfsecurityWatchURL2ecfm2102944603.runPage(C:\home\clearwaterpools.ca\secure_html\securityWatchURL.cfm:9)
	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.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5088)
	at cfapplication_set2ecfm709187378.runPage(C:\home\clearwaterpools.ca\secure_html\config\application_set.cfm:267)
	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.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5088)
	at cfApplication2ecfm135772079.runPage(C:\home\clearwaterpools.ca\secure_html\Application.cfm:1)
	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.CfincludeFilter.include(CfincludeFilter.java:33)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:489)
	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.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:53)
	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:167)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:492)
	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:373)
	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:459)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:926)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	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:833)