Skip to main content
F
fgwenger
Known Participant
December 17, 2009
Question

Not maintaining connection

  • December 17, 2009
  • 1 reply
  • 1157 views

ColdFusion v8.01 on Windows 2003

Our database is Oracle 10.1.  We connect using a "thin" connection (oracle.jdbc.OracleDriver)

We have "Maintain Connections" selected in the driver, but it looks like the connections are always regenerated and not maintained.  It's starting to cause us to have occasional "IO exception: The Network Adapter could not establish the connection" errors.  Occasional but still disruptive.

The last time we paid close attention to our connections in Oracle (maybe 15 months ago), they stayed alive for a long time (e.g. all day), at least during the day since our site is pretty busy.  Now when we look at the connections, they are created within minutes or seconds of now, they are not being maintained.

Any ideas on why they wouldn't maintain and how we get them back to actually maintaining those connections?

Thanks a lot.

This topic has been closed for replies.

1 reply

A
Adam Cameron.
Inspiring
January 12, 2010

Can you do a similar experiment with a different DSN using the DataDirect drivers that come with CF?  Just to see if the connections still drop in a similar way.  The results could help pin down if the issue is with CF, JDBC, the driver or the DB server.

--
Adam

F
fgwengerAuthor
Known Participant
January 16, 2010

The connections for the standard drivers work as expected (hold the connection open). We've found the JDBC Thin drivers to perform a lot better and have used them for 5-6 years with no problems.

Adobe has someone looking into to it, too.  No answers yet.  I'll post back here when we get a solution.

F
fhh98
Inspiring
February 16, 2010

Any thoughts about this issue? I've also been running into it mostly during peak usage times.

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