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


ADVERTISEMENT

ODP.NET :: Oracle XE 11g And Entity Framework 4.4

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

OLE DB :: Oracle 8 With Entity Framework?

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

SQL & PL/SQL :: Concurrency With ORA_ROWSCN?

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

Concurrency Wait On Insert Statement?

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

Application Express :: Build A Menu Framework

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

SQL & PL/SQL :: Difference Between SCHEMA And ENTITY?

Dec 7, 2011

What is the difference between a SCHEMA and an ENTITY?

View 5 Replies View Related

Database Time Spent Waiting % For Event Class Concurrency

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

ODP.NET :: Cannot Find Oracle Data Source In Entity Data Model Wizard

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







Copyrights 2005-15 www.BigResource.com, All rights reserved