CreateProcessInstancesByQuery

processdefinition

This parameter determines the process definition of which one or many instances should be started.

Onboarding

connectionParameter

This parameter specifies the connection to the SQL Server (Database).
It consists of the following 3 parts

• Connection URL (includes host, port and name of DB schema)

• Username

• Password

and is separated by a plus (+).

jdbc:sqlserver://localhost:1433;databaseName=test+db_user+qwerty!1234

sqlFile

This determines the path to the SQL file, which should be used for starting the instance.

The file must be placed in the Resource folder.
Should it be placed in the ROOT folder it's enough to specify the file name & extension.
Otherwise, a path may be specified.

Example (ROOT-folder):
query.sql

Example (Sub-folder):
subfolder/query.sql

limit

5

This parameter determines the maximum number of instances that can be started within a single passing of this timer. If nothing is transferred here, the limit is loaded from the CreateProcessInstancesByHandler.

10

Timer name

Create Process Improvement Flow

Webservice name Mandatory

ProcessInstanceManager

Webservice method Mandatory

createProcessInstancesByHandler

Parameter

HANDLER_CLASSPATH,PROCESS_DEFINITION#CONNECTION_PARAMETER#SQL_FILE#LIMIT

com.dooris.bpm.actionhandler.CreateProcessInstancesByQuery,MY_WORKFLOW#jdbc:sqlserver://HOST:PORT;databaseName=DB_SCHEMA+USERNAME+PASSWORD#SQL_FILE#LIMIT

Time to start

1s

Starting time

17/07/2024 12:44

Interval

1

Max. runs Mandatory

5