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 25 Next »

Download the Java .jar library

Download the driver above and install it on your favorite Java tool for reporting & analytics.

JDBC connect

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

Then configure a connection to the SQL Cloud database:

  • 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

How does it work?

SQL Cloud is a 100% JavaScript database. Therefore a browser page is always required to run it.

As it is an app for Jira, a user must be logged in to Jira to view the page and connect to it.

This may look weird, but the JDBC Driver cares about this process automatically making all the actions on behalf of a user.

The SQL Cloud - Query Server page is displayed below:

The page displays the database connection status:

The limit to connect is 10 seconds. If the threshold is reached then 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 (click on the Edit password link). Initially, a random password is created, but User can change it or create a new random one automatically whether it is saved blank.

The database port does not matter. You can use any available in the local machine and the JDBC Driver will use it for all the local communication. Also, this is configured in the JDBC connection URL.

  • No labels