我正在一个基于Silverlight和RIA服务的项目中使用TransactionScope类。每当需要保存数据时,我会创建一个TransactionScope对象,使用Oracle ODP保存我的数据,然后在TransactionScope对象上调用Complete方法并及时处理该对象:
public override bool Submit(ChangeSet changeSet)
{
TransactionOptions txopt = new TransactionOptions();
txopt.IsolationLevel = IsolationLevel.ReadCommitted;
using (TransactionScope tx = new TransactionScope(TransactionScopeOption.Required, txopt))
{
// Here I open an Oracle connection and fetch some data
GetSomeData();
// This is where I persist my data
result = base.Submit(changeSet);
tx.Complete();
}
return result;
}
我的问题是,第一次调用Submit方法时一切正常,但如果我第二次调用它,执行会在Complete调用后(也就是tx释放之后)卡住几分钟,然后我会得到"ORA-12154"的Oracle错误。当然,我已经检查过持久化代码没有错误。有什么想法吗?
编辑:今天我重复了测试,不知何故,我收到了一个与Oracle异常不同的错误:
System.InvalidOperationException: Operation is not valid due to the current state of the object.
at System.Transactions.TransactionState.ChangeStatePromotedAborted(InternalTransaction tx)
at System.Transactions.InternalTransaction.DistributedTransactionOutcome(InternalTransaction tx, TransactionStatus status)
at System.Transactions.Oletx.RealOletxTransaction.FireOutcome(TransactionStatus statusArg)
at System.Transactions.Oletx.OutcomeEnlistment.InvokeOutcomeFunction(TransactionStatus status)
at System.Transactions.Oletx.OletxTransactionManager.ShimNotificationCallback(Object state, Boolean timeout)
at System.Threading._ThreadPoolWaitOrTimerCallback.PerformWaitOrTimerCallback(Object state, Boolean timedOut)
OracleMTSRecoveryService
或者是仅本地的 TNS 设置?因为你说有一个“第二个”调用,我猜测你可能需要分布式事务设置而不是仅本地的,这将需要OracleMTSRecoveryService
。 - Anjan Biswas