From Bright Pattern Documentation
Jump to: navigation, search
• 5.2 • 5.3

DB Execute

The DB Execute workflow block provides a way for a workflow to execute SQL statements on a specified database. This block can be used to share data between workflows.


DB Execute workflow block


Conditional Exits

The DB Execute block may take one of the following conditional exits: Failed or No Data.

No Data

The SELECT statement successfully executed but did not return any records.

Failed

An error occurred during SQL statement execution. No error details are provided.


DB Execute Block conditional exits


Settings

Title text

Title Text is the name of the instance of the block. Enter a name in the text field and the new name of the block will appear in the flowchart.

DB Connection

DB connection represents the desired database connection. See the other settings for details.

Name

This is the name of the database connection. This name is shown in the DB Execute block connection selection menu. If no options are shown, click Manage DB connections to add new DB connections.

JDBC driver and connection string

Specify the JDBC driver and connection string that will be used to access this database. Note that templates are provided for some widely used DBMS systems.

Database username and password

Specify database access credentials.

The database connection selector allows the following operations:

  • Add a new connection (Add New button).
  • Edit and save the selected connection (Save button).
  • Delete the selected connection (Delete button).
  • Select the connection to be used in the DB Execute block (Select button).
  • Clear the connection selected for the DB Execute block (Select None button).
  • Close the window without changing the DB Execute block connection (Close button).

SQL Statement

This is the SQL statement to be executed. SQL statements may use workflow variables. For example: SELECT id, name FROM customers WHERE phone=’$(item.from)’

Recordset name

For SELECT statements, the name of the retrieved recordset should be specified. This allows workflows to have more than one recordset and to choose the recordset to iterate on.

  • The columns of the first retrieved record (if any) are stored in the workflow variables <recordset_name>.<column_name> (e.g., RS.id).
  • The number of returned records is stored in variable <recordset_name>.__count__ (e.g., RS.__count__). Note the double underscores in front and after count; they are used to reduce the chance of confusing the name of this variable with a column name in a recordset.
  • The number of records in the retrieved recordset is limited to 25.

The database connection is selected from a list of connections. Click the Manage DB connections button. The pop-up window will display all database connections defined in this workflow. For each connection, the following data should be defined:


Scenario Builder DB Execute scenario block settings


< Previous | Next >