Contribution http://www.bonitasoft.org/exchange/ Bonita extensions en webmaster bonitasoft.com "MyTutorialProcessDiagram" - executable, revision 1.1 http://www.bonitasoft.org/exchange//extension_view.php?eid=291&rid=330#rev330 Revision: 1.1

About: This executable process diagram is created by following the "Introduction Tutorial for Process Definition / User Guidance Profile: Process Engineer"

and used as as starting point for the "Introduction Tutorial for
Application Design / User Guidance Profile: Application Developer"

(Bonita Open Solution Version 5.6.1)

Changes: This executable process diagram is created by following the "Introduction Tutorial for Process Definition / User Guidance Profile: Process Engineer"

and used as as starting point for the "Introduction Tutorial for
Application Design / User Guidance Profile: Application Developer"

(Bonita Open Solution Version 5.6.1)

]]>
Mickey
"MyTutorialProcessDiagram", revision 1.0 http://www.bonitasoft.org/exchange//extension_view.php?eid=290&rid=329#rev329 Revision: 1.0

About: This simple process diagram is used with the "Introduction Tutorial for
Process Definition / User Guidance Profile: Process Engineer"
(Bonita Open Solution Version 5.6.1)

Changes: This simple process diagram is created by following the "Introduction Tutorial for
Process Design / User Guidance Profile: Business Analyst"

and used as as starting point for the "Introduction Tutorial for
Process Definition / User Guidance Profile: Process Engineer"

(Bonita Open Solution Version 5.6.1)

]]>
Mickey
Pupulate a select box from database using groovy, revision 1.0 http://www.bonitasoft.org/exchange//extension_view.php?eid=288&rid=328#rev328 Revision: 1.0

About: This process shows how to get the available values from a database using a groovy script.

Changes: First release developed with BOS 5.6.2

]]>
bouquetf
Stored Procedure, revision 1.0 http://www.bonitasoft.org/exchange//extension_view.php?eid=287&rid=327#rev327 Revision: 1.0

About: 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

Changes: 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

]]>
matthieu.chaffotte
EJB Connector, revision 1.0.0 http://www.bonitasoft.org/exchange//extension_view.php?eid=286&rid=326#rev326 Revision: 1.0.0

About: This connector allows to invoke EJB services (v3.0) from Bonita processes. It is simple to configure, you just have to indicate JNDI name of EJB and the method name to invoke.

Constraints:
- At the moment only works for EJB on the same server that Bonita Engine (use localhost for lookups)
- Requires that the process is deployed in JBoss (or another application server), or add the ejb client library (provided by app server) to invoke the EJB.
- Also requires the jar with the EJB client classes (generated with maven or ant or manually) and DTO

Changes: Tested with 5.3, 5.4 y 5.5

]]>
rdiegoc
Use a java.util.Map to fill in combobox values, revision 1.0 http://www.bonitasoft.org/exchange//extension_view.php?eid=285&rid=325#rev325 Revision: 1.0

About: This is a simple process example that explains how to fill in combobox values from a Map.

By using a Map, values and labels may be diffrent in the generated HTML