Timed out trying to establish connection

Question

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 connectionThe  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

AdamPresley · Answer

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?

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.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded