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)
