Release notes
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