Studio BDM in MySQL

Hello All,

I changed the workspace/tomcat/setup/database.properties file as follows:

bdm.db.vendor=mysql
bdm.db.server.name=localhost
bdm.db.server.port=3306
bdm.db.database.name=bonita_business
bdm.db.user=bonita
bdm.db.password=bonita

However, when I modify and reset the BDM it isn’t deployed to database, it remains empty, with no tables. The tomcat log only contains this:

2017-07-30 18:42:55.932 -0400 INFO: java.sql.DatabaseMetaData HHH000262: Table not found: CINVOICE
2017-07-30 18:42:55.933 -0400 INFO: java.sql.DatabaseMetaData HHH000262: Table not found: CINVOICELINE
2017-07-30 18:42:55.934 -0400 INFO: java.sql.DatabaseMetaData HHH000262: Table not found: CINVOICELINEBATCH
2017-07-30 18:42:55.935 -0400 INFO: java.sql.DatabaseMetaData HHH000262: Table not found: CUSTOMER
2017-07-30 18:42:55.936 -0400 INFO: java.sql.DatabaseMetaData HHH000262: Table not found: CUSTOMERRESPONSE
2017-07-30 18:42:55.937 -0400 INFO: java.sql.DatabaseMetaData HHH000262: Table not found: GEOCOUNTY
2017-07-30 18:42:55.937 -0400 INFO: java.sql.DatabaseMetaData HHH000262: Table not found: GEOSTATE
2017-07-30 18:42:55.938 -0400 INFO: java.sql.DatabaseMetaData HHH000262: Table not found: ISSUE
2017-07-30 18:42:55.939 -0400 INFO: java.sql.DatabaseMetaData HHH000262: Table not found: ISSUE_RESPONSES
2017-07-30 18:42:55.940 -0400 INFO: java.sql.DatabaseMetaData HHH000262: Table not found: PRODUCTS
2017-07-30 18:42:55.940 -0400 INFO: java.sql.DatabaseMetaData HHH000262: Table not found: RESPONSE
2017-07-30 18:42:55.941 -0400 INFO: java.sql.DatabaseMetaData HHH000262: Table not found: SINVOICE
2017-07-30 18:42:55.942 -0400 INFO: java.sql.DatabaseMetaData HHH000262: Table not found: SINVOICELINES
2017-07-30 18:42:55.944 -0400 INFO: java.sql.DatabaseMetaData HHH000262: Table not found: SINVOICELINESBATCH
2017-07-30 18:42:55.944 -0400 INFO: java.sql.DatabaseMetaData HHH000262: Table not found: SPO

Any ideas?

Thank you.

Did the BDM still being deployed to h2 database? You can check that using “Browse data (h2 console)…” menu.

Did you take a look at Studio log file?

Antoine,

Yes, the tables were deployed to the H2 database.

There is no relevant message in the Studio log:

!ENTRY org.bonitasoft.studio.businessobject 1 0 2017-07-30 18:42:44.454
!MESSAGE Deploying Business Data Model...

It seems Studio is not regarding the database.properties file.

Thank you.

It seems that two database.properties exists in Studio folder:
./workspace/tomcat/setup/database.properties
./plugins/org.bonitasoft.studio.console.libs_7.5.2.201707041124/tomcat/setup/database.properties

So you might want to try to edit the second one.

Also I recommend to try to edit them while Studio is closed and then launch the Studio to test.

Also note that this is not an “expected” usage of the Studio so not sure it’s actually doable.

Antoine,

I modified the file under the plugins directory, but there’s no change.

I made a test by modifying the Bonita BPM database in this file, and I get a login error launching processes and deploying the BDM. I conclude this file is the one Studio takes into account. The other file, under workspace, is not used by Studio (I can put in anything there and Studio will keep working).

It seems that by design, Studio will use the same database for the engine and the BDM.

Cheers.

More Tests:

Studio only regards the bdm.db.database.name parameter.

Cheers.

I had the same error, please tell me if u solve it

As I said in my previous comment it is not recommended nor supported to switch to a different database the Bonita runtime embedded in Bonita Studio.

If you need to configure a Bonita runtime to use MySQL I recommend you install it using the Tomcat bundle or the Docker image.

hello antoine
I work with pinerodanie
we are using bonita community 7.8.0, postgres 9.3 and Java 8
it all works in the studio but once we compile and create the .bar, export the BDM
we install the process correctly in the bonita tomcat but when execute it only shows the first form and the process is shown as failed
where could be the error?
thanks

Based on your description I think your issue is not related to the configuration of the Studio.

Would you mind creating a new question for your issue? This will make the question easier to find for other users that might have the same issue.

Just a quick first guess, if process instantiation form is display but the process won’t start when the form is submitted it is usually related to the data sent that don’t match the process contract. You can check the response receive from Bonita using web browser console and also took a look at Engine log file.