Has anyone ever dealt with this?  I lose a steady ping to the database from the 
web server, but a ping to the gateway does not fail.  Any thoughts?

line 4 of route.cfm is:

3       <cfquery datasource="#datasource#" name="getCompanyURLs" timeout="15">
4       SELECT CompanyURL, CID FROM WebCompanies WHERE 
CompanyURL='#cgi.HTTP_HOST#'
5       </cfquery>

"Error","jrpp-12","05/10/07","15:26:43","SchoolSites","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 specific sequence of files included or processed 
is: C:\Inetpub\WebSites\route.cfm, line: 4 "
coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database 
Query.
        at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:580)
        at cfroute2ecfm1337773736.runPage(C:\Inetpub\WebSites\route.cfm:4)
        at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
        at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349)
        at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
        at 
coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:225)
        at 
coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:51)
        at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
        at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69)
        at 
coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
        at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
        at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
        at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
        at 
coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:115)
        at coldfusion.CfmServlet.service(CfmServlet.java:107)
        at 
coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78)
        at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
        at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
        at 
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257)
        at 
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541)
        at 
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204)
        at 
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:318)
        at 
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426)
        at 
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:264)
        at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
"Error","jrpp-12","05/10/07","15:27:18","SchoolSites","Error Executing Database 
Query.[Macromedia][SQLServer JDBC Driver]Connection reset by peer: socket write 
error The specific sequence of files included or processed is: 
C:\Inetpub\WebSites\route.cfm, line: 4 "
coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database 
Query.
        at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:580)
        at cfroute2ecfm1337773736.runPage(C:\Inetpub\WebSites\route.cfm:4)
        at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
        at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349)
        at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
        at 
coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:225)
        at 
coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:51)
        at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
        at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69)
        at 
coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
        at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
        at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
        at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
        at 
coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:115)
        at coldfusion.CfmServlet.service(CfmServlet.java:107)
        at 
coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78)
        at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
        at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
        at 
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257)
        at 
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541)
        at 
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204)
        at 
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:318)
        at 
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426)
        at 
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:264)
        at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create Web Applications With ColdFusion MX7 & Flex 2. 
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS 

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278084
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Reply via email to