ODP.NET :: Entity Framework Concurrency - UpdateException
Nov 28, 2012
When running into what should be an OptimisticConcurrencyException in entity framework, i'm getting an update exception as follows:
"A null store-generated value was returned for a non-nullable member 'DateChanged' of type 'FDDT.Model.FeedArray'."
I'm using the DateChanged field as the concurrency tracking field. In entity framework DateChanged has the following properties:
StoreGeneratedPattern: Computed
Concurrency Mode: Fixed
I have a trigger set on this field as follows:
TRIGGER FEED_ARRAY_TRIG_DTCHG before update on FEED_ARRAY for each row
begin
:new.DATE_CHANGED := sysdate;
end;
I've tried setting this concurrency tracking field to "Identity" instead, however that causes another error when I run into a concurrency exception and refresh using the client wins option.
View 2 Replies
Dec 4, 2012
I have Windows Server 2008 R2 32bit and Oracle 11g Release 2 Express Edition installed on my server machine.
I have Windows 7 Pro 64bit, Visual Studio 2010 SP1 32bit, .NET 4.0 and Oracle .NET Data Provider (ODTwithODAC1120320_32bit) installed on my development machine.
The data provider download mentioned Entity Framework support. Existing tutorials on how to use Oracle with the Entity Framework makes me believe that EF is indeed supported! But when I try to create a new ADO.NET Entity Model, the Oracle data provider nor data source isn't listed!
Image: [URL]
On the other hand, if I want to create a new database connection, via the Server Explorer view, there are no problems connection to Oracle's DB.
Image: [URL]
The reason I need Entity Framework support is because we're migrating from MSSQL to Oracle and are looking for the most painless route to do so.
View 1 Replies
View Related
Dec 10, 2012
am starting a new project for a customer who is currently using Oracle 8x. My experience as a software developer has been using MS SQL Server and so most of our code uses Entity Framework 4 and 5 with ASP.Net 4.0 and 4.5. This is my first experience with Oracle.
After doing some research I found that it looks like their version of Oracle is EOL and no longer supported. Does using Oracle Data connection tool kits for Entity Framework and Oracle 8? The tutorial that Oracle has on there site requires Oracle 10.25 or later? I am wondering if I will need to drop my code back to inline sql or if I can still use Linq with EF.
View 2 Replies
View Related
Jul 18, 2012
can i use ORA_ROWSCN to handle concurrency in oracle, That is i want to read ora_rowscn and keep it in my form or BL then before update i want to read ora_rowscn and match with old version.
1)Since it is updated after commit , how can it affect the application?
2) should i use some Guid in place of ORA_ROWSCN?
3) sequence in each table with trigger in place of ORA_ROWSCN?
View 2 Replies
View Related
Feb 19, 2013
I am running Oracle RAC 2 nodes 11g R2 on AIX 7.1
I have a table with unique index, and the application is doing inserts/updates into this table.Suddenly and for about half a minute I faced a high concurrency waits on all the processes running these inserts for one node. I saw this high concurrency wait in the top activity screen of the OEM only on one of the nodes. knowing that the processes doing these inserts are running on both nodes.
All what I have that in this half minute I see high concurrency wait in OEM top activity screen related to this insert statement and when I clicked on the insert I found high "enq: TX - index contention". Again this was only on one node.After this half minute everything went back to normal.What could be the reason and how can I investigate it ?
View 3 Replies
View Related
Jun 27, 2012
I have built a Menu Framework using the following instructions.
[URL]........
I am facing 2 problems.
1. If the user is in a child application and clicks logout. He is taken to the login screen of the master application (Correct), but once he enters login details, he is returned to the child application (False). I think he should be returned to the Home page of the Master application.
2. If I set Session Timeouts in the Edit Security Attributes of the applications. Then if the user is timed out, he is sent to the login screen of the Master application (Correct). If he then logs in, he is sent the the Home page of the Master application (Correct).
Now if he clicks a link to a child application he is then sent back to the Master application login screen. He then has to login again. He is sent to the Master Home page and everything is then ok.
View 1 Replies
View Related
Dec 7, 2011
What is the difference between a SCHEMA and an ENTITY?
View 5 Replies
View Related
Dec 4, 2012
Most of my day to day work involves the support of DB2 on AIX and z/OS. I support the database infrastructure for one business system that runs on the Oracle RDBMS. The application is Oracle Transportation Management. The non-production environments don't get much traffic. If I sign into the TEST or DEV Enterprise Manager DB Control screen, the following warning is almost always listed on the main page:
Metrics "Database Time Spent Waiting (%)" is at 44.00384 for event class "Concurrency"
Enterprise Manager reports that this metric is continuously fluctuating above and below the warning threshold of 30% of db time when the environment is idle.To investigate(and I am no oracle expert, far from it), I ran the following:
SELECT * FROM v$session_event
WHERE WAIT_CLASS='Concurrency'
ORDER BY TOTAL_WAITS DESC;
By far, the top two entries in the result are the following:
SIDEVENTTOTAL_WAITSTIME_WAITEDAVERAGE_WAITMAX_WAIT
124os thread startup12041423733.5218
359os thread startup150653433.5521
[code]...
Does this indicate a possible problem with the operating system?
View 2 Replies
View Related
Dec 19, 2012
I'm trying to add edmx file in my project for first time. I want to choose the oracle provider ODP.net but cannot find Oracle in the data source list. I have oracle 11g installed , odp and odt installed and can access it from the solution as well. I saw the Oracle listed under data source when I tried to connect the solution to the database through server explorer. The solution is connected to Oracle database through ODP.
View 8 Replies
View Related