Transaction error with Microsoft Lightswitch using Oracle database

Question

I am making a very simple Lightswitch project which will connect to a table I have in an Oracle 11g database. I add an editable grid to the project and build the project. When I try to add or edit data in the grid I get the following error:

An error occurred while starting a transaction on the provider connection. See the inner exception for details.

Inner exception message: Connection is already part of a local or a distributed transaction

There is no custom code in the project. My perception was that Lightswitch was supposed to make forms over data very easy. I've looked around for help but nothing so far.

have you tried the relevant MS Lightswitch forum? : http://social.msdn.microsoft.com/Forums/en-US/category/vslightswitch — Mitch Wheat, Aug 01 '11 at 23:38
I've looked but not found anything useful there yet which is why I was asking here. — Wallhood, Aug 02 '11 at 14:40

score 1 · Answer 1 · answered Oct 05 '11 at 20:22

1

//You need to clean up or the txn will fail..

 partial void SaveChanges_Executed()
{
    tx.Complete();
    tx.Dispose();
}

answered Oct 05 '11 at 20:22

HaggardPete

11
1

kimsk · Answer 2 · 2012-01-18T14:09:16.380

If you get this error, "Inner exception message: Connection is already part of a local or a distributed transaction"

you can resolve the issue by following the second post by BScholz, https://forums.oracle.com/forums/thread.jspa?threadID=2263095

Basically, you need to implement SaveChanges_Excuting and SaveChanges_Excuted for the Oracle Data Source.

Switch to "File View" (LightSwitch will display "Logical View" by default).
Add a reference to "System.Transactions" in Server project.
Switch back to "Logical View"
Right Click the Data Source Name and click "View Code" to edit partial class.

Copy-and-paste the code below:

private TransactionScope _tscope;

partial void SaveChanges_Executing()
{
    _tscope = new TransactionScope(TransactionScopeOption.Required,
    new TransactionOptions
    {
        IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted
    });
}

partial void SaveChanges_Executed()
{
    _tscope.Complete();
    _tscope.Dispose();
}

score 0 · Answer 3 · answered Sep 06 '11 at 19:21

Try adding this code to your datasource code. (right click on the Oracle datasource and choose "View Code")

Make sure you remember to change the class name to match your datasource.

using System.Transactions;

namespace LightSwitchApplication
{
    public partial class <ChangeThisToYourClassName>
    {
        private TransactionScope tx;

        partial void SaveChanges_Executed()
        {
            tx.Complete();
        }

        partial void SaveChanges_Executing()
        {
            tx = new TransactionScope(TransactionScopeOption.Required, 
                  new TransactionOptions { 
                      IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted
                  });
        } 
    }
}

Transaction error with Microsoft Lightswitch using Oracle database

3 Answers3