DB

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.

Query Type	Description
INSERT	Inserts/adds data into the database table
UPDATE	Modifies existing data in the database table
DELETE	Deletes data from the database table
SELECT	Retrieves data from the database table

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.