Download the Java JDBC *.jar library
Download the driver below and install it on the Java tool of your choice:
| View file | ||
|---|---|---|
|
...
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> (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
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
SQL Cloud is a 100% JavaScript database. Therefore a browser page is always required to run the it.
As it is a app for Jira then the user must be logged in Jira to view that page and connect to.
This may look weird, but the JDBC Driver cares about this process automatically making all the actions on behalf the user.
Of course, that page is provided by the SQL Cloud app:
...
Every time that a Java tools opens a database connection against Jira Cloud a new instance of the page above will be automatically opened on the local machine running the JDBC Drive.
The page displays the database connection status on it:
...
The connection limit to connect is 10 seconds. After that threshold a timeout exception will be raised.
The database username is the Jira instance name (same as in the URL).
The database password can be read from that page. Initially a random password is created, but the user can change it or create a new one automatically whether it is blank saved.
...