Home » SQL & PL/SQL » Client Tools » Oracle connection pool issue in Devart (Devart.Data.Oracle - 7.1.40.0)
Oracle connection pool issue in Devart [message #662008] Wed, 12 April 2017 05:19 Go to next message
Raghupathi
Messages: 1
Registered: April 2017
Junior Member
Hi

I'm using the Devrat.Data.Oracle (7.1.40.0) libray in my application getting an error in connection pool

Below is the error message which is logged in the dump file


Call Stack


ntdll!ZwWaitForSingleObject+a
ntdll!RtlpWaitOnCriticalSection+e8
ntdll!RtlEnterCriticalSection+d1
oracore11!sltsmna+1c
OraClient11!kpuhhfrh+5cb
OraClient11!kpufhndl0+17c5
OraClient11!kpufhndl+e
OraClient11!OCIHandleFree+15
oci!OCIHandleFree+71
DomainBoundILStubClass.IL_STUB_PInvoke(System.Runtime.InteropServices.HandleRef, Int32)+67
OciDynamicType.OCIHandleFree(System.Runtime.InteropServices.HandleRef, Int32)+29
Devart.Data.Oracle.a7.c()
Devart.Data.Oracle.bg.j()
Devart.Data.Oracle.OracleInternalConnection..ctor(Devart.Data.Oracle.ah, Devart.Data.Oracle.OracleInternalConnection)
clr!ExceptionTracker::CallHandler+c5
clr!ExceptionTracker::CallCatchHandler+78
clr!ProcessCLRException+2e2
ntdll!RtlpExecuteHandlerForUnwind+d
ntdll!RtlUnwindEx+539
clr!ClrUnwindEx+40
clr!ProcessCLRException+2b2
ntdll!RtlpExecuteHandlerForException+d
ntdll!RtlDispatchException+45a
ntdll!RtlRaiseException+22f
KERNELBASE!RaiseException+39
clr!RaiseTheExceptionInternalOnly+28b
clr!IL_Throw+e3
Devart.Data.Oracle.bg.a(Devart.Data.Oracle.ah, Devart.Data.Oracle.ao)
Devart.Data.Oracle.OracleInternalConnection..ctor(Devart.Data.Oracle.ah, Devart.Data.Oracle.OracleInternalConnection)
Devart.Data.Oracle.df.a(Devart.Common.i, System.Object, Devart.Common.DbConnectionBase)
Devart.Common.DbConnectionFactory.a(Devart.Common.DbConnectionPool, Devart.Common.i, Devart.Common.DbConnectionBase)
Devart.Common.DbConnectionPool.a(Devart.Common.DbConnectionBase)
Devart.Common.DbConnectionPool.GetObject(Devart.Common.DbConnectionBase)
Devart.Common.DbConnectionFactory.b(Devart.Common.DbConnectionBase)
Devart.Common.DbConnectionClosed.Open(Devart.Common.DbConnectionBase)
Devart.Common.DbConnectionBase.Open()
Devart.Data.Oracle.OracleConnection.Open()
DataConnectors.Oracle.OracleDataConnector.GetCommand(System.String)
DataConnectors.Oracle.OracleDataConnector.GetAllSynonymObjects()
DataConnectors.Oracle.OracleDataConnector.BuildSqlRetrieveTablesInDatabase()
.DataConnectors.Oracle.OracleDataConnector.Relations(Execution.IExecutionContext,.LogEntry)
clr!CallDescrWorkerInternal+83
clr!CallDescrWorkerWithHandler+4a
clr!CallDescrWorkerReflectionWrapper+1a
clr!RuntimeMethodHandle::InvokeMethod+40f
mscorlib_ni+54d28c
mscorlib_ni+54e2b1
mscorlib_ni+53491e

Below is the sample code

private OracleConnection GetConnection()
{
var connection = new OracleConnection(ConnectionString);

return connection;
}

protected override DbCommand GetCommand(string value)
{
var connection = GetConnection();

connection.Open();

var command = new OracleCommand(value, connection) {CommandType = CommandType.Text};

return command;
}

private IEnumerable<OracleDataObject> GetAllSynonymObjects()
{
var dataObjects = new List<OracleDataObject>();
var connectionUserId = SqlHelper.GetConnectionStringItem(ConnectionString, USER_ID_REG_EX_PATTERN);
var command = GetCommand(string.Format(ALL_SYNONYMS_SQL, connectionUserId));

using (IDataReader dataReader = command.ExecuteReader(CommandBehavior.CloseConnection))
{
while (dataReader.Read())
{
var dataObject = new OracleDataObject
{
Name = SqlHelper.ConvertToString(dataReader["SYNONYM_NAME"]),
DbLink = SqlHelper.ConvertToString(dataReader["DB_LINK"]),
OriginalName = SqlHelper.ConvertToString(dataReader["TABLE_NAME"]),
Owner = SqlHelper.ConvertToString(dataReader["OWNER"]),
TableOwner = SqlHelper.ConvertToString(dataReader["TABLE_OWNER"])
};

dataObject.Description = SqlHelper.ConvertToString(dataReader["TABLE_OWNER"]) + "." +
dataObject.Name + " => " +
SqlHelper.ConvertToString(dataReader["TABLE_NAME"]);

dataObjects.Add(dataObject);
}
}

return dataObjects;
}

Re: Oracle connection pool issue in Devart [message #662012 is a reply to message #662008] Wed, 12 April 2017 05:48 Go to previous messageGo to next message
BlackSwan
Messages: 25716
Registered: January 2009
Location: SoCal
Senior Member
Sorry to see you are having problems.

GOOGLE knows nothing about Devrat.Data.Oracle & neither do I

When was last time it worked without error?
What changed since then?

There is no obvious Oracle related error is posting above.

Best wishes in solving your mystery.
Re: Oracle connection pool issue in Devart [message #662014 is a reply to message #662012] Wed, 12 April 2017 06:18 Go to previous message
BlackSwan
Messages: 25716
Registered: January 2009
Location: SoCal
Senior Member
You need to learn to spell correctly.
"DEVRAT" is different from "DEVART"

I suggest you post this issue to URL below

http://forums.devart.com/?_ga=1.27790393.448242114.1491995805
Previous Topic: UTTL_HTTP to POST CLOB request
Next Topic: SQL Developer
Goto Forum:
  


Current Time: Mon Nov 20 20:48:36 CST 2017

Total time taken to generate the page: 0.03781 seconds