From Bright Pattern Documentation
Jump to: navigation, search
• 3.10 • 3.11 • 3.12 • 3.13 • 3.14 • 3.15 • 3.16 • 3.17 • 3.18

DB Execute

This block provides a way for a scenario to execute SQL statements on a specified database.

Note that this block can be used to share data between scenarios.


Conditional Exits

  • Failed – Error occurred during SQL statement execution. No error details are provided.
  • No Data – The SELECT statement successfully executed but did not return any records.


Settings

  • Title text - The name of the block instance.
  • DB Connection – The desired database connection. See below for details.
  • SQL Statement – The SQL statement to be executed. SQL statements may use scenario 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 scenarios 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 scenario variables <recordset_name>.<column_name>, for example, RS.id.
  • The number of returned records is stored in variable <recordset_name>.__count__, for example 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.)
  • To iterate through the recordset use the Get Next Record block.
  • 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 scenario. For each connection the following data should be defined:

  • Name – The name of the database connection. This name is shown in the DB Execute block connection selection menu.
  • 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 user name 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)

      < Previous | Next >
      < Previous | Next >