Disconnect
AutomatR.OracleDB.Database.Disconnect
The "Disconnect" activity in AutomatR allows you to gracefully disconnect from a specified Oracle database. This is a crucial step after completing database operations to release resources and ensure proper cleanup. The activity requires an OracleConnection variable to be provided as input, representing the connection to be disconnected.
Properties
| Name | Description |
|---|---|
| Input | |
| Connection | Specifies the OracleConnection variable representing the database connection that needs to be disconnected. This variable should be obtained from a previous "Connect" activity or a similar source. |
| Misc | |
| Display Name | Provides a customizable name for the activity displayed in the workflow. The display name enhances clarity and organization within the automation project. String variables containing the desired display name. |
| Optional | |
| Delay | Specifies the amount of time (in seconds) to wait before executing the "Disconnect" activity. This can be useful for handling synchronization issues. Integer variables containing the delay duration. Ex.: If the amount of time is 1000 milliseconds or 1 sec, i.e., 1. |
How to use:
- Drag and drop the "Disconnect" activity onto the workflow.
- Configure the properties by specifying the OracleConnection variable obtained from a previous "Connect" activity.
- Optionally, configure the delay.
- Execute the workflow to disconnect from the specified Oracle database.
Note:
- Ensure that the "Disconnect" activity is used to release resources and properly terminate the connection after completing database operations.
- Provide the OracleConnection variable obtained from a previous "Connect" activity to disconnect from the correct database.
Example: Consider an example where the "Disconnect" activity is used to gracefully disconnect from an Oracle database:
Disconnect:
Connection: oracleConnectionVariable
Delay: 2
In this example, the "Disconnect" activity is configured with the OracleConnection variable "oracleConnectionVariable," and a delay of 2 seconds is added before the disconnection for synchronization purposes.