- Overview
- Cryptography
- Database
- Java
- Python
- WebAPI
Start Transaction
UiPath.Database.Activities.DatabaseTransaction
Connects to a database and features a Sequence which can perform multiple transactions with the database.
DatabaseConnection variable, providing a scope for
Database activities.
If Use transaction is set to True, the contained operations are executed in a single transaction, and applied at the end if none of the them failed.
If Use Transaction is set to False, all operations are committed individually.
When this activity ends, the connection to the database is closed.
Designer panel
- Configure Connection... - Select an existing database connection or add a new one using the Connection Wizard.
- Add the activities you want to execute in the activity card.
Properties panel
Common
-
Continue on error - Specifies if the automation should continue even when the activity throws an error. This field only supports Boolean values (True, False). The default value is False. As a result, if the field is blank and an error is thrown, the execution of the project stops. If the value is set to True, the execution of the project continues regardless of any error.
Note: If this activity is included in Try Catch and the value of the Continue on error property is True, no error is caught when the project is executed. - DisplayName - The display
name of the activity. This field supports only
Stringvariables.
Connection Configuration
- Connection string - The
connection string used to establish a database connection. This field supports
only
Stringvariables. - Existing connection - The
DatabaseConnectionvariable you want to use for connecting to a database. If such a connection is provided, theConnectionStringandSecureConnectionStringproperties are ignored. Can be retrieved from other Database activities that have the Database connection field in the Output property section. This field supports onlyDatabaseConnectionvariables. - Provider name - The name
of the database provider used to access the database. This field supports only
Stringvariables. - Secure connection string -
The connection string used to establish a database connection as Secure String.
This field supports only
SecureStringvariables.
Misc
- Private - If selected, the values of variables and arguments are no longer logged at Verbose level.
- Use transaction - Specifies if the database operations within this activity should be wrapped in a database transaction.
Output
- Database connection - The
database connection variable returned by the activity. This can be subsequently
used for other database operations. This field supports only
DatabaseConnectionvariables.
