' Optimistic concurrency' exception on bool fields

' Optimistic concurrency' exception on bool fields

Postby 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
david.urting
 
Posts: 2
Joined: Wed 11 Feb 2015 07:43

Re: ' Optimistic concurrency' exception on bool fields

Postby 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: 7530
Joined: Thu 14 Aug 2008 12:44

Re: ' Optimistic concurrency' exception on bool fields

Postby 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: 7530
Joined: Thu 14 Aug 2008 12:44

Re: ' Optimistic concurrency' exception on bool fields

Postby 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.
Shalex
Devart Team
 
Posts: 7530
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle