#h2

How to configure Studio H2 databases case sensitive behavior to get an identical behavior between H2 and PostgreSQL?

Hi,

We are running into case-sensitivity issues due to the discrepancies between the H2 database used by the Studio and our postgres database in QA and production environment. These issues are not detected in the Studio by our developers because the H2 datasources configuration contains a IGNORECASE=TRUE;

From what I understand, H2 is configured to be case insensitive because we want the search in the Portal to be case insensitive. So all type of RDBMS (PostgreSQL, SQL Server, Oracle) must be configured (or at least bonita schema) to be case insensitive.

Empty set After Bonita REST api is used

ok as requested i create a new Question

Here we go. Now it looks like this , i have written the API using the maven REST api extension i used it like this

b.png

Now the API converted to JSON here and the JSON looks like this :

Saving REST API JSON to database

How do you save JSON Data to Database? (H2 Database) ? I have a REST API i used which was actually a REST API extension now i want to save the value from the input widget in the database. How can i Do that?

Group_concat in a Custom query

I'm having a difficulty regarding creating a custom query in my development environment, I did the following query:

Insert user in H2 by UI Designer

I need to create a user registration system in BonitaSoft, I know that it is possible to add Organisations and user in the studio organization manager of BonitaSoft Studio, however I need to be added in H2 by the UI Designer interface, how can I do this? I dont know how to configure a connector to add data in H2, is there any configuration pattern? Any hint will be welcome, I have never worked directly with H2 only with BDM for this reason I do not know how to configure a connector to access the H2

Notifications