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

Submitted by p.clainchard on Fri, 03/24/2017 - 16:45
1
0
-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 :

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 ?

Comments

Submitted by Sean McP on Fri, 03/24/2017 - 21:38

Works for me...

Permalink
4 answers

Submitted by p.clainchard on Tue, 03/28/2017 - 10:54
1
0
-1
This one is the BEST answer!

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

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

Submitted by Sean McP on Fri, 03/24/2017 - 21:38
1
+1
-1

Works for me...

Submitted by p.clainchard on Mon, 02/26/2018 - 10:03
1
0
-1

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)

Submitted by thomas.allweyer on Mon, 03/27/2017 - 20:21
1
0
-1

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;

Notifications