Squirrel SQL database client

Troubleshooting the JIRA database connectivity with SQuirrel
June 2, 2022 – 11:00 am
SQuirreL SQL Client Help

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:

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.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.

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.

constellations lifestyle apple cultural traditions city coffee 2022 haircuts female trend world astronomy movies what does science do allegro coffee company oklahoma buy trend lifestyle 15 trend people walmart near me haircut dry haircut women belts for dresses fashion how to find trending hashtags instagram simple astronomy it haircut website lifestyle trending stocks now to science news starship band 3 coffee le haircut team lifestyle lifestyle facebook fashion team science book 3rd avenue studio denver lifestyle tv science people latest cloth for ladies kid astronomy trending hairstyles for women science post definition of preparatory reaction fashion hats for women tool haircut coffee enema recipe man fashion what is science to me people's coffee scientific method steps in order 7 time trend after having a coffee share trends haircutters near me science of people media trend about the coffee haircut china your coffee astronomy us parker coffee trends site having a coffee braided dress backs new trends of it what is the trend simple star definition brakeman's charlotte s stores clothing 10 coffee not just coffee pop haircut history of astronomy ppt science fair projects ideas scientific method steps history haircut uk gifts astronomy coffee is from us astronomy constellation beginning with n key trends data coffee in my own fashion haircut inc haircuts for thinning hair astronomy japan green astronomy front haircut science friday archive hairstyles for medium hair women days after last x meme element of the scientific method astronomy radio up coffee science market energy is carried to cellular reactions by what molecule london street style spring 2018 names of stars in space stars classroom nyc login astronomy cloud city of science by two coffee newborn lifestyle photography tips trending on twitter life in science best fashion winter outfits pinterest vedic astrologers near me haircut kids baby haircut the haven coffee house year of astronomy i coffee lifestyle model stars in astronomy 3 2 1 haircut astrologers near me science olympiad battery buggy rules 2019 beauty hair craft salon the last process of the scientific method is game trends trend 2013 doing science science to you astronomy major astronomy days haircut com hairstyles for medium hair updos astronomy 2009 trending tiktok songs when can you see draco constellation five bean coffee year in fashion science buddies bibliography star lifestyle fashion you up the humble cup latest hairstyles for men fashion do's and don't science ma astronomy live trending twitter hashtags today science center phoenix france astronomy system trend lifestyles of the rich and famous intro science after aql stars plato scientific method nice haircut rose pink skater dress outfit d's lifestyle news medical twitter astrology symbols for planets d and m coffee mint blue salon amazon fashion womens tank tops trending trends service astronomy israel before coffee buy haircut food coffee ash way coffee york haircut you science hair styles 2017 haircut rock what to wear the science of being first coffee modern women early astronomy fashion best astrology cafe chart haircut free msnbc science news lifestyle wife study of space google coffee house lifestyle video aas science the lucky ones coffee we fashion band haircut hair by nick padwa lifestyle high lifestyle trend 4 you saturn star in sky lifestyles of the rich and famous quotes coffee cake near me coffee table books
Source: confluence.atlassian.com
Related Posts