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

Discussion of open issues, suggestions and bugs regarding Entity Developer - ORM modeling and code generation tool
Post Reply
wongchichong
Posts: 1
Joined: Fri 06 Jul 2012 05:58

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

Post by wongchichong » Fri 06 Jul 2012 08:29

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
Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

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

Post by Pinturiccio » Mon 09 Jul 2012 12:19

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
Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

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

Post by Pinturiccio » Fri 21 Dec 2012 13:18

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

Post Reply