tags:

views:

704

answers:

1
+1  Q: 

asp.net connection pooling: automatically testing & validating connections?

I know with some connection pools, you can specify a test query the pool manager can use to validate a connection.

Is there anything similar to that for asp.net? I'm having a problem where there's a firewall between the web app and the database, and it's closing idle connections - the result is that the user gets an "ORA-03135: connection lost contact" error. Reloading the page is fine, but I'd like to remove that error completely.

A: 

If the latest Oracle driver hasn't fixed the problem, the ugly solution is to build a Windows Service that pings the database every X seconds. I'm not sure what X would be, I'm guessing every 30 seconds.

Josh  2009-06-04 19:05:40
That wouldn't help, I'm afraid. There's a pool of database connections, and as far as the .net pool manager knows they're all fine. Except along comes the firewall, and says to a connection "You're not working, I'll just kill you off". So meanwhile the pool manager hands off the connection to the next page that asks for it, except that connection is dead.Pinging the db wouldn't help, because Mr. Firewall is still gonna kill that idle connection.I've seen other pool implementations that periodically test the connections, or have a param to recycle them - that's what I'd like.
chris  2009-06-04 21:12:22

related questions

Is it better to create Model classes, or just stick with generic database utility class?
What are effective options for embedding video in an ASP.NET web site?
Visual Studio 2008 debugger already attached work-around
Tracking state using ASP.NET AJAX / ICallbackEventHandler
ASP.NET Display SVN Revision Number
ASP.NET URL Rewriting
How can I change the background of a masterpage from the code behind of a content page?
Easy way to AJAX WebControls
How do I define custom web.config sections with potential child elements and attributes for the properties?
ASP.NET MVC "CRUD" Database Sample
Are Multiple DataContext classes ever appropriate?
How to RedirectToAction in ASP.NET MVC without losing request data
Triple Quotes? How do I delimit a databound Javascript string parameter in ASP.NET?
ASP.NET built in user profile, Vs old stile user class/tables
What's a good book for learning ASP?
Bandwith throttling in IIS 6 by IP Address
ASP .Net Custom Client-Side Validation
How to get the value of built, encoded ViewState?
Decent, simple, GIS/mapping component for ASP.NET?
Checklist for IIS 6/ASP.NET Windows Authentication?
How to write to Web.Config in Medium Trust ?
ASP.NET, Visual Studio and Subversion - how to integrate?
Floating Point Number parsing: Is there a Catch All algorithm?
How do I sync the SVN revision number with my ASP.NET web site?
ASP.NET Site Maps