ONJava.com -- The Independent Source for Enterprise Java
oreilly.comSafari Books Online.Conferences.

advertisement

AddThis Social Bookmark Button
Article:
  ADO.NET Connection Pooling Explained
Subject:   Oracle - how to validate connections
Date:   2004-02-24 15:16:40
From:   akeh
ODP.NET has recently introduced a new connection string attribute validate connection that should be set to true in order to validate connections coming out of the pool. By default, this property is set to false. This saves having to write any custom code to check for invalid connections coming out of hte pool. The attribute is available beginning with ODP.NET 9.2.0.4.


Note that validation causes a round trip to the database for each connection coming out of the pool, which is very expensive in terms of performance. Therefore, this attribute should be used only if absolutely necessary.


1 to 2 of 2
  1. Oracle - how to validate connections
    2006-03-16 10:07:08  solutionsahead [View]

  2. Oracle - how to validate connections
    2006-01-04 12:19:44  random_ [View]

    • Oracle - how to validate connections
      2006-08-03 08:23:57  martinjmac [View]

    • Oracle - how to validate connections
      2006-03-06 08:16:44  paulwise3 [View]

1 to 2 of 2