This question is locked. New answers and comments are not allowed.
Hello folks,
I have a problem:
In my first application I will store a lot of data within one transaction (>100.000 objects). I can't cut this into pieces.
A second application can't read the tables while performing the commit in the first application. If I use "Isolation Level Snapshot", I can read the data, but Open Access doen't support it. Only if I use System.Transactions it will work, but all of my code uses scope.Transaction.Begin() :-(
What can I do?
I'm using .NET 3.5 SP1 and SQL Server 2005 oder higher.
Best regrads,
Sascha Ellerhoff,
Diomex Software
I have a problem:
In my first application I will store a lot of data within one transaction (>100.000 objects). I can't cut this into pieces.
A second application can't read the tables while performing the commit in the first application. If I use "Isolation Level Snapshot", I can read the data, but Open Access doen't support it. Only if I use System.Transactions it will work, but all of my code uses scope.Transaction.Begin() :-(
What can I do?
I'm using .NET 3.5 SP1 and SQL Server 2005 oder higher.
Best regrads,
Sascha Ellerhoff,
Diomex Software
4 Answers, 1 is accepted
0
Hello Sascha,
thanks for bringing this to our attention... I've included the SNAPSHOT iso level into the configuration so that you can write
<isolationLevel>SNAPSHOT</isolationLevel>
in the backend configuration with the next OpenAccess patch. As a workaround in the mean time you could use
<initSql>SET TRANSACTION ISOLATION LEVEL SNAPSHOT</initSql>
Hope this solves the issue for you,
Thomas
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
thanks for bringing this to our attention... I've included the SNAPSHOT iso level into the configuration so that you can write
<isolationLevel>SNAPSHOT</isolationLevel>
in the backend configuration with the next OpenAccess patch. As a workaround in the mean time you could use
<initSql>SET TRANSACTION ISOLATION LEVEL SNAPSHOT</initSql>
Hope this solves the issue for you,
Thomas
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
0
Hello Sascha,
one should not type faster than think! The workaround is not working as we specify the txn level every time we start a txn... Sorry for the confusion.
Kind regards,
Thomas
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
one should not type faster than think! The workaround is not working as we specify the txn level every time we start a txn... Sorry for the confusion.
Kind regards,
Thomas
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
0
Sascha
Top achievements
Rank 1
Rank 1
answered on 30 Oct 2009, 03:55 PM
Hi?
When can I get the new version of OpenAccess?
Best regars.
Sascha
When can I get the new version of OpenAccess?
Best regars.
Sascha
0
Hello Sascha,
the Q3 release is scheduled for the next week - you should give this version a try.
Sincerely yours,
Thomas
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
the Q3 release is scheduled for the next week - you should give this version a try.
Sincerely yours,
Thomas
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.