Unable to access H2 Console with Fedora 34 and 35

Q&A
1

I've just installed a new Fedora 35 Sytem on my system and installed a fresh Bonita 2021.2-u0.

 

All seems OK but I can't open the h2 console. The first Time I click on "Browse Data (h2 console)", nothing appears. The second and next times  the browser try to open a page (http://Ip.Of.My.System:36799/frame.jsp?jsessionid=032c888692031e8fdd3550d8ebed4673) but I get a Connexion Error

 

I've try with Bonita 2021.1 and Its the same Problem.

 

I've nothing on Studio Logs nor on Engine Log

 

 

 

2

Hi,

Does your /etc/hosts file contains an alias for your host name ?
H2 use this configuration to find out how to start its webserver (stackoverflow related issue)

HTH
Romain

3

Adding an entry like this may fix the issue:

127.0.1.1 romain-laptop

Where romain-laptop is the static hostname retuned by the hostnamectl command.

4

Hi Romain,

Yes I have, my /etc/hosts:

 

10.174.8.51    thp051.bger.admin.ch thp051
127.0.0.1   localhost
::1         localhost

 

5

I've try a lot of Things without success :-(

The problem start with Fedora 34.With Fedora 33 its OK but after an update 33 -> 34 or a fresh install of Fedora 34, the access to H2 console don't works anymore.

 

When I click on H2 console, nothing appears, but when I close Bonita Sudio, the call to the H2 console seems to start cause Firefox open a tab but with a Connection Error.

 

Is it another way to access H2 database to load some Data?

6

You may try to launch the H2 console from outside the Studio:

  • Locate the h2-1.4.199.jar: Can be found in <STUDIO_INSTALL_DIR>/workspace/tomcat/setup/lib folder
  • Run java -jar h2-1.4.199.jar: It should open a web browser with a connection panel
  • Connect to your project h2 db BDM file:
    • JDBC Driver: org.h2.Driver
    • JDBC URL: jdbc:h2:file:<absolute_path_to_studio_dir>/workspace/My projet/h2_database/business_data.db;MVCC=TRUE;DB_CLOSE_ON_EXIT=TRUE;IGNORECASE=TRUE;AUTO_SERVER=TRUE;
    • Click on connect
7

I've try but it doesn't works! 

On Fedora 33, when I launch "java -jar h2-1.4.199.jar" a "H2 Console" window appears and immediately the browser open the URL I can see in the "h2 Console" window like that: "http://10.174.8.51:8082?key=238078468a4fa3b26e97d057dfaae4664863231575f3ede8ec5e7b5153969020"

On Fedora 35, when I launch "java -jar h2-1.4.199.jar" a "H2 Console" window appears but the browser do nothing immediately. When I close the "H2 console" window", the browser open the URL I had seen in the "H2 console" window but I receive a Connexion Error.

I can access the H2 database on Fedora 35 with this Method:

  • Launch "java -jar h2-1.4.199.jar"
  • Copy the URL in the "H2 console" window
  • Paste this URL in the Browser

 

8

Maybe you can try to ask for help on https://github.com/h2database/h2database

9

Hi Romain,

Good Idea but no I cant!

H2 database is working well outside of Bonita. The problem is only when Bonita try to launch H2 Console.

Best regards