Connect to Jira Data from a Connection Pool in Jetty

Jerod Johnson
Director, Technology Evangelism

The Jira JDBC Driver supports connection pooling: This article shows how to connect faster to Jira data from Web apps in Jetty.

The CData JDBC driver for Jira is easy to integrate with Java Web applications. This article shows how to efficiently connect to Jira data in Jetty by configuring the driver for connection pooling. You will configure a JNDI resource for Jira in Jetty.

About Jira Data Integration

CData simplifies access and integration of live Jira data. Our customers leverage CData connectivity to:

Gain bi-directional access to their Jira objects like issues, projects, and workflows.
Use SQL stored procedures to perform functional actions like changing issues status, creating custom fields, download or uploading an attachment, modifying or retrieving time tracking settings, and more.
Authenticate securely using a variety of methods, including username and password, OAuth, personal access token, API token, Crowd or OKTA SSO, LDAP, and more.

Most users leverage CData solutions to integrate Jira data with their database or data warehouse, whether that's using CData Sync directly or relying on CData's compatibility with platforms like SSIS or Azure Data Factory. Others are looking to get analytics and reporting on live Jira data from preferred analytics tools like Tableau and Power BI.

Learn more about how customers are seamlessly connecting to their Jira data to solve business problems from our blog: Drivers in Focus: Collaboration Tools.

Getting Started

Configure the JDBC Driver for Salesforce as a JNDI Data Source

Follow the steps below to connect to Salesforce from Jetty.

Enable the JNDI module for your Jetty base. The following command enables JNDI from the command-line:
```
java -jar ../start.jar --add-to-startd=jndi
```
Add the CData and license file, located in the lib subfolder of the installation directory, into the lib subfolder of the context path.

Declare the resource and its scope. Enter the required connection properties in the resource declaration. This example declares the Jira data source at the level of the Web app, in WEB-INF\jetty-env.xml.

<Configure id='jirademo' class="org.eclipse.jetty.webapp.WebAppContext">
 <New id="jirademo" class="org.eclipse.jetty.plus.jndi.Resource">
 <Arg><Ref refid="jirademo"/></Arg>
 <Arg>jdbc/jiradb</Arg>
 <Arg>
 <New class="cdata.jdbc.jira.JIRADriver">
 <Set name="url">jdbc:jira:</Set>
 <Set name="User">admin</Set>
 <Set name="Password">123abc</Set>
 <Set name="Url">https://yoursitename.atlassian.net</Set>
 </New>
 </Arg>
 </New>
</Configure>

To connect to JIRA, provide the User and Password. Additionally, provide the Url; for example, https://yoursitename.atlassian.net.

Configure the resource in the Web.xml:

 jdbc/jiradb
 javax.sql.DataSource
 Container

You can then access Jira with a lookup to java:comp/env/jdbc/jiradb:

InitialContext ctx = new InitialContext();
DataSource myjira = (DataSource)ctx.lookup("java:comp/env/jdbc/jiradb");

More Jetty Integration

The steps above show how to configure the driver in a simple connection pooling scenario. For more use cases and information, see the Working with Jetty JNDI chapter in the Jetty documentation.

Ready to get started?

Download a free trial of the Jira Driver to get started:

Download Now

Learn more:

👁 Jira Icon
Jira JDBC Driver

Rapidly create and deploy powerful Java applications that integrate with Jira including Customers, Inventory, Products, Orders, and more!

URL: https://www.cdata.com/kb/tech/jira-jdbc-jetty.rst