Network configuration to access Bonita_Journal db after Bonita 7.3.x ?

Q&A
1

Hi guys,

Before v7.4.x, I used to connect to both Bonita_Journal and Business_Data for my dev environement.
What I used to do :

  • Go to C:\BonitaBPMCommunity-7.4.2\workspace\tomcat\server\lib\bonita
  • Double click on h2-xxx.jar
  • On the console, connect to jdbc:h2:tcp://localhost:9091/business_data.db;MVCC=TRUE;DB_CLOSE_ON_EXIT=TRUE;IGNORECASE=TRUE;
    or jdbc:h2:tcp://localhost:9091/bonita_journal.db;MVCC=TRUE;DB_CLOSE_ON_EXIT=FLASE;IGNORECASE=TRUE;

In 7.4.3, you can access Business_Data db directly from menu Dev > BDM > H2 Console.
But I cannot connect to the Bonita_Journal anymore. In the launched console, the address is jdbc:h2:file:C:\BonitaBPMCommunity-7.4.2\workspace\default\h2_database/business_data.db

But when I disconnect I cannot reconnect anymore.

Any idea ?

2

Works for me…

3

I can access bonita-journal using the same path as for business_data.db:

jdbc:h2:file:C:\BonitaBPMCommunity-7.4.3\workspace\default\h2_database/bonita_journal.db;MVCC=TRUE;
DB_CLOSE_ON_EXIT=FALSE;IGNORECASE=TRUE;AUTO_SERVER=TRUE;

4

Ok, I think it might be a proxy’s problem, but not really sure. But anyway, I find a way to connect :slight_smile:

When I use the studio to access DBM console, it uses a different port every time. When I disconnect and try to reconnect to the Bonita_Journal, I think an error occurs with the JSessionId token or with my proxy.

So now what works is :

  • Go to C:\BonitaBPMCommunity-7.4.2\workspace\tomcat\server\lib\bonita
  • Double click on h2-xxx.jar
  • Enter jdbc:h2:file:C:\BonitaBPMCommunity-7.4.3\workspace\default\h2_database\bonita_journal.db;MVCC=TRUE;DB_CLOSE_ON_EXIT=FALSE;IGNORECASE=TRUE;AUTO_SERVER=TRUE;

Before 7.4, I used “jdbc:h2:tcp://localhost:9091…” and now I have to use “jdbc:h2:file:C:\BonitaBPMCommunity-7.4.3.…”

Thank you guys

5

Just a follow up because I never managed to make it work :

It seems to be a problem with my company’s network. None of our Studios can access the BDM H2 console.

What I understand :

  • H2 console is configured to allow only Localhost access
  • When I try to open the console from the menu Dev > BDM > H2 Console, the Studio tries to open the URL, but gives the exception : Exception in thread “main” org.h2.jdbc.JdbcSQLException: Connection is broken: “java.net.SocketTimeoutException: connect timed out: 10.82.xxx.yy:64586” [90067-175]
  • 10.82.xxx.yy is my current IP, but it’s not localhost
  • I don’t know why but the system cannot identify that IP address as a localhost one, so H2 refuses the connection

The same thing happens when I open the Console by clicking on the Jar (C:\BonitaBPMSubscription-7.5.4\workspace\tomcat\server\lib\bonita\h2-1.3.175.jar)

The console only opens when I’m completly disconnected from network (no cable, no wifi connection)

6

Works for me…