MSSQL2K >Which DB? > > > > >"This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, >Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, >Registered in England, Number 678540. It contains information which is >confidential and may also be privileged. It is for the exclusive use of the >intended recipient(s). If you are not the intended recipient(s) please note >that any form of distribution, copying or use of this communication or the >information in it is strictly prohibited and may be unlawful. If you have >received this communication in error please return it to the sender or call >our switchboard on +44 (0) 20 89107910. The opinions expressed within this >communication are not necessarily those expressed by Reed Exhibitions." >Visit our website at http://www.reedexpo.com > >-----Original Message----- >From: Jim H >To: CF-Talk >Sent: Mon May 14 19:02:21 2007 >Subject: Error Executing Database Query. > >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(ClientScopePersistence >Filter.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:11 >5) > 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:26 >4) > 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(ClientScopePersistence >Filter.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:11 >5) > 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:26 >4) > at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278090 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
