As of version 6.30, dotConnect for Oracle implements Oracle Workflow Instance Store. To use Oracle Workflow Instance Store you need Oracle server 9 or higher.

Before using Oracle Workflow Instance Store, you need to create a database that is used to persist workflow instances. dotConnect for Oracle provides the scripts for creating this database. They are placed to the WF Services subfolder of the dotConnect for Oracle installation folder. By default it is %ProgramFiles%\Devart\dotConnect\Oracle\WF Services\. Note that there are two versions of scripts - for .NET Framework 4.5, and for previous versions of .NET Framework.

If you target .NET Framework 4.5, execute the OracleInstanceStoreSchema45.sql script first and then execute OracleInstanceStoreLogic45.sql. If you target .NET Framework 3.0, 3.5, or 4.0, execute the OracleInstanceStoreSchema.sql script first and then execute OracleInstanceStoreLogic.sql. You may use these scripts to clean up the persistence database to have a fresh database in the same way, just execute them in the same order.

Configuring InstanceStore for Self-Hosted Workflows that use WorkflowApplication

To enable persistence for self-hosted workflows that use WorkflowApplication, perform the following steps:

1. Add the reference to Devart.Data.Oracle.WorkflowFoundation.dll in your project.

2. Specify the using directive:

   • C#

   using Devart.Data.Oracle.DurableInstancing;

   • Visual Basic

   Imports Devart.Data.Oracle.DurableInstancing
   

3. Create OracleInstanceStore and assign the following code to the InstanceStore property of WorkflowApplication:

   • C#

   OracleInstanceStore store = new OracleInstanceStore(your_connection_string);
   WorkflowApplication wfApp = new WorkflowApplication(new Workflow1());
   wfApp.InstanceStore = store;

   • Visual Basic

   Dim store As New OracleInstanceStore(your_connection_string)
   Dim wfApp As New WorkflowApplication(New Workflow1())
   wfApp.InstanceStore = store
   

4. Call the Persist() method on the WorkflowApplication to persist a workflow.

Configuring InstanceStore with OracleInstanceStoreBehavior Class

To enable persistence using the OracleInstanceStoreBehavior class, perform the following steps:

1. Add a reference to the Devart.Data.Oracle.Activities.Description.dll

2. Add the following statement at the top of the source file after the existing "using" statements.

   • C#

   using Devart.Data.Oracle.Activities.Description;

   • Visual Basic

   Imports Devart.Data.Oracle.Activities.Description
   

3. Create an instance of the WorkflowServiceHost and add endpoints for the workflow service.

   • C#

   WorkflowServiceHost host = new WorkflowServiceHost(new CountingWorkflow(), new Uri(hostBaseAddress));
   host.AddServiceEndpoint("ICountingWorkflow", new BasicHttpBinding(), "");

   • Visual Basic

   Dim host As New WorkflowServiceHost(New CountingWorkflow(), New Uri(hostBaseAddress))
   host.AddServiceEndpoint("ICountingWorkflow", New BasicHttpBinding(), "")
   

4. Construct an OracleInstanceStoreBehavior object and to set properties of the behavior object.

   • C#

   OracleInstanceStoreBehavior instanceStoreBehavior = new OracleInstanceStoreBehavior(connectionString);
   instanceStoreBehavior.HostLockRenewalPeriod = new TimeSpan(0, 0, 5);
   instanceStoreBehavior.InstanceCompletionAction = InstanceCompletionAction.DeleteAll;
   instanceStoreBehavior.InstanceLockedExceptionAction = InstanceLockedExceptionAction.AggressiveRetry;
   instanceStoreBehavior.InstanceEncodingOption = InstanceEncodingOption.GZip;
   instanceStoreBehavior.RunnableInstancesDetectionPeriod = new TimeSpan("00:00:02");
   host.Description.Behaviors.Add(instanceStoreBehavior);

   • Visual Basic

   Dim instanceStoreBehavior As New OracleInstanceStoreBehavior(connectionString)
   instanceStoreBehavior.HostLockRenewalPeriod = New TimeSpan(0, 0, 5)
   instanceStoreBehavior.InstanceCompletionAction = InstanceCompletionAction.DeleteAll
   instanceStoreBehavior.InstanceLockedExceptionAction = InstanceLockedExceptionAction.AggressiveRetry
   instanceStoreBehavior.InstanceEncodingOption = InstanceEncodingOption.GZip
   instanceStoreBehavior.RunnableInstancesDetectionPeriod = New TimeSpan("00:00:02")
   host.Description.Behaviors.Add(instanceStoreBehavior)
   

5. Open the workflow service host.

   • C#

   host.Open();

   • Visual Basic

   host.Open()
   

Configuring InstanceStore with Config File

To configure Oracle Instance Store by using the oracleInstanceStore behavior element in a configuration file, perform the following steps:

1. Add the following behavior extension element to the Machine.config file so that you can use the <oracleInstanceStore> service behavior element in the configuration files of your applications to configure persistence for your services:

   <configuration>
       <system.serviceModel>
           <extensions>
               <behaviorExtensions>
                   <add name="oracleInstanceStore" type="Devart.Data.Oracle.Activities.Configuration.OracleInstanceStoreElement, Devart.Data.Oracle.WorkflowFoundation, Version=8.4.215.0, Culture=neutral, PublicKeyToken=09af7300eec23701" />
               </behaviorExtensions>
           </extensions>
       </system.serviceModel>
   </configuration>

   Note: Replace 8.4.215.0 in the code with your actual version.

2. Configure Oracle Instance Store by using the oracleInstanceStore behavior element in a configuration file of your application:

   <configuration>
       <system.serviceModel>
         <behaviors>  
           <serviceBehaviors>
       	    <behavior name="">
                   <oracleInstanceStore 
                       connectionString="User Id=Scott;Password=tiger;Data Source=Ora;"
                       instanceEncodingOption="GZip | None"
                       instanceCompletionAction="DeleteAll | DeleteNothing"
                       instanceLockedExceptionAction="NoRetry | BasicRetry |AggressiveRetry"
                       hostLockRenewalPeriod="00:00:30" 
                       runnableInstancesDetectionPeriod="00:00:05" />
       	    </behavior>
           </serviceBehaviors>
         </behaviors>  
       </system.serviceModel>
   </configuration>

See Also

Workflow Tracking Support  | Development Tools and Features