Stored Procedure

With this set of connectors, you will be able to execute a stored procedure or function, on your favorite database vendor e.g. MySQL.

Dependencies: The set of connectors just needs the .jar which contains your database driver.

How to use it: - First of all, configure the database access

  • Then name your procedure or function,
  • in the table of parameters, -> if your procedure or function returns a result, enter "RETURN" in the first row of the Type column (case sensitive)

    -> if your procedure or function contains parameters, enter the type (IN, OUT, IN_OUT), the SQL type and the value (only for IN and IN_OUT)

Possible values for type: RETURN, IN, OUT, IN_OUT Possible values for SQL type: INTEGER, VARCHAR, CHAR, BOOLEAN, DATE, DECIMAL, DOUBLE, FLOAT, NCHAR, TIMESTAMP, BIGINT, BIT, LONGNVARCHAR, LONGVARCHAR, NUMERIC, REAL, SMALLINT, SQLXML, TIME, TINYINT

Example 1: procedure name: add parameters type SQL type Value RETURN INTEGER IN INTEGER 5 IN INTEGER 6

Example 2: procedure name: dup parameters type SQL type Value IN INTEGER 5 OUT INTEGER OUT VARCHAR

Category: 
Licence: 
GPL v2

Issues

Downloads

Total downloads: 635
Version BonitaBPM Version Post date Download Link
1.0 5.x 2012-Jan-31 Download
635 downloads
Release note
Downloads: 
49
Notifications