...

Download the Java JDBC *.jar library

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

Minimum Java version 1.8.

For Java +17 these JVM must be added:

--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

...

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>:<instance>

• Username: <NO Jira username>

• Password: <NO Jira password><port> (any available local 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