Re: Weird exception thrown

Have you considered using 

If YourOracleDatreader.Read Then
Else
End If

Instead?

The .Read() returns a boolean.

Are you using the oracle supplied data classes or the Microsoft ones?

I believe one of them is known to be "buggy", I just forget which one.


-----Original Message-----
From: Discussion of advanced .NET topics.
[mailto:[email protected]] On Behalf Of Eddie Lascu
Sent: Friday, January 09, 2009 11:49 AM
To: [email protected]
Subject: [ADVANCED-DOTNET] Weird exception thrown

Hello,
 
I have an application that reads an XML file, parses it and saves its data
into an Oracle database. The save is actually an insert, if the record
doesn't exist or an update if the record exists. In order to figure out
which operation I have to perform, I execute a select, to check whether the
record is already in the database. I build the Select SQL statement, create
an Oracle Command object with it and then call its Execute Reader method.
This method returns an OracleDataReader object and for that, all I care to
check is to see whether it has any records. The OracleDataReader class has a
property called "HasRows" that will tell me just that.
I know what you are thinking: I should ask this question on a different
forum, like one Oracle hosts for their ODP.NET development, but bare with me
for a second.
After running for 2-3 days continuously, my application starts throwing this
weird exception where it says that "Memory could not be allocated". I
managed to trace the raise of the exception to the invocation of the
"HasRows" property for the OracleDataReader object. The problem is that,
looking at the documentation, that property is not raising any exceptions,
so what the heck is going on.
To keep things under control, I even tried to kick in the garbage collection
(GC.Collect()) myself, every now and then. Now the exception takes longer to
be triggered, but eventually it is triggered.
Can anyone give me some ideas as to what else to try and figure out what the
problem is? The XML files are not really big, averaging around 100 kB each.
When the exception is triggered, I look ion the task manager and Physical
Memory usage is nowhere near the top.
Any suggestion will be highly appreciated.
 
TIA,
Eddie

===================================
View archives and manage your subscription(s) at
http://peach.ease.lsoft.com/archives

===================================
View archives and manage your subscription(s) at http://peach.ease.lsoft.com/archives