' Optimistic concurrency' exception on bool fields

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
david.urting
Posts: 2
Joined: Wed 11 Feb 2015 07:43

' Optimistic concurrency' exception on bool fields

Post by david.urting » Fri 20 Mar 2015 11:46

Hi,

we have an 'optimistic concurrency' issue with version 8.4 of dotConnect for Oracle on entity fields of type bool. This issue does not occur with version 7.1.

Case:
- Tools/frameworks: Visual Studio 2013 Update 4, .NET FW 4.5/EDMX 3.0, Devart 8.4.215.0, Entity Framework 5 (code generation strategy 'Legacy ObjectContext'), Oracle 11g2.
- A table with a IS_TRUE NUMBER(1,0) column that is mapped on a bool property. The entity inherits EntityObject (legacy).
- The Concurrency Mode on that column is 'Fixed'.
- When updating an entity that has IS_TRUE = 1 as old value AND as new value, an 'OptimisticConcurrencyException' is thrown.
- The DBMonitor shows that the old value is 0 (this should be 1).

If necessary I can provide a VS2013 solution that reproduces the case.

Is this a bug?

greetings,
David

Shalex
Devart Team
Posts: 8088
Joined: Thu 14 Aug 2008 12:44

Re: ' Optimistic concurrency' exception on bool fields

Post by Shalex » Tue 24 Mar 2015 14:52

We have reproduced the issue and are investigating it. As soon as we have any results, we will let you know.

Shalex
Devart Team
Posts: 8088
Joined: Thu 14 Aug 2008 12:44

Re: ' Optimistic concurrency' exception on bool fields

Post by Shalex » Wed 25 Mar 2015 12:23

The bug with generating SQL for the INSERT / UPDATE / DELETE operations when using bool property mapped to Number(1,0) is fixed. We will notify you when the corresponding build of dotConnect for Oracle is available for download.

Shalex
Devart Team
Posts: 8088
Joined: Thu 14 Aug 2008 12:44

Re: ' Optimistic concurrency' exception on bool fields

Post by Shalex » Thu 26 Mar 2015 15:44

New build of dotConnect for Oracle 8.4.379 is available for download!
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with active subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?f=1&t=31498.

Post Reply