OracleConnectio n

[Peter K]

Hi - is it the case that OracleConnectio n does not call close when the
connection is disposed?

For example, I use this sort of construct:

using (OracleConnecti on conn = GetConnection() )
{
using (OracleTransact ion tx = conn.BeginTrans action())
{
using (OracleCommand command = conn.CreateComm and())
etc.

But now a colleague tells me that the connection is not closed when the
using clause ends. Can this be true? Is that not a serious bug in
OracleConnectio n?

Or could it be affected by the "GetConnect ion" method which is a call to a
third-party class which actually gives us a connection - I mean, could
GetConnection somehow affect the subsequent "dispose" behaviour of the
connection?

Thanks,
Peter

[Nicholas Paldino [.NET/C# MVP]]

Peter,

What makes you think that it is not being closed? If you are using
connection pooling, then you might see the connection open still (not to
your code through the OracleConnectio n class, but through a performance
counter, for example). Other than that, the code you wrote will call the
Dispose method on the connection, which will close the connection.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"Peter K" <xd****@hotmail .comwrote in message
news:eQ******** ******@TK2MSFTN GP03.phx.gbl...

Hi - is it the case that OracleConnectio n does not call close when the
connection is disposed?

For example, I use this sort of construct:

using (OracleConnecti on conn = GetConnection() )
{
using (OracleTransact ion tx = conn.BeginTrans action())
{
using (OracleCommand command = conn.CreateComm and())
etc.

But now a colleague tells me that the connection is not closed when the
using clause ends. Can this be true? Is that not a serious bug in
OracleConnectio n?

Or could it be affected by the "GetConnect ion" method which is a call to a
third-party class which actually gives us a connection - I mean, could
GetConnection somehow affect the subsequent "dispose" behaviour of the
connection?

Thanks,
Peter

[Peter K]

"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard .caspershouse.c omwrote
in news:OC******** ******@TK2MSFTN GP03.phx.gbl:

Peter,

What makes you think that it is not being closed? If you are
using
connection pooling, then you might see the connection open still (not
to your code through the OracleConnectio n class, but through a
performance counter, for example). Other than that, the code you
wrote will call the Dispose method on the connection, which will close
the connection.

Hi thanks, these were also my thoughts. I have no evidence that
OracleConnectio n does not behave as expected - a colleague has just told me
I need to explictly close my connections because OracleConnectio n does not
function correctly on a dispose (ie at the end of a using clause).

I have not yet heard back from him about how he has ascertained this.

[Frans Bouma [C# MVP]]

Peter K wrote:

Hi - is it the case that OracleConnectio n does not call close when
the connection is disposed?

For example, I use this sort of construct:

using (OracleConnecti on conn = GetConnection() )
{
using (OracleTransact ion tx = conn.BeginTrans action())
{
using (OracleCommand command = conn.CreateComm and())
etc.

But now a colleague tells me that the connection is not closed when
the using clause ends. Can this be true? Is that not a serious bug in
OracleConnectio n?

Or could it be affected by the "GetConnect ion" method which is a call
to a third-party class which actually gives us a connection - I mean,
could GetConnection somehow affect the subsequent "dispose" behaviour
of the connection?

ODP.NET or MS Oracle client?

ODP.NET has a lot of tiny little quircks, like calling Dispose on
every element or else you'll have memory leaks etc. Though I don't
think any ADO.NET provider leaves a connection open when dispose is
called, simply because the connection has to be cleaned up to make
dispose do its job :)

Closing a connection will make it go to the pool, which means the
connection physically stays open for some time. Perhaps your collegue
meant that, although with close you can't change that behavior. (nor
should you want to)

FB

--
------------------------------------------------------------------------
Lead developer of LLBLGen Pro, the productive O/R mapper for .NET
LLBLGen Pro website: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------

[Peter K]

"Frans Bouma [C# MVP]" <pe************ ******@xs4all.n lwrote in
news:xn******** *******@news.mi crosoft.com:

ODP.NET or MS Oracle client?

ODP.NET has a lot of tiny little quircks, like calling Dispose on
every element or else you'll have memory leaks etc. Though I don't
think any ADO.NET provider leaves a connection open when dispose is
called, simply because the connection has to be cleaned up to make
dispose do its job :)

Closing a connection will make it go to the pool, which means the
connection physically stays open for some time. Perhaps your collegue
meant that, although with close you can't change that behavior. (nor
should you want to)

Hi there

We are using Oracle.DataAcce ss.Client.Oracl eConnection.

I wasn't really aware of the different connection objects one could use. Do
you have references to the different types?

Thanks,
Peter

[Frans Bouma [C# MVP]]

Peter K wrote:

"Frans Bouma [C# MVP]" <pe************ ******@xs4all.n lwrote in
news:xn******** *******@news.mi crosoft.com:

ODP.NET or MS Oracle client?

ODP.NET has a lot of tiny little quircks, like calling Dispose
on every element or else you'll have memory leaks etc. Though I
don't think any ADO.NET provider leaves a connection open when
dispose is called, simply because the connection has to be cleaned
up to make dispose do its job :)

Closing a connection will make it go to the pool, which means
the connection physically stays open for some time. Perhaps your
collegue meant that, although with close you can't change that
behavior. (nor should you want to)

Hi there

We are using Oracle.DataAcce ss.Client.Oracl eConnection.

I wasn't really aware of the different connection objects one could
use. Do you have references to the different types?

You're using ODP.NET, which is preferable over Microsoft's own Oracle
ADO.NET client in .NET. ODP.NET is released by Oracle, and has more
features. The only downside is that it's still a wrapper around its own
Java based CLI, so you do have to call Dispose() on OracleParameter
objects for example otherwise you'll get memory leaks

FB

--
------------------------------------------------------------------------
Lead developer of LLBLGen Pro, the productive O/R mapper for .NET
LLBLGen Pro website: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------

[=?ISO-8859-1?Q?Arne_Vajh=F8j?=]

Frans Bouma [C# MVP] wrote:

You're using ODP.NET, which is preferable over Microsoft's own Oracle
ADO.NET client in .NET. ODP.NET is released by Oracle, and has more
features. The only downside is that it's still a wrapper around its own
Java based CLI, so you do have to call Dispose() on OracleParameter
objects for example otherwise you'll get memory leaks

Java based CLI ??

Do you mean native OCI ?

Arne