Way to connect to my simple form application with postgres database, as by default we are on H2 db?

In the documentation you have given quite difficult approach to connect to any database. Please provide some easy way to do the same thing.

How to write dynamic query in bonita studio bdm?

I have five filter fields in my application home page (dashboard -> where I am showing all the records from h2 DB) now I want to filter the records on these fields basis.
It may require 31 (2^5 -1) queries, some are already provided as default queries.

Isn't there a way to write a dynamic query in "custom queries" or somewhere to get the desired result at UI?

Hash Algorithm for saved password in bonita database

Dear All
I want to retrieve the passwords that saved in "user" table in Bonita database. By the way, i think it has saved by hash algorithm. for example for default password (bpm) the "LcTkpvvquKf4KO+prsfXrQ==" value saved in database. My question is how can i retrieve the passwords?

Thanks in advance

Error Encountered When Running Processes in Bonita after Setting up a Database Connector

Hi Guys,

I have a database connector that executes an insert statement. I created a variable that will be used in insert statement and then I run the process. I also try insert statement with values without using the variable to see if it really inserts data but encountered the error below.

Error Encountered When Running Processes in Bonita

Hi Guys,

I have a database connector that executes an insert statement. Create a variable that will be used in insert statement and then I run the process but encountered the error below.

Insert records in database and output stored data in database (SQL Server)

Hi Guys,

Who knows the step by step and sample code in inserting data into database and how to view the content of database in the UI Designer. I have 2 tables header and details. Please help. Please send sample code or sample bos file. Version of bonita is 7.4.2 Community Edition. I'm using sql server as database.

Installation Mysql Database Bonita BPM platform

Following the official documentation and new to ubuntu / MySQL / Bonita I wish to setup a Bonita BPM platform.
I downloaded the Tomcat-bundle and I wish to setup MySQL Database.

But when looking at the official documentation, the Database must be configured, (it is writed literaly everywhere) there is no informations / guide for MySQL database.

Here is the only thing they say for MySQL :
Maximum packet size

insert values in postgres

I'm trying to insert values into a table in postgreSQL, I need to save the values of the variables that the user enters into the application.
I test with static values in this case the test is correct but when I put the variables the script does not work.
The script is the following:

`import groovy.sql.Sql;

import org.bonitasoft.engine.bpm.document.Document;
import org.bonitasoft.engine.bpm.document.DocumentValue;

Crear y guardar BDM Object en Groovy

Saludos, tengo un detalle.. estoy tratando de crear un bdm object por medio de groovy el cual se manda llamar en una operación de una tarea.

def noExpObj = new ConsecNoExp();


al final del groovy regreso la concatenación del objeto de la siguiente forma:

def res = noExpObj.getPrefijo() +"-" + noExpObj.getConsec().toString();

return res;

Database configuration with Oracle


I am trying to connect my oracle sql developer with Bonita. I have been following the steps according to this documentation: http://documentation.bonitasoft.com/database-configuration-2#oraclespec