Studio BDM in MySQL

1
0
-1

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.

Comments

Submitted by antoine.mottier on Mon, 07/31/2017 - 08:36

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?

Submitted by edo_2 on Mon, 07/31/2017 - 14:50

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.

Submitted by antoine.mottier on Mon, 07/31/2017 - 14:55

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.

Submitted by edo_2 on Mon, 07/31/2017 - 20:27

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.

Submitted by edo_2 on Mon, 07/31/2017 - 20:45

More Tests:

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

Cheers.

No answers yet.
Notifications