ORA_ROWSCN pseudo column update error

huanghexd · Post by **huanghexd** » Tue 09 Sep 2008 19:14

After automatically generting the .edmx file from an Oracle 10g database, I manually add the following line:

into the store schema section and changed the conceptual schema and the c-s mapping accordingly.

The reading of ORA_ROWSCN is just fine. But when SaveChanges() was called, an exception occured: InternalExcpetion "{"Unknown column 'ORA_ROWSCN'"}".

Any suggestion? Thanks.

Shalex · Post by **Shalex** » Thu 11 Sep 2008 16:24

It is impossible to support all types of pseudo-columns, but ORA_ROWSCN support will be already available in the next build.

huanghexd · Post by **huanghexd** » Thu 11 Sep 2008 18:34

Thank you, Shalex, for your reply. Is there any chance to give the release date of the next build?

Shalex · Post by **Shalex** » Fri 12 Sep 2008 07:28

We can't provide you with the exact date now. But the next build will be available during 2 weeks for sure.

huanghexd · Post by **huanghexd** » Fri 12 Sep 2008 12:42

That's great. Thanks.

huanghexd · Post by **huanghexd** » Tue 28 Oct 2008 19:44

The problem was only partially solved by dotConnect 5.0.beta:

The SaveChanges() works fine but the new value of ORA_ROWSCN does not fetch back correctly -- the new value is set to be null.

The reason I found is: the new value of ORA_ROWSCN is availabe only after the change is committed. But in the generated sql statement by dotConnet, the ORA_ROWSCN is returned back before the commit. So we get back a null value.

Any comment? Thanks.

Shalex · Post by **Shalex** » Fri 31 Oct 2008 16:35

When you refreshing data, the cycle of update-refresh is executing for every record. Transaction is commited only after refreshing all the tabels. We cannot provide committing transaction before every returning of updatable columns.

huanghexd · Post by **huanghexd** » Tue 04 Nov 2008 22:47

That makes sense. So ORA_ROWSCN is not a REAL updatable column, even if we set the StoreGeneratedPattern="Computed" attribute.