Skip to main content
I
ifsteve
Inspiring
January 14, 2010
Question

Timed out trying to establish connection - Java only

  • January 14, 2010
  • 1 reply
  • 688 views

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

    This topic has been closed for replies.

    1 reply

    AdamPresley
    AdamPresley
    Participating Frequently
    January 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?

    I
    ifsteveAuthor
    Inspiring
    January 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

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices