Timed out trying to establish connection - Java only

Report · Jan 14, 2010

I am running CF8.0.1 with sql 2000 on windows 2003. I've been intermittenly experiencing the error below. I've gone and researched as much as I can and none of the answers apply to me. It seems that when Java objects try to reach me sql database I get the timed out message. This happens once a few days and hangs the server until I restart coldfusion.

If I try to reach the same table with a cfquery tag and output the results, I have no problem. Only java classes seem to be affected by this issue. Restarting the coldfusion service fixes it, but its not reasonable to restart it every other day.

Error Occurred While Processing Request

Timed out trying to establish connection


The error occurred in ****** Called from Called from ***
19 : storeGroupID = -1; 20 : storeID = intSID; 21 : acContext.initialize(javacast("long",storeGroupID), javacast("long",storeID)); 22 : 23 : // create an authenticator for user authentication.

I am runni

Report · Jan 15, 2010

When you say "only java classes" have this issue, what Java classes are you using that are directly connecting to your SQL Server instance? It's hard to say what could be the issue just based on the fact that the possible interactions are limitless. For example, I've used components that implement a connection pool, and required the call of a cleanup method to release resources, and we ran into all kinds of problems when we didn't release those resources. What are these components, and what are they used for?

Report · Jan 15, 2010

Well, the application in question is running ablecommerce. I have 3 sites hosted on this server that I manage. Ablecommerce no longer supports Coldfusion. All of their queries to the DB are written through java classes and not your regular cfquery tags.

When I get that timed out error on my ablecommerce sites, and then run a cfquery on the same server against the same DB, it works fine, which pushes me to think its java related.

Steve