How can I access the BPM H2 Database in Bonita Studio 7.10.0 (bonita_journal.db)?

Q&A
1

Hello,

It is very easy to access the BDM H2 Database through Bonita Studio: Development -> Business Data Model -> Browse data. When I was using Bonita Studio 7.8.2 to design processes, I discovered through this forum that you can read/open the bonita_journal.db file through the same H2 Console to view the underlying process/user/archive/etc tables. This is extremely helpful for debugging and understanding the way Bonita works.

I recently updated my Bonita Studio to version 7.10.0, and when I try to access bonita_journal.db, (located in the BonitaStudioSubscription-7.10.0\workspace\MyProjectName\h2_database), there are zero tables shown. My processes are deployed and working, so I'm not sure what the issue could be.

 

Thanks!

1 Like
2

Actually if you are talking about bonita_journal_db file, it is not possible to see it in Bonita Studio. Only the business_data_db file can be displayed with the H2 console there.

In order to access bonita_journal.db, I suggest you use DBeaver and connect to the embedded H2 database following the path :  

[Path to Studio]/BonitaStudioSubscription-7.10.0.app/Contents/Eclipse/workspace\MyProjectName/h2_database/bonita_journal.db;DB_CLOSE_ON_EXIT=FALSE;IGNORECASE=TRUE;AUTO_SERVER=TRUE;

with username sa and no password, as you can see on the screenshot below :

1511×724 172 KB

I hope it will help you.

1 Like
3

Hi Romeo,

I can't reproduce your issue. When I go to Bonita Studio with Bonita Subscription 7.10.0, I click right on Business Data Model, select "Show in system explorer" and here is what I get:

File explorer
File explorer1044×375 66.8 KB

if I open the file I can see the tables. 

Can you please try again and tell me what you get? Thanks

1 Like
4

Are you just opening the file by using it as your JDBC URL in the H2 Console (web browser)? This is how I used to do it. Maybe this is an issue with my setup somehow.

1 Like