internal PersistenceDBAccessor(DbResourceAllocator dbResourceAllocator, Transaction transaction, WorkflowCommitWorkBatchService transactionService) { this.dbResourceAllocator = dbResourceAllocator; this.localTransaction = DbResourceAllocator.GetLocalTransaction(transactionService, transaction); this.connection = this.dbResourceAllocator.GetEnlistedConnection(transactionService, transaction, out this.needToCloseConnection); this.dbRetry = new DbRetry(false); }
internal PersistenceDBAccessor(DbResourceAllocator dbResourceAllocator, bool enableRetries) { this.dbResourceAllocator = dbResourceAllocator; this.dbRetry = new DbRetry(enableRetries); DbConnection connection = null; short retryCount = 0; Label_001D: try { WorkflowTrace.Host.TraceEvent(TraceEventType.Information, 0, "SqlWorkflowPersistenceService OpenConnection start: " + DateTime.UtcNow.ToString("G", CultureInfo.InvariantCulture)); connection = this.dbResourceAllocator.OpenNewConnection(); WorkflowTrace.Host.TraceEvent(TraceEventType.Information, 0, "SqlWorkflowPersistenceService. OpenConnection end: " + DateTime.UtcNow.ToString("G", CultureInfo.InvariantCulture)); if ((connection == null) || (ConnectionState.Open != connection.State)) { throw new InvalidOperationException(ExecutionStringManager.InvalidConnection); } } catch (Exception exception) { WorkflowTrace.Host.TraceEvent(TraceEventType.Error, 0, "SqlWorkflowPersistenceService caught exception from OpenConnection: " + exception.ToString()); if (!this.dbRetry.TryDoRetry(ref retryCount)) { throw; } WorkflowTrace.Host.TraceEvent(TraceEventType.Information, 0, "SqlWorkflowPersistenceService retrying."); goto Label_001D; } this.connection = connection; this.needToCloseConnection = true; }
protected internal override void CommitWorkBatch(WorkflowCommitWorkBatchService.CommitWorkBatchCallback commitWorkBatchCallback) { DbRetry retry = new DbRetry(this._enableRetries); short retryCount = 0; Label_000E: if (null != Transaction.Current) { retryCount = retry.MaxRetries; } try { base.CommitWorkBatch(commitWorkBatchCallback); } catch (Exception exception) { WorkflowTrace.Host.TraceEvent(TraceEventType.Error, 0, "DefaultWorkflowCommitWorkBatchService caught exception from commitWorkBatchCallback: " + exception.ToString()); if (!retry.TryDoRetry(ref retryCount)) { throw; } WorkflowTrace.Host.TraceEvent(TraceEventType.Information, 0, "DefaultWorkflowCommitWorkBatchService retrying commitWorkBatchCallback (retry attempt " + retryCount.ToString(CultureInfo.InvariantCulture) + ")"); goto Label_000E; } }
/// <summary> /// DB access done under a transaction and uses a connection enlisted to this transaction. /// </summary> /// <param name="dbResourceAllocator">Helper to get database connection/command/store procedure parameters/etc</param> /// <param name="transaction">The transaction to do this work under</param> internal PersistenceDBAccessor( DbResourceAllocator dbResourceAllocator, System.Transactions.Transaction transaction, WorkflowCommitWorkBatchService transactionService) { this.dbResourceAllocator = dbResourceAllocator; this.localTransaction = DbResourceAllocator.GetLocalTransaction( transactionService, transaction); // Get a connection enlisted to this transaction, may or may not need to be freed depending on // if the transaction does connection sharing this.connection = this.dbResourceAllocator.GetEnlistedConnection( transactionService, transaction, out needToCloseConnection); // // No retries for external transactions this.dbRetry = new DbRetry(false); }
/// <summary> /// DB access done without a transaction in a newly opened connection /// </summary> /// <param name="dbResourceAllocator">Helper to get database connection/command/store procedure parameters/etc</param> internal PersistenceDBAccessor(DbResourceAllocator dbResourceAllocator, bool enableRetries) { this.dbResourceAllocator = dbResourceAllocator; this.dbRetry = new DbRetry(enableRetries); DbConnection conn = null; short count = 0; while (true) { try { WorkflowTrace.Host.TraceEvent(TraceEventType.Information, 0, "SqlWorkflowPersistenceService OpenConnection start: " + DateTime.UtcNow.ToString("G", System.Globalization.CultureInfo.InvariantCulture)); conn = this.dbResourceAllocator.OpenNewConnection(); WorkflowTrace.Host.TraceEvent(TraceEventType.Information, 0, "SqlWorkflowPersistenceService. OpenConnection end: " + DateTime.UtcNow.ToString("G", System.Globalization.CultureInfo.InvariantCulture)); if ((null == conn) || (ConnectionState.Open != conn.State)) throw new InvalidOperationException(ExecutionStringManager.InvalidConnection); break; } catch (Exception e) { WorkflowTrace.Host.TraceEvent(TraceEventType.Error, 0, "SqlWorkflowPersistenceService caught exception from OpenConnection: " + e.ToString()); if (dbRetry.TryDoRetry(ref count)) { WorkflowTrace.Host.TraceEvent(TraceEventType.Information, 0, "SqlWorkflowPersistenceService retrying."); continue; } throw; } } connection = conn; needToCloseConnection = true; }
protected internal override void CommitWorkBatch(WorkflowCommitWorkBatchService.CommitWorkBatchCallback commitWorkBatchCallback) { ManualResetEvent event2; DbRetry retry = new DbRetry(this._enableRetries); short maxRetries = retry.MaxRetries; Label_0013: event2 = new ManualResetEvent(false); Transaction transaction = null; SharedConnectionInfo connectionInfo = null; try { if (null == Transaction.Current) { maxRetries = 0; transaction = new CommittableTransaction(); connectionInfo = new SharedConnectionInfo(this.dbResourceAllocator, transaction, false, event2); } else { transaction = Transaction.Current.DependentClone(DependentCloneOption.BlockCommitUntilComplete); connectionInfo = new SharedConnectionInfo(this.dbResourceAllocator, transaction, true, event2); } this.AddToConnectionInfoTable(transaction, connectionInfo); using (TransactionScope scope = new TransactionScope(transaction)) { try { commitWorkBatchCallback(); scope.Complete(); } finally { this.RemoveConnectionFromInfoTable(transaction); event2.Set(); } } CommittableTransaction transaction2 = transaction as CommittableTransaction; if (transaction2 != null) { transaction2.Commit(); } DependentTransaction transaction3 = transaction as DependentTransaction; if (transaction3 != null) { transaction3.Complete(); } } catch (Exception exception) { transaction.Rollback(); WorkflowTrace.Host.TraceEvent(TraceEventType.Error, 0, "SharedConnectionWorkflowCommitWorkBatchService caught exception from commitWorkBatchCallback: " + exception.ToString()); if (!retry.TryDoRetry(ref maxRetries)) { throw; } WorkflowTrace.Host.TraceEvent(TraceEventType.Information, 0, "SharedConnectionWorkflowCommitWorkBatchService retrying commitWorkBatchCallback (retry attempt " + maxRetries.ToString(CultureInfo.InvariantCulture) + ")"); goto Label_0013; } finally { event2.Close(); if (transaction != null) { transaction.Dispose(); } } }