Error Executing Database Query. Timed out trying to establish connection Sounds like your database or your network is hiccupping.
~Brad -----Original Message----- From: Russell Christiansen [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 08, 2006 9:40 AM To: CF-Talk Subject: ColdFusion Time Out Error....HELP!!!!! I'm getting these sporadic time-out errors on this web application that is supposed to be a very sophisticated assessment tool. It uses quite a few ColdFusion queries. It's not failing at exactly the same spot, it's been sporadic and I'm not sure what the cause is. I'm wondering if I might have too many queries or too much cfscript. Here's one of the errors in detail: Error Occurred While Processing Request Error Executing Database Query. Timed out trying to establish connection The error occurred in E:\Web Sites\Manners Matrix\www\MMS\P\S1\Q3\qF.cfm: line 17 Called from E:\Web Sites\Manners Matrix\www\MMS\P\S1\Q3\qF.cfm: line 1 Called from E:\Web Sites\Manners Matrix\www\MMS\P\S1\Q3\qF.cfm: line 17 Called from E:\Web Sites\Manners Matrix\www\MMS\P\S1\Q3\qF.cfm: line 1 15 : SELECT JHQTY3, EQTY3 16 : FROM ParQuestions 17 : WHERE District = '#District#' 18 : </cfquery> 19 : <cfquery name="MSD" datasource="#DSNOut#"> SQL SELECT JHQTY3, EQTY3 FROM ParQuestions WHERE District = '999' DATASOURCE ILOut1 Please try the following: * 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 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.7) Gecko/20060909 Firefox/1.5.0.7 Remote Address 67.167.112.135 Referrer http://www.mannersmatrix.com/mms/P/S1/Q3/qE.cfm?State=Illinois&District= 999&SchoolID=ILMN999J01&DSNOut=ILOut1&DSNIn=IL999In&RandPK=E3SD5GX6TJ&qY N=NNYYYYYYYY&QTY3L=+e+g+i+k&QTY3TPW=2&QTY3IOY=+b+&QTY3D=+m+o+q&QTY3BW=&Q TY3R= Date/Time 30-Oct-06 01:24 PM Stack Trace at cfqF2ecfm629700511._factor2(E:\Web Sites\Manners Matrix\www\MMS\P\S1\Q3\qF.cfm:17) at cfqF2ecfm629700511.runPage(E:\Web Sites\Manners Matrix\www\MMS\P\S1\Q3\qF.cfm:1) at cfqF2ecfm629700511._factor2(E:\Web Sites\Manners Matrix\www\MMS\P\S1\Q3\qF.cfm:17) at cfqF2ecfm629700511.runPage(E:\Web Sites\Manners Matrix\www\MMS\P\S1\Q3\qF.cfm:1) java.sql.SQLException: Timed out trying to establish connection at coldfusion.server.j2ee.sql.pool.JDBCPool.requestConnection(JDBCPool.java :750) at coldfusion.server.j2ee.sql.pool.JDBCManager.requestConnection(JDBCManage r.java:123) at coldfusion.server.j2ee.sql.JRunDataSource.getConnection(JRunDataSource.j ava:138) at coldfusion.server.j2ee.sql.JRunDataSource.getConnection(JRunDataSource.j ava:125) at coldfusion.sql.CFDataSource.getConnection(CFDataSource.java:37) at coldfusion.sql.DataSrcImpl.getCachedConnection(DataSrcImpl.java:149) at coldfusion.sql.DataSrcImpl.getConnection(DataSrcImpl.java:103) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:214) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:498) at cfqF2ecfm629700511._factor2(E:\Web Sites\Manners Matrix\www\MMS\P\S1\Q3\qF.cfm:17) at cfqF2ecfm629700511.runPage(E:\Web Sites\Manners Matrix\www\MMS\P\S1\Q3\qF.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:343) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:210) at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:50) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersist enceFilter.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.CfmServlet.service(CfmServlet.java:105) 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:527 ) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java: 204) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.j ava:349) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java :457) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.jav a:295) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259667 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
