Using Transactions with soapUI

The following tutorial demonstrates how Portus can be used with Adabas transactions. It is assumed you are already familiar with the following

• soapUi ( see here )
• Creating Portus web services from Adabas ( see here )
• Familar with SOAP Header usage concepts ( see here )

For this tutorial, we will use the Employees demo file (usually file number 11) that comes with Adabas, and the adabas_employees_mini_view data view. It is assumed you have already created a web service for your Adabas file.

1. Import the WSDL into soapUi.

2. Choose the request for the add operation, and in the XML set the ConversationState to "New" and the TransactionState to "New". Also remove the other Header values.

   Send the request to Portus. e.g.:

   

   Portus has now created a new Conversation and a new Transaction for this request. The IDs for each of these are returned.

3. Verify that the record has been added successfully, (but not yet committed).

   Choose a get request, remove the soapenv:Header element, and click the green arrow to get the record, e.g.

   

   The record has been added, but not yet committed. Because Adabas' isolation level is "Read Uncommitted" (also known as "dirty read"), a request from a non-conversational request will still return the added, but-yet-uncommitted, record.

4. Now backout the transaction.

   Choose a get request, and enter the following:

   • ConversationState to "End"
   • ConversationID to the value returned in the add response
   • TransactionState to "Backout"
   • TransactionID to the value returned in the add response
   

5. Now, if you re-run the request from Step 3, the item does not exist as the previous add has been backed out.