Disconnect Db Version 9 (Java)

Action group: Databases

Description

Closes the connection to the database. 

Action icon

Settings of parameters

PropertyDescriptionTypeFilling exampleMandatory field
Parameters
DB contextConnection context to the selected databaseRobin.DbContextDatabase contextYes

Special conditions of use

None.

Example of use

Task

Connect to MsSqlServer database and run the query and close the connection. 

SELECT * FROM Table1
ORDER BY id ASC;

Solution

Use the actions "Connect Standard Db", "Execute Sql Statement", "Disconnect Db". 

Implementation

  1. Assemble a robot scheme consisting of actions:


  2. Set the parameters for the "Connect Standard Db" action (Instructions on how to connect to Microsoft SQL Server from Robin Studio).


  3. Set the parameters for the "Execute Sql Statement" action. 


  4. Set the parameters for the "Disconnect Db" action. 


  5. Click on the "Start" button in the top panel. 

Result

The program robot completed successfully. The request to the database has been executed. Connection is closed.