how to create new remote DB mysql connection in jasper etl?


hi guys,

I am new to jasper etl . I am trying to create a new remote mysql DB conncetion. can any one tell me how to do it..

when i tried to do it, i got this error.

Connection failure. You must change the Database Settings.
  java.lang.ClassNotFoundException: com.mysql.jdbc.driver

 the seetings what i used was.


JDBC url : dbc:mysql://'ip number':3306/db name

Driver jar : mysql-connector-java-5.1.16.jar

class name : com.mysql.jdbc.driver

user name : root

password. *****

when i click on check connection. it get the above error message.

help will be really appriciated...

thanks and regards..

sawandj's picture
Joined: Dec 7 2012 - 12:30am
Last seen: 8 years 4 months ago
can any 1 help...
sawandj - 8 years 5 months ago
Which component in Jaspersoft ETL did you use ?
ogavavka - 8 years 5 months ago
i didn’t use any component at first place , because first i tried to create the DB connection but it was not getting connected...
sawandj - 8 years 5 months ago

2 Answers:


Is the MySQL Driver jar in your CLASSPATH?  The MySQL Driver jar file is not shipped with JasperReports Server 4.5.x and beyond.  You'll be looking for mysql-connector-java-5.1.xx-bin.jar, where xx is an integer.  - 5.1.22 can be downloaded.

dbooth's picture
Joined: Aug 23 2011 - 7:56am
Last seen: 1 month 2 weeks ago

The link above only allows you to download an MSI installer - I dont want to install bloatware, just get the missing mysql jar file. Does anyone know where this can be downloaded from?
Assuming the jar can be found, how does one add it to the jasper studios class path? (windows 8)

john.v.little - 6 years 8 months ago

The original site that I provided defaults to Microsoft Windows, but if you select, Platform Independent, you have the option of tar and/or zip files, which would allow you to get the JDBC driver jar.


dbooth's picture
Joined: Aug 23 2011 - 7:56am
Last seen: 1 month 2 weeks ago