Results 1 to 1 of 1

Thread: Cold Fusion - Unexplained error....

Threaded View

  1. #1

    Thread Starter
    PowerPoster
    Join Date
    Feb 2002
    Location
    Canada, Toronto
    Posts
    5,803

    Cold Fusion - Unexplained error....

    I had to replace some text with * because it would reveal unwanted information to the public about the project...

    The thing is, we did not make any change on the programming, we have this web-site for many years, so I am convinced it's a problem with the server. Our network admin keeps saying "can you fix the code", but there is nothing to fix !

    Can anyone tell from this what could it be ?
    Code:
    Error Occurred While Processing Request
    Error Executing Database Query.
    Timed out trying to establish connection
     
    The error occurred in ***********\login.cfm: line 46
    
    44 : 					AND es.is_active = <cfqueryparam value="1" cfsqltype="CF_SQL_BIT">
    45 : 					**********************
    46 : 					AND ts.active = <cfqueryparam value="1" cfsqltype="CF_SQL_BIT">
    47 : 	</CFQUERY>
    48 : 	
    
    SQL 	   SELECT *************************************** WHERE username = (param 1) AND password = (param 2) AND es.is_active = (param 3) AND ts.active = (param 4)
    DATASOURCE 	  *********
    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.0; en-US; rv:1.9.0.3) Gecko/2008092417 Firefox/3.0.3
    Remote Address   	192.168.30.132
    Referrer   	https://**************/index.cfm?msg=1&CFID=33565&CFTOKEN=18197048
    Date/Time   	18-Dec-08 08:47 AM
    Stack Trace
    at cflogin2ecfm35615037.runPage(*************\login.cfm:46) at cflogin2ecfm35615037.runPage(***********\login.cfm:46)
    
    java.sql.SQLException: Timed out trying to establish connection
    	at coldfusion.server.j2ee.sql.pool.JDBCPool.requestConnection(JDBCPool.java:714)
    	at coldfusion.server.j2ee.sql.pool.JDBCManager.requestConnection(JDBCManager.java:125)
    	at coldfusion.server.j2ee.sql.JRunDataSource.getConnection(JRunDataSource.java:138)
    	at coldfusion.sql.DataSrcImpl.getCachedConnection(DataSrcImpl.java:124)
    	at coldfusion.sql.DataSrcImpl.getConnection(DataSrcImpl.java:75)
    	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:207)
    	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:447)
    	at cflogin2ecfm35615037.runPage(*********************\login.cfm:46)
    	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:147)
    	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:357)
    	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62)
    	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:107)
    	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
    	at coldfusion.filter.PathFilter.invoke(PathFilter.java:80)
    	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:47)
    	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
    	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:35)
    	at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:43)
    	at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
    	at coldfusion.CfmServlet.service(CfmServlet.java:105)
    	at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
    	at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
    	at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:252)
    	at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
    	at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:192)
    	at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:348)
    	at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451)
    	at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:294)
    	at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
    Last edited by CVMichael; Dec 18th, 2008 at 09:23 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width