“Object does not exist." on multiple connections using direct mode.
Posted: 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.
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.