Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Parent/Child and Oracle Transactions
Message
From
01/08/2007 11:39:01
Alan Hoiland
Canadian Natural Resources Ltd.
Calgary, Alberta, Canada
 
 
To
All
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Title:
Parent/Child and Oracle Transactions
Miscellaneous
Thread ID:
01245170
Message ID:
01245170
Views:
169
Hello,

I have been trying to do some transactional processing using the MM Parent/Child relationship. I set up a scenario where I save the parent entity and it automatically saves the child entity and that works OK. In a second scenario, I can manufacturer an error while saving the child entity, MM rolls back the transaction and the database remains unchanged. That is OK but then an exception is thrown:

System.InvalidOperationException was unhandled
Message: This OracleTransaction has completed; it is no longer usable.

I assume this indicates that MM is trying to do something with the transaction after it has completed.

If I set the Child's AutoUseTransactions property to false, the exception is not thrown, and the transaction appears to rollback successfully. This indicates the child is also trying to rollback after the parent.

Don't know if this is a bug or expected behaviour - couldn't find anything in the dev guide. Maybe you need to check the status of the transaction before rolling it back?
Next
Reply
Map
View

Click here to load this message in the networking platform