Use the Database Task to execute database commands.



Purpose

The Database Task is used to execute database commands. Most applications and processes need database connectivity to execute jobs or complete process flows. Business processes may often require to Select, Insert, Update or Delete data from database and pass such values to other nodes to complete process flows. Process Designer provides such functionality using Database Node tasks.  


Database Node Configuration Properties:

Database Node Configuration settings panel has 3 tabs to define properties.

  1. General

General Tab contains general information such as title, task id etc.

  1. Business Object

Used to configure and map the Business Object for input and output for the node.

  1. Database Parameter




All Settings in Database Parameter Tab are shown below:


Property

Mandatory

Default

Description

Connection type

Y


To define the type of database connection, there are 2 types: JNDI and JDBC.

Command Type

Y


To define the type of database command used. There are 4 options are as following: Select, Insert, Update and Delete.

Command

Y


To define the SQL command to be executed in database.


Java Naming and Directory Interface (JNDI) is a directory service that allows Java software clients to connect to database via a name. When "Connection type" is selected as "JNDI", user must enter JNDI Name.


Property

Mandatory

Default

Description

JNDI Name

Y


Name of JNDI for database connection.


Java Database Connectivity (JDBC) is standard application programming interface, which defines how a client may access a database. It is Java based data access technology and used for Java database connectivity. When "JDBC" is selected as "Connection type", user must also enter details for JDBC.


Property

Mandatory

Default

Description

JDBC Database Driver

Y


The class name of the database driver for database connection.

JDBC URL

Y


To set the address of database for connecting database.

JDBC Username

Y


Username for Authentication.

JDBC Password

Y


Password for Authentication.


In Database Parameter Tab, "Open Mapping Parameter" button is used to set mapping parameter of Database Node task. When click Open Mapping Parameter button, the system will redirect user to Mapping Parameter screen and then user can click Mapping Parameter Input line or Mapping Parameter Output line to mapping parameter for this Database Task.


Note: User must click "Save Panel" to save all configuration changes.