История страницы
...
More details can be found here:Instruction on Connecting to Microsoft SQL Server from Robin Studio
Action icon
Parameters
Input parameters
...
- Assemble a robot scheme with the actions:
- Set the "Connect Custom Db" action parameters.
Transaction isolation level - isolation level of access to the database during the execution of transactions. Dropdown list:- no transactions
- read uncommitted allowed - it will be allowed to read data that is modified by some other transaction.
- read committed - the robot will only be allowed to read the recorded entries.
- repeatable read - the robot will only be allowed to read the recorded entries. The data that the robot is currently reading cannot be changed by another entity until the robot's transaction is complete.
- serializable - the robot will only be allowed to read the recorded entries. The data that the robot is currently reading cannot be changed and/or read by another entity until the robot's transaction is complete.
- Specify the database login and password.
In the "DB server URL" specify the URL of connection to the required database. All additional parameters must be specified in the server URL.
When using a custom connection, the driver for the database must be downloaded. The driver file must be located on the same machine where the program robot is running. This driver will be used to connect the robot to the database.
In "The driver classpath for the specified database" field set the name of the driver class. You can find it on the Internet, i.e. look up the driver name for the database you are using. Accordingly, for each type of database the driver class name will be different.
In "The driver classpath for the specified database" field, specify the path to the driver file that will be used to make the connection. For example:
Value in the "Timeout" field is measured in seconds.
- Set the "Execute statement" action parameters.
- Click "Start" in the top panel.
...
Обзор
Инструменты контента