Download the Java JDBC *.jar library

Download the driver below and install it on the Java tool of your choice:

JDBC connect

...

Then configure a connection to the SQL Cloud database with the following configuration:

• Driver class: expert.marketplace.sqlc.jira.cloud.Driver

• URL: jdbc:jira-cloud:<port> (a random any available local port)

• Username: Must match the name of the Jira instance (https:<instance>.atlassian.net>net)

• Password: Must match the password on SQL Cloud - Query Server page (https://<instance><instance>.atlassian.net/plugins/servlet/ac/expert.marketplace.jira.cloud.sql/sqlc-server)

Prerequisites

• Minimum Java version 1.8

• For Java +17 these JVM parameters must be added to the command line:

--add-opens java.base/java.lang=ALL-UNNAMED

--add-opens java.base/java.math=ALL-UNNAMED

--add-opens java.base/java.util=ALL-UNNAMED

--add-opens java.base/java.util.concurrent=ALL-UNNAMED

--add-opens java.base/java.net=ALL-UNNAMED

--add-opens java.base/java.text=ALL-UNNAMED

How it works?

• Download the driver library above and install it on your favorited Java client tool.

• Configure the JDBC connection string

• The port parameter is any random TCP/IP port number available from your PC

• The username is the name of your Jira instance (see the picture below)

• Connect to the database. A new browser page will be opened to start up a SQL Cloud database instance (see the picture below)

• First time, your login will failed as the password is not known yet. It is available from the SQL Cloud - Query Server page. Click on the Show password link to see and/or change it.

• Open a JDBC connection: this will open a specific page from Jira.

...