The DB Policy helps to execute simple queries like insert, update, delete and select records from database.
Configuration
The properties that have to be configured to use the policy are described below.
|
Property |
Description |
||||||||||
|
DataBase |
This property determines the vendor of the database. Supported database vendor names are present in the drop-down list. |
||||||||||
|
Driver |
The Driver class name that should be used to connect to the database. |
||||||||||
|
URL |
The location where the required database is running. |
||||||||||
|
User Name |
The username that should be used to connect to the database. |
||||||||||
|
Password |
The password for the specified user. |
||||||||||
|
Query Type |
The SQL query type to be executed. The user can select one of the SQL query types from SELECT, UPDATE, INSERT and DELETE.
|
||||||||||
|
SQL Statement |
This property determines the queries that have to be executed. |
The DB Policy helps in execute simple queries like insert, update, delete or select records from the database.