Use the Database Task to execute database commands.



Purpose

The Database Task is used to execute database commands. Most processes rely on some information from database 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 this 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



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 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 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 value 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 map parameters 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.