Exception on ApplyChanges() with MS SQL Server Compact Edition

I only get an exception with disconnectedState.ApplyChanges() and sqlserverce-provider: "This storage does not support 'Savepoints'."

I do not use 'Savepoints'.

Any ideas or recommendations?

asked Oct 18 '10 at 11:10

TeaMan
140●14●14●18

edited Oct 22 '10 at 11:19

Alex Yakunin
2971●4●4●12

4 Answers:

oldest newest most voted

We'll fix this. Recently we really added a code that creates a nested transaction while applying the changes to the same Session, if outermost transaction is already open there.

Issue 840 is created.

answered Oct 18 '10 at 14:17

Alex Yakunin
2971●4●4●12

edited Oct 21 '10 at 09:13

Fixed in stable branch; the update will be available soon.

(Oct 27 '10 at 09:19) Alex Yakunin

Here are the steps to reproduce the issue (only takes 1 minute):

I use Visual Studio 2010 Ultimate, .NET Framework 4.0, DataObjects.Net v4.3.5 (build 6600), Xtensive.Storage.Samples.Wpf
Create with Visual Studio an empty MSSQL CE Dba.sdf
Copy this file to a new directory Xtensive.Storage.Samples.Wpf\bin\Debug\Data\
Edit App.config in Xtensive.Storage.Samples.Wpf
Change the oracle entry to: <domain name="oracle" upgradeMode="PerformSafely" connectionUrl="sqlserverce://localhost/Data\Dba.sdf"/>
Debug the example in Visual Studio with F5
Select "Oracle" from the start dialog
Choose the 2nd entry of the company's listbox
Change "X-tensive" to "X-tensiv"
Click the button "Apply changes"

--> StorageException: Current storage provider does not support savepoints (nested transactions). in MainWindow.xaml.cs disconnectedState.ApplyChanges(); Line 196

Kind Regards

answered Nov 01 '10 at 11:18

TeaMan
140●14●14●18

edited Nov 01 '10 at 12:29

Thank you for your interesting hints!

However, the exception is released independently by an already opened outermost transaction! Also the exception is throwing when calling ApplyChanges(session) for another session.

The error message seems to result more likely from a failed test of the missing feature "Savepoints".

It would be nice if for demo program versions the MS SQL Server Compact Edition could be used.

Due to the error with ApplyChanges() this provider can currently not be used in WPF applications. Unfortunaltely the alternative IMDB-provider is still missing transactions and saving data.

The error can very easily be tried out in the example "Xtensive.Storage.Samples.Wpf" (with the sqlserverce-provider).

In what timeframe could the problem be fixed?

Kind Regards

answered Oct 19 '10 at 10:13

TeaMan
140●14●14●18

We'll fix it in one week at max. It looks like nested transaction is really always used there.

(Oct 19 '10 at 10:30) Alex Yakunin

The issue is created.

(Oct 21 '10 at 09:13) Alex Yakunin

Unfortunately, the problem is still unresolved - I use the new build 6600! Please test it with your own WPF example!

Kind Regards

answered Nov 01 '10 at 05:25

TeaMan
140●14●14●18

I just checked WPF sample - it works. But OrderAccounting sample (for WPF as well) crashes on attempt to add the order item, although the issue here isn't related to memory storage. We'll investigate it tomorrow and update the installers, if this will be necessary.

If you've faced other issue, please notify us about this. I didn't check WCF sample yet (there is WPF client as well, I'll view it tomorrow), so probably, you could face it there.

(Nov 01 '10 at 09:45) Alex Yakunin

I am using DO 4.3 and there the issue is still present. Any estimation on the release of 4.4 where this might be resolved?

(Jan 15 '11 at 10:38) jensen

Sorry, the issue was just fixed. The update will be available in a day or so.

(Jan 17 '11 at 05:56) Alex Yakunin

I read in another thread 4.4 is expected in the next couple of weeks. Will this fix be part of it? I really need it and I need to start with the implementation of my data model ASAP.

If it's not fixed and a release is not sheduled any time soon I'm afraid DO is no longer an option for me.

(Jan 27 '11 at 05:55) jensen

The fix is included in both upcoming releases: 4.3.7 & 4.4 beta 2. If we manage to complete all pre-release tasks on time, both will be published on Friday; otherwise, in the beginning of the next week.

(Jan 27 '11 at 07:05) Dmitri Maximov

Awesome! Thanks.

(Jan 27 '11 at 12:43) jensen

DataObjects.Net 4.3.7 & 4.4 beta 2 is released

(Jan 29 '11 at 04:21) Dmitri Maximov

Your answer

Please start posting your answer anonymously - your answer will be saved within the current session and published after you log in or create a new account. Please try to give a substantial answer, for discussions, please use comments and please do remember to vote (after you log in)!

toggle preview

community wiki

Subscription:

Once you sign in you will be able to subscribe for any updates here

Tags:

DataObjects.Net ×574
bug-report ×120
disconnected-state ×24
sql-server-ce ×2

Asked: Oct 18 '10 at 11:10

Seen: 7,364 times

Last updated: Jan 29 '11 at 04:21

Subscription:

Related questions