Troubleshooting the JIRA database connectivity with SQuirrel
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
- 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)- The actual Squirrel path may be different depending on how it was installed.
- Start up Squirrel and you should be able to see an Alias and a Drivers tab in the UI
- Select the Drivers tab and scroll down until you see jTDS Microsoft SQL.
- If there is a blue checkmark next to it, then the driver is properly identified.
- 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. - Alternatively, double click to bring up the jTDS Microsoft SQL properties, and select the Extra Class Path tab.
- Click Add and navigate to
$
JIRAINSTALL/lib/jtds-1.2.4.jar
to manually add this to the class definition.
- Click Add and navigate to
- 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.
- 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.