pub.db:clearTransaction
WmDB. Clears the transactional state within a database connection. As an alternative to this service, consider using the services provided with the webMethods Adapter for JDBC.
Input Parameters
You may specify the connection parameters in one of the following ways:  $dbAlias$dbURL, $dbUser, $dbPass, $dbDriver $dbConnection |
$dbAlias | String Optional. Alias of the database connection on which you want to clear the transactional state. The alias is passed automatically if the database is connected. |
$dbURL | String Optional. JDBC URL that identifies the database resource. |
$dbUser | String Optional. User name to use to log into the database. |
$dbPass | String Optional. Password for the user. |
$dbDriver | String Optional. Name of the JDBC driver to use. |
$dbConnection | com.wm.app.b2b.server.DBConnection Optional. Connection object returned by pub.db:connect. |
Output Parameters
$dbMessage | String A message indicating the success or failure of the operation. |
Usage Notes
On some databases, exceptional conditions within transactions will automatically abort the entire transaction. When this happens, the standard commit/rollback operations are meaningless because there is no current transaction. If this occurs, use the clearTransaction service to clear the transactional state and prepare for a new transaction. You should only use this service if you have begun a transaction and cannot end it with a standard commit or rollback.
The clearTransaction service does not involve a database operation; it is entirely internal to the webMethods Integration Server.
