Start-Transaction
The Start-Transaction webject creates a new transaction. Following Start-Transaction, all database modifications made by webjects with the same SESSION_ID parameter value as the Start_Transaction webject are part of the same transaction.
A transaction remains open until either a Commit-Transaction or Rollback-Transaction webject is invoked with the same SESSION_ID parameter. In addition, the Rollback-Transaction webject can be used to roll the transaction back explicitly. More than one transaction can be created within a session, and the transactions can be nested.
Syntax
<ie:webject name="Start-Transaction" type="ACT">
<ie:param name="AUTHORIZATION"
data="$(@SERVER[]authorization[0])"/>
<ie:param name="CONNECTION_ATTEMPTS" data="attempts"/>
<ie:param name="CONNECTION_ATTEMPT_INTERVAL" data="interval"/>
<ie:param name="DBUSER" data="username"/>
<ie:param name="INSTANCE" data="appl_name"/>
<ie:param name="PASSWD" data="password"/>
<ie:param name="SESSION_ID" data="$(session[]session_id[])"/>
</ie:webject>
<ie:param name="AUTHORIZATION"
data="$(@SERVER[]authorization[0])"/>
<ie:param name="CONNECTION_ATTEMPTS" data="attempts"/>
<ie:param name="CONNECTION_ATTEMPT_INTERVAL" data="interval"/>
<ie:param name="DBUSER" data="username"/>
<ie:param name="INSTANCE" data="appl_name"/>
<ie:param name="PASSWD" data="password"/>
<ie:param name="SESSION_ID" data="$(session[]session_id[])"/>
</ie:webject>
Parameters
|
Required
|
Interdependent
|
Optional
|
|---|---|---|
|
INSTANCE
|
AUTHORIZATION
|
CONNECTION_ATTEMPTS
|
|
SESSION_ID
|
DBUSER
|
CONNECTION_ATTEMPT_INTERVAL
|
|
PASSWD
|
 |
If a parameter is listed in the table but is not defined below, then it has a common parameter definition. For descriptions of those parameters, see Common Webject Parameters section in Adapter Webjects Overview.
|
SESSION_ID
The identifier of the session in which the webject is executed.
This parameter is required.