Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ODP .Net Connection Pool Problem on Web Application
Sorry, I meant to also add that you need to make sure all your
connections are opened/used/closed similar to this pattern so that
you'll always close connections even if there are unexpected
exceptions:
OracleConnection oc = null;
try
{
oc = new OracleConnection(_myConnStr);
oc.Open();
...
}
catch
{
...log and/or reraise
}
finally
{
if(oc != null)
{
oc.Close();
}
}
Received on Mon Feb 13 2006 - 16:33:32 CST