Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 12 Next »

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

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.

  • No labels