Integration Server 10.5 | Built-In Services Reference Guide | Db Folder | Summary of Elements in this Folder | pub.db:clearTransaction
 
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.