KB : Connect to Jira H2 Database using a multi-platform database tool (example for DBeaver)

Owned by Avinash Bhagawati
Nov 21, 2023
3 min read

Purpose

This page describes the way how to configure and connect to the Jira database using an external multi-platform database tool that will help to display the database schema.

This particular runbook is related to the Linux version running on ARM processor. Windows steps might be similar and relatively easier to perform.

Preconditions:

Localhost version of Jira Server with sample data (can be hosted under Windows or Linux machine)

Runbook:

1. Download DBbeaver

DBeaver version for MacOS X is also available, so it can be used for remote connections

Navigate to https://dbeaver.io/download/ in order to download the latest version of the DBeaver client.

Select Linux ARM (zip without Java included) package and download it.

Move beaver to our local directory and extract it using tar:

root@ubuntu-linux-20-04-desktop:/home/parallels# mv dbeaver-ce-22.1.0-linux.gtk.aarch64-nojdk.tar.gz /home/parallels/ root@ubuntu-linux-20-04-desktop:/home/parallels# tar -zxvf dbeaver-ce-22.1.0-linux.gtk.aarch64-nojdk.tar.gz

2. Run DBbeaver

Execute the ./dbeaver executable file like the following:

root@ubuntu-linux-20-04-desktop:/home/parallels/dbeaver# ./dbeaver > Start DBeaver Standalone [org.jkiss.dbeaver.ui.app.standalone 22.1.0.202206051253] > Start Eclipse IDE UI Application [org.eclipse.ui.ide.application 1.4.300.v20220114-0859] > Start Eclipse Jobs Mechanism [org.eclipse.core.jobs 3.12.100.v20220120-1329] > Start Eclipse IDE UI [org.eclipse.ui.ide 3.18.500.v20220215-1304] ... > Start DBeaver Tip of the day [org.jkiss.dbeaver.ext.ui.tipoftheday 1.0.89.202206051253] 2022-06-23 12:18:37.427 - Open [https://dbeaver.io/product/version.xml] > Start DBeaver UI Editors - Connections [org.jkiss.dbeaver.ui.editors.connection 1.0.74.202206051253]

The following window should appear:

3. Configure H2 Driver

Select Database and next Driver Manager

Type H2 in the search bar and find all H2 drivers:

Edit the H2 Embedded and Download/Upgrade libraries:

Repeat it also for H2 Embedded V.2 and H2 Server

4. Setup DB connection

Obtain the variables from Jira configuration System => System info:

Please note that the database driver points to particular H2 driver that has to be user in order to connect into DB - in this case it is v1.x

Create New Connection from JDBC URL

Copy&Paste Database URL and select H2 Embedded (dedicated for 1.4.200) and click Proceed

Type the Authentication details:

Username: sa Password: <leave blank>

5. Connect to DB

Select Connect from the context menu and connect to DB schema

DB schema should appear as the following: