Devart Forums

Can we dequeue the item from error queue multiple times using code below.

using (OracleQueue exceptionQueue = new OracleQueue(queue.ExceptionQueueName, conn))
{

OracleQueueDequeueOptions options = new OracleQueueDequeueOptions();
options.WaitTimeout = 0;
options.DequeueMode = OracleQueueDequeueMode.Browse;OracleQueueMessage msg = exceptionQueue.Dequeue(options);
}

Hi,

Is there anyway to dequeue (retrieve an item) from the exception queue, via code.

Thanks,
Ramana

The first code worked, but the attempts count is always returning back a zero. Also i am surprised that the API is on the Queue object and not on the item, as i expected each item in the queue to have a different attempt count. Please let me know what i am doing wrong. Below is the code i am using.

using (OracleQueue queue = new OracleQueue("ORDERRESULTS_QUEUE", oracleConnection))
{

int attempt = queue.EnqueueMessageProperties.Attempts;
}

Hi,

I am trying to extend devart's OracleProviderFactory and OracleConnection classes, as i need to provide my own implementation on how i handle closing of connections (due to the way we do multi threading in the application) by overriding the close method of the connection class. So can you please let me know how do i register my custom factory to the Dbfactories collection, as it looks like my factory class is not getting loaded with the providername = "customerassemblyname"in the connection string.

Thanks.
Ramana

Hi,

I am trying to fetch the MaxRetries property on the OracleQueueAdmin class, but it always returns back 0.0 (not sure why this is double data type in the first place). Below is the code. please let me know what i am doing wrong. Also, please let me know how do i get the retrycount on a item in the queue (via c# code), as i need to know how many tries i have before the item moves to exception queue.


using (OracleQueueAdmin adminQueue = new OracleQueueAdmin("ORDERRESULTS_QUEUE", oracleConnection))
{
double d = adminQueue.Options.MaxRetries;
}

Thanks,
Ramana

Hi,

We have been using EF with Devart dotconnect for oracle and are using version 6.30.196.0. We were having relationship span issues with EF wherein when we request an object to be loaded it loads the related objects also which have 0..1 relationship with the original object. And we realised that Devart's EDML entities dont do this and hence we decided to port our edmx to edml and start using edml. When i try to open an edmx model, in entity developer tool, i get an error in csdl,
"CSDL parsing failed, the attribute base type of tag entity type has an unexpected value partyrole"
where partyrole is an abstract class. This is a working model in EF, so why is edml having issues opening it. I can send you the edmx if you want..

Ramana

With the latest version of devart drivers and EF 4.2 CTP i am getting the following error..

System.Data.ProviderIncompatibleException: A null was returned after calling the 'GetService' method on a store provider instance of type 'Devart.Data.Oracle.OracleProviderFactory'. The store provider might not be functioning correctly.
at System.Data.Common.DbProviderServices.GetProviderServices(DbProviderFactory factory)

Please let me know if you have any clue wats happenning.

After 4 days of rocking my head against the wall, i found the issue was happenning only after a certain number of inserts into a table that had triggers attached to it which inturn write to some other table.

The issue is mainly due to devart transaction scope and the way it executes the sql statements i believe. Because once i chnage the connection string to "Direct = false", i dont have this error anymore.
So devart folks , please fix the issue and please send us a hotfix.

Bye,
Ramana @ Rosetta Inc.

I am having the same issue, please let me know the resolution for this.

Any luck with my issue..this is a show stopper for us...please let me know whats happening. When we changed all the Primary keys and foriegn keys in my edmx to decimal ...it works..

Thanks
Ramana

Sent the email with the edmx...i did not send the sql script..because it is too big with all our tables and stored procs..

Hi,

I found the problem to the issue but still not sure how it worked till now. So please let me know if something changed in devart with this new release. Previously the ObjectId(our primary key) is of type Int64 in the edmx and of type number(19,0) in the oracle database. Devart magically figured this out when running the stored procs and did the conversion without complaining. But now it blows up. PLease let me know why this is happening as we cannot make the ObjectId as a decimal in the edmx and it should be as Int64.

Thanks
Ramana

Hi,

We were using EF version 1 with dotconnect for oracle . We moved to VS 2010 RC and have our model project targeting .net framework 3.5. Everything was working. Once we moved our model project to 4.0 and changed our edmx to EF4 and installed the latest devart 5.60.102... the stored procedure calls are giving an error saying
"The type of key field ObjectId is expected to be of type Int64, but the value provided is of type decimal"... I dont get this error is i revert it back to .net framework 3.5. Please let me know what is happening here

Thanks,
Ramana

Hi,

We are currently using Devart v 5.25.49.0 in the VS 2010 beta 2 project in the EDMX. I am getting an error(though my build succeds)..

Error 175: The specified store provider cannot be found in the configuration, or is not valid. C:\projects\VS2010\EF\SafeguardModel\ObjectModel\UmlPatterns.edmx 7 7 ObjectModel

Please let me know your thoughts on this.