# Network configuration to access Bonita\_Journal db after Bonita 7.3.x ?

**URL:** <https://community.ofelia.com/t/network-configuration-to-access-bonita-journal-db-after-bonita-7-3-x/8326>\
**Category:** Q&A\
**Created:** [24 March 2017 15:45 UTC](https://community.ofelia.com/t/network-configuration-to-access-bonita-journal-db-after-bonita-7-3-x/8326 "2017-03-24T15:45:31Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![p.clainchard](https://avatars.discourse-cdn.com/v4/letter/p/e68b1a/32.png) [@p.clainchard](https://community.ofelia.com/u/p.clainchard)\
**Post date:** [24 March 2017 15:45 UTC](https://community.ofelia.com/t/network-configuration-to-access-bonita-journal-db-after-bonita-7-3-x/8326/1 "2017-03-24T15:45:31Z")

</div>

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 ?

---

<div class="post-metadata">

**Author:** ![Sean\_McP](https://dub1.discourse-cdn.com/flex013/user_avatar/community.ofelia.com/sean_mcp/32/932_2.png) [@Sean\_McP](https://community.ofelia.com/u/Sean_McP)\
**Post date:** [24 March 2017 20:38 UTC](https://community.ofelia.com/t/network-configuration-to-access-bonita-journal-db-after-bonita-7-3-x/8326/2 "2017-03-24T20:38:44Z")

</div>

Works for me…

---

<div class="post-metadata">

**Author:** ![thomas.allweyer](https://dub1.discourse-cdn.com/flex013/user_avatar/community.ofelia.com/thomas.allweyer/32/891_2.png) [@thomas.allweyer](https://community.ofelia.com/u/thomas.allweyer)\
**Post date:** [27 March 2017 18:21 UTC](https://community.ofelia.com/t/network-configuration-to-access-bonita-journal-db-after-bonita-7-3-x/8326/3 "2017-03-27T18:21:47Z")

</div>

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;

---

<div class="post-metadata">

**Author:** ![p.clainchard](https://avatars.discourse-cdn.com/v4/letter/p/e68b1a/32.png) [@p.clainchard](https://community.ofelia.com/u/p.clainchard)\
**Post date:** [28 March 2017 08:54 UTC](https://community.ofelia.com/t/network-configuration-to-access-bonita-journal-db-after-bonita-7-3-x/8326/4 "2017-03-28T08:54:03Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![p.clainchard](https://avatars.discourse-cdn.com/v4/letter/p/e68b1a/32.png) [@p.clainchard](https://community.ofelia.com/u/p.clainchard)\
**Post date:** [26 February 2018 09:03 UTC](https://community.ofelia.com/t/network-configuration-to-access-bonita-journal-db-after-bonita-7-3-x/8326/5 "2018-02-26T09:03:33Z")

</div>

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)

---

<div class="post-metadata">

**Author:** ![Sean\_McP](https://dub1.discourse-cdn.com/flex013/user_avatar/community.ofelia.com/sean_mcp/32/932_2.png) [@Sean\_McP](https://community.ofelia.com/u/Sean_McP)\
**Post date:** [24 March 2017 20:38 UTC](https://community.ofelia.com/t/network-configuration-to-access-bonita-journal-db-after-bonita-7-3-x/8326/6 "2017-03-24T20:38:23Z")

</div>

Works for me…