very long commit, need snapshot isolation for reading

5 posts, 0 answers
  1. Sascha
    Sascha avatar
    2 posts
    Member since:
    Sep 2008

    Posted 11 Sep 2009 Link to this post

    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
  2. Thomas
    Admin
    Thomas avatar
    590 posts

    Posted 11 Sep 2009 Link to this post

    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.
  3. DevCraft banner
  4. Thomas
    Admin
    Thomas avatar
    590 posts

    Posted 11 Sep 2009 Link to this post

    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.
  5. Sascha
    Sascha avatar
    2 posts
    Member since:
    Sep 2008

    Posted 30 Oct 2009 Link to this post

    Hi?

    When can I get the new version of OpenAccess?

    Best regars.
    Sascha
  6. Thomas
    Admin
    Thomas avatar
    590 posts

    Posted 30 Oct 2009 Link to this post

    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.
Back to Top
DevCraft banner