Uploaded image for project: 'Red Hat Process Automation Manager'
  1. Red Hat Process Automation Manager
  2. RHPAM-3728

Create Native SQL command to operate database to execute functions / SQL queries and stores in the execution results

XMLWordPrintable

    • Icon: Task Task
    • Resolution: Done
    • Icon: Major Major
    • 7.11.1.GA
    • None
    • None
    • None
    • 2021 Week 22-24 (from May 31), 2021 Week 25-27 (from Jun 21)

      create the command

      org.jbpm.executor.commands.ExecuteSQLQueryCommand
      

      which is reocurrent. It executes SQL native queries and stores the results in a comma separated format.

      Parameter Type Description
      SingleRun String true or false if it should triggered once or more times
      EmfName String name of the persistence unit to be used to run the query
      businessKey String associate businesskey to the request info
      SQL Stirng native sql query to be executed. Parameters must be preceded by the symbol ":"
      ParametersList String comma separated list of the parameters to be used in the sql and provided in the command context. e.g
      ParametersList=paramKey,paramId
       
      will be two different in a SQL like : SELECT * FROM RequestInfo WHERE id = :paramId AND businessKey = :paramKey
       
      context will provided two different fields
      paramKey=key value
      paramId=id value
      <param> String value of the param provided in the parametersList bound to the native SQL

              elguardian@gmail.com Enrique González Martínez (Inactive)
              elguardian@gmail.com Enrique González Martínez (Inactive)
              Antonio Fernandez Alhambra Antonio Fernandez Alhambra (Inactive)
              Antonio Fernandez Alhambra Antonio Fernandez Alhambra (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Created:
                Updated:
                Resolved: