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's gravatar image

TeaMan
140141418

edited Oct 22 '10 at 11:19

Alex%20Yakunin's gravatar image

Alex Yakunin
29714412


4 Answers:

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%20Yakunin's gravatar image

Alex Yakunin
29714412

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 Alex%20Yakunin's gravatar image

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's gravatar image

TeaMan
140141418

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's gravatar image

TeaMan
140141418

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 Alex%20Yakunin's gravatar image

The issue is created.

(Oct 21 '10 at 09:13) Alex Yakunin Alex%20Yakunin's gravatar image

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's gravatar image

TeaMan
140141418

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 Alex%20Yakunin's gravatar image

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 jensen's gravatar image

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

(Jan 17 '11 at 05:56) Alex Yakunin Alex%20Yakunin's gravatar image

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 jensen's gravatar image

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 Dmitri%20Maximov's gravatar image

Awesome! Thanks.

(Jan 27 '11 at 12:43) jensen jensen's gravatar image

DataObjects.Net 4.3.7 & 4.4 beta 2 is released

(Jan 29 '11 at 04:21) Dmitri Maximov Dmitri%20Maximov's gravatar image
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

powered by OSQA