“Object does not exist." on multiple connections using direct mode.

[wongchichong]

Hi,

I'm facing problem using the following code:


using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Xml.Serialization;

namespace ConsoleApplication1
{
class Program
{
static void Main(string[] args)
{
var a = TestDb("User Id=A;Connection Timeout=300;Password=A;Data Source=databs;sid=mcmccims;Unicode=false;Pooling=false;direct=true;");
var b = TestDb("User Id=B;Connection Timeout=300;Password=B;Data Source=databs;sid=mcmccims;Unicode=false;Pooling=false;direct=true;");
var c = TestDb("User Id=A;Connection Timeout=300;Password=A;Data Source=databs;sid=mcmccims;Unicode=false;Pooling=false;direct=true;");
var d = TestDb("User Id=B;Connection Timeout=300;Password=B;Data Source=databs;sid=mcmccims;Unicode=false;Pooling=false;direct=true;");

Console.ReadLine();
}

private static System.Data.IDbConnection TestDb(string conString)
{
var con = new Devart.Data.Oracle.OracleConnection(conString);
con.Open();

var cmd = con.CreateCommand();
cmd.CommandText = "select * from mcmc.t_negeri";

var ir = cmd.ExecuteReader();
while (ir.Read())
//Console.WriteLine(ir.GetOracleObject(3).ObjectType.Attributes[0].Name);
Console.WriteLine(ir.GetOracleObject(3)["SDO_GTYPE"]);

return con;
}
}
}



The code will runs until:
var c = TestDb(...
then "Object does not exist." exception thrown on:
var ir = cmd.ExecuteReader();


I'm using the following environment:
Windows 8
64 bit
Oracle Spatial with User Defined Type (SDO_GEOMETRY)

Thanks.

[Pinturiccio]

We have reproduced the issue. We will investigate it and notify you about the results as soon as possible.
As a temporary workaround you can use the OCI mode.

[Pinturiccio]

We have fixed the bug with using an Oracle object from several connections to the same database in the Direct mode.
The new build of dotConnect for Oracle 7.4.146 is available for download now!
It can be downloaded at http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?t=25516