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.

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.

$dbMessage

String A message indicating the success or failure of the operation.

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.