ExamGuru IT/.Net Guru : System.Data.OracleClient.OracleConnection - Internal Pooler Error on microsoft.public.dotnet.framework.adonet

.NETGURU

System.Data.OracleClient.OracleConnection - Internal Pooler Error

Messages

Related Types

This message was discovered on microsoft.public.dotnet.framework.adonet.

John Lynn

I notice that every now and then the Close method of
System.Data.OracleClient.OracleConnection causes:

An unhandled exception of type 'System.Exception' occurred in
system.data.oracleclient.dll
Additional information: Internal Pooler Error: 2

I searched and couldn't find any hits on this. What's a good way to start
figuring out what's going on? Thanks...

Assembly System.Data.OracleClient, Version 1.0.5000.0

Reply to this message...

Miha Markic [MVP C#]

It could be an Oracle client error.
What version do you have?

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

"John Lynn" <Click here to reveal e-mail address> wrote in message
news:Click here to reveal e-mail address...
[Original message clipped]

Reply to this message...

John Lynn

The best I can determine (how do you tell?) is that the Oracle client is
8.0.6...

"Miha Markic [MVP C#]" wrote:

[Original message clipped]

Reply to this message...

John Lynn

Oops - I was wrong: it's 8.1.7

"Miha Markic [MVP C#]" wrote:

[Original message clipped]

Reply to this message...

John Lynn

I opened System.Data.OracleClient.dll in notepad, and there is the error
message:
"Internal Pooler Error: {0}", so it looks like it's a .NET Framework error
message. Now if I just knew what it meant :-(

Isn't there a list somewhere of all error messages and what they mean?

"John Lynn" wrote:

[Original message clipped]

Reply to this message...

Miha Markic [MVP C#]

Hi John,

"John Lynn" <Click here to reveal e-mail address> wrote in message
news:Click here to reveal e-mail address...
[Original message clipped]

It might still be an Oracle's error. Anyway, if you can, try updating Oracle
client to a newer version, like 9ir2 or something.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

[Original message clipped]

Reply to this message...

John Lynn

Thanks, Miha.. I think I fixed the problem, though -- we had a data layer
class that was calling Close on the connection, in the destructor (this is
c#) of the class. Now according to the doc for OracleConnection.Close Method:

"CAUTION Do not call Close or Dispose on a Connection, a DataReader, or
any other managed object in the Finalize method of your class. In a
finalizer, you should only release unmanaged resources that your class owns
directly."

This used to work until we upgraded to .Net Framework 1.1 from 1.0. Maybe a
hole got closed or something?

"Miha Markic [MVP C#]" wrote:

[Original message clipped]

Reply to this message...

Miha Markic [MVP C#]

Hi John,

"John Lynn" <Click here to reveal e-mail address> wrote in message
news:Click here to reveal e-mail address...
[Original message clipped]

The documentation is correct. Don't do anything in finalizer or better,
don't even implement one if you don't use *unmanaged* resources as the
document clearly states - and this is valid for *entire* .net thing.
If you do have to implement finalizer - take *extreme* care and be sure you
do know what are you doing.
Anyway, I am glad that you found the cause of the problem.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

Reply to this message...

	System.Data.OracleClient.OracleConnection
	System.Exception

ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification

Need Dot Net Interview Questions?
Ask ExamGuru, Inc. for advice and help on Passing .Net Interviews

.Net Projects
Best-of-breed application framework for .NET projects, developed by ExamGuru, Inc. and ExamGuru IT

Free .net Help
Commission ExamGuru, Inc. and his team for your next bespoke software project

FogBUGZ
The only bug tracking system carefully crafted with one goal in mind: helping teams create great software.

Awesome Tools
If you don't know about these, you're missing out... IT Certification Questions
IT Interview Questions
Free Oracle 10g Training
MCSE Boortcamp
Cisco Study Guides
Cheap Study Guides
Exact Questions
Dot Net Interview Questions
Oracle OCP
Cheap Travel
Designer Perfumes - Wholesale Prices
Free Programming Tutorials

	Copyright © ExamGuru, Inc. 2001-2006
	Contact Us - Terms of Use - Privacy Policy - www.dot-net-guru.com - www.examguru.net - www.oraclesource.net - www.itinterviews.net - www.examguru.net/ITCertification