Troubleshooting the JIRA database connectivity with SQuirrel

Still need help?

The Atlassian Community is here for you.

Ask the community

Symptoms

Users that experience database connectivity issues in JIRA can benefit from testing the connection through a DB client such as SQuirrel SQL Client.  The client allows the user to test JDBC connections as well as provide a helpful stacktrace feature to help troubleshoot issues.

Download client: http://www.squirrelsql.org/

Connecting to SQL Server

  1. Copy the bundled SQL driver from JIRA $JIRAINSTALL/lib/jtds-1.2.4.jar to your Squirrel directory: C:\Documents and Settings\<username>\.squirrel-sql (Windows)
    1. (info) The actual Squirrel path may be different depending on how it was installed.
  2. Start up Squirrel and you should be able to see an Alias and a Drivers tab in the UI
  3. Select the Drivers tab and scroll down until you see jTDS Microsoft SQL
    1. If there is a blue checkmark next to it, then the driver is properly identified.
    2. If it's not there, then we need to check and make sure that the jtds-1.2.4.jar file is copied correctly into Squirrel library.
    3. Alternatively, double click to bring up the jTDS Microsoft SQL properties, and select the Extra Class Path tab.
      1. Click Add and navigate to $JIRAINSTALL/lib/jtds-1.2.4.jar to manually add this to the class definition.
  4. Next, navigate to the Alias tab to create a new connection to your DB. Click on the blue 'plus icon' to bring up the new alias dialog.
  5. Here we enter the connection details:
Name: Alias Name Here
Driver: jTDS Microsoft SQL
URL: jdbc:jtds:sqlserver://hostname:port/DB
Username: username
Password: password

Once configured, please click on 'Test' to verify the connection. If it fails, you can click on 'Stack Trace' to see the error that is being generated.

 

Last modified on Feb 19, 2016

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.