Is SDO_GEOMETRY/OracleObject thread safe?

Is SDO_GEOMETRY/OracleObject thread safe?

Postby vmakkenz » Thu 01 Aug 2013 10:51

Hi,

I'm experimenting with turning some loops the parallel loops and now I run into all kinds of exceptions when I try to access SDO_GEOMETRY objects.

The failing statement is this:
var oracleObject = reader.GetValue(columnName) as OracleObject

And the exceptions are at random on of these:

System.InvalidOperationException was unhandled by user code
HResult=-2146233079
Message=Collection was modified; enumeration operation may not execute.
Source=mscorlib
StackTrace:
at System.Collections.ArrayList.ArrayListEnumeratorSimple.MoveNext()
at Devart.Data.Oracle.cm.a()
at Devart.Data.Oracle.bt.b(Byte[] A_0, Int32 A_1, Boolean A_2)
at Devart.Data.Oracle.bt.a(Byte[] A_0, Int32 A_1, Boolean A_2, b7 A_3)
at Devart.Data.Oracle.t.f(Byte[] A_0, Int32 A_1, Boolean A_2)
at Devart.Data.Oracle.OracleDataReader.GetValue(Int32 i)

System.ArgumentNullException was unhandled by user code
HResult=-2147467261
Message=Value cannot be null.
Parameter name: oracleType
Source=Devart.Data.Oracle
ParamName=oracleType
StackTrace:
at Devart.Data.Oracle.o.b(OracleType A_0)
at Devart.Data.Oracle.cm.a(OracleAttribute A_0)
at Devart.Data.Oracle.cm.a()
at Devart.Data.Oracle.bt.b(Byte[] A_0, Int32 A_1, Boolean A_2)
at Devart.Data.Oracle.bt.a(Byte[] A_0, Int32 A_1, Boolean A_2, b7 A_3)
at Devart.Data.Oracle.t.f(Byte[] A_0, Int32 A_1, Boolean A_2)
at Devart.Data.Oracle.OracleDataReader.GetValue(Int32 i)


Or sometimes this one if getting the oracle object succeeded:

var gtype = (decimal)obj["SDO_GTYPE"];

System.InvalidOperationException was unhandled by user code
HResult=-2146233079
Message=Operation is not valid due to the current state of the object.
Source=Devart.Data.Oracle
StackTrace:
at Devart.Data.Oracle.OracleAttributeCollection.get_Item(String name)
at Devart.Data.Oracle.OracleObject.get_Item(String Name)

I'm using direct mode and version 7.8.287

Any hints/tips are welcome.

Valentijn Makkenze
Vicrea Solutions B.V.
vmakkenz
 
Posts: 18
Joined: Tue 26 Aug 2008 13:30

Re: Is SDO_GEOMETRY/OracleObject thread safe?

Postby alexa » Thu 01 Aug 2013 11:37

In case you are seeing an error report, please click the 'Send Error Report' button. This will send the full description of the error to our support system for investigation.
alexa
Devart Team
 
Posts: 2175
Joined: Fri 24 Jun 2011 14:17


Return to dbForge for Oracle