Regarding the JDBC connection to MySQL , where can I find the jar file

[Omara Williams]

Regarding the JDBC connection to MySQL , where can I find the jar file?, in the link provided all there is is a msi file, and this installs teh connector but do not know whre teh jar file is

[Adrian Moerchen · Accepted solution]

1. Go to http://dev.mysql.com/downloads/connector/j/
2. Select "Plattform Independent"
3. Download tar.gz or zip (dependend on your plattform)
4. Extract the archive
5. Locate the JDBC file within the extracted folder

or

1. Go to http://mvnrepository.com/artifact/mysql/mysql-connector-java
2. Choose your desired version
3. Download just the jar ("Binary")

[Omara Williams]

Thank you Adrian, Thease are the correct instructions, so , if you select "Platform independent", you get the archive but if you leave as default "Windows", then you get an installer. In either case, the jar file is retrieved

[Omara Williams]

OK, Starting from this link:

https://confluence.atlassian.com/display/JIRA061/Connecting+JIRA+to+MySQL

In step 2 : Copy the MySQL JDBC driver to your application server

Get the MySQL driver:

• If you are installing JIRA, download the recommended MySQL Connector/J JDBC driver v5.1.

You can download either the .tar.gz or the .zip file. Extract the jar for the driver (e.g. mysql-connector-java-5.x.x-bin.jar) from the archive.

The above link Connector/J JDBC driver v5.1. takes you to the msi file :http://dev.mysql.com/downloads/connector/j

If the above are not the instructions I should be looking at , please advise

Anyway, after installing the connector with the msi, I can find the jar file refered to in these instructions

[Nic Brough -Adaptavist-]

Er, no, the link takes you to a page where you have to select whether you want the .tar.gz / zip file that is mentioned in the segment you've quoted, or an msi.

It might be better if the instructions explicitly said "select" instead of "you can" though. That page has changed slightly since I last needed it.

[Omara Williams]

OK, I have found it , I wast looking for mysql-connector-java-5.1.2.9-bin.jar. In the JIRA instructions, it says it is contained in a zip file, but now when yoiu go to the download link, it only offers a msi installer , which isntalls it here:

C:\Program Files (x86)\MySQL\MySQL Connector J

So the installation instructions needs updating

[Nic Brough -Adaptavist-]

Hmm, I didn't have any problem with the link in the documentation for connecting Jira to MySQL - it links to a zip download for the jtds driver

I don't know if you're using jtds, and you might be looking at different instructions.

[Nic Brough -Adaptavist-]

I'm afraid your question doesn't make a lot of sense. What jar file are you looking for? What documentation are you using? What connector is it? How do you know it's "installed" and if it's working, why are you looking for this?