Devart Forums

DarenM

Any updates?

DarenM

I am repeatedly seeing this error in an area of my application and I am unable to diagnose why I am seeing it. Here is a snippet of what I see in the DB Mon log File:

Code: Select all

  9/10/2010 4:09:21 PM 0.032 Close connection Complete
  9/10/2010 4:09:21 PM 0.016 Connection is returned to pool. Pool has 2 connection(s). Complete
  9/10/2010 4:09:22 PM 0.141 Disconnect Complete
  9/10/2010 4:09:25 PM 0.015 Creating object Complete
  9/10/2010 4:09:25 PM 0.032 Open connection: "User Id=pqdev;Password=*******;Server=tst-db-ora1;Direct=True;Sid=cctest;Port=1528;Persist Security Info=True;" Complete
  9/10/2010 4:09:25 PM 0.016 Taking connection from connection pool: "User Id=pqdev;Password=*******;Server=tst-db-ora1;Direct=True;Sid=cctest;Port=1528;Persist Security Info=True;" Complete
  9/10/2010 4:09:25 PM 0.000 Connection is taken from pool. Pool has 1 connection(s). Complete
  9/10/2010 4:09:25 PM 0.015 Prepare: SET TRANSACTION ISOLATION LEVEL READ COMMITTED Complete
  9/10/2010 4:09:25 PM 0.421 Execute: SET TRANSACTION ISOLATION LEVEL READ COMMITTED Error
  9/10/2010 4:09:26 PM 0.016 Close connection Complete
  9/10/2010 4:09:26 PM 0.000 Connection is returned to pool. Pool has 1 connection(s). Complete

And the ORACLE error is: ORA-01453: SET TRANSACTION must be first statement of transaction

I cannot see why this is happening - any tips on what else I can do to diagnose what is going on?

DarenM

Thanks Andrey - your response:

You have not set the StoreGeneratedPattern in the SSDL part of the model.
I have sent you the corrected project back, it works now.
Open the model in the XML Editor, you will see this attrbute set in the SSDL part of the model for the Entity Key property.
Visual Studio ignores setting this attribute in the CSDL part of the model (which takes place when you edit the property in design time), this is a known issue:
http://geeksharp.com/2010/05/27/ef4-bug ... tern-ssdl/

Has indeed corrected the issue for me. Just to clarify for anyone else that wanders by - this is a bug in the EF designer, not DevArt's EF provider.

DarenM

I have sent SQL logs as well. Can you please confirm you have received these emails. Thanks.

DarenM

Just resent the project.

DarenM

Any luck looking at the test project to see what I am doing wrong?

DarenM

Thanks for responding Audrey. The model is implementde as you suggested, but I am not seeing the expected result. If I insert a record and submit changes, the entity appears in the DB with the appropriate key value, but the enntity client side remains with an ID of zero. If I attempt a subsequent isert, it fails client side as there is a duplicate ID of zero.

DarenM

We are using a DB that leverages an insert trigger to populate the primary key upon insert, however Entity Framework is not refreshing the entity with the new Id... Any particular trick to getting this to work?

Thanks.

Devart Forums

Search found 8 matches

ORA-01453: SET TRANSACTION must be first statement...

Entity Key not updating on Insert