...

Download the .jar library

JDBC connect string

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

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

• Password: Must match the password on SQL Cloud - Query Server page (https://<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

...

Driver Class: expert.marketplace.jira.cloud.Driver

...

URL: jdbc:jira-cloud:<port>:<instance>

...

Username: <NO Jira username>

...

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.

...