I installed and tried to use jasper report studio. The first brick wall you hit when you try to create a datasource for your reports is
MySQL Connector/J Driver Configuration Properties. Environment Properties. OTD Wizard: Database Connection Information. To connect to MYSQL, use the information provided in Table 1–5 to complete the Connect to Database step of the JDBC/ODBC OTD Wizard. Table 1–5 MySQL Connector/J Driver Database Connection Information. The MySQL JDBC Driver is a powerful tool that allows you to easily connect-to live MySQL data through any JDBC capable application or tool! With the Driver users can access MySQL the same way that they would connect to any other JDBC data source.
The forums say I need to install a jar on the classpath. I have no idea how to do this, so the first hurdle is how to get the jar. The only place I can find is this:
but this unfortunately gives you an msi installer, not a jar. I don't want to install stuff, just get the jar.
I have mysql DB installed, had have trawled through the install dir in program files, but can't find the jar.
Anyone know the official (not malware site) way to get hold of the mysql jar? It seems bizarre that its so hard to find.
I have windows 8 64 bit and mysql 5.6.
Mark Rotteveelclosed as off-topic by user207421, Dan Cornilescu, greg-449, EdChum, Soner GönülJan 4 '16 at 9:38
This question appears to be off-topic. The users who voted to close gave this specific reason:
- 'Questions asking us to recommend or find a book, tool, software library, tutorial or other off-site resource are off-topic for Stack Overflow as they tend to attract opinionated answers and spam. Instead, describe the problem and what has been done so far to solve it.' – user207421, Dan Cornilescu, greg-449, EdChum, Soner Gönül
3 Answers
Go to http://dev.mysql.com/downloads/connector/j and with in the dropdown select 'Platform Independent' then it will show you the options to download tar.gz file or zip file.
Download zip file and extract it, with in that you will find mysql-connector-XXX.jar file
If you are using maven then you can add the dependency from the link http://mvnrepository.com/artifact/mysql/mysql-connector-java
Select the version you want to use and add the dependency in your pom.xml file
If you have WL server installed, pick it up from under
OracleMiddlewarewlserver_10.3serverlibmysql-connector-java-commercial-5.1.17-bin.jar
Otherwise, download it from:
http://www.java2s.com/Code/JarDownload/mysql/mysql-connector-java-5.1.17-bin.jar.zip
Mysql Jdbc Driver Maven
Here's a one-liner using Maven:
Then, with default settings, it's available in:
Just replace the version number if you need a different one.
ryenusryenus