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

0

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.

DB type: GENERAL JDBC

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: 6 years 10 months ago
can any 1 help...
sawandj - 6 years 11 months ago
Which component in Jaspersoft ETL did you use ?
ogavavka - 6 years 11 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 - 6 years 11 months ago

2 Answers:

0

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. 

http://dev.mysql.com/downloads/connector/j/  - 5.1.22 can be downloaded.

dbooth's picture
53
Joined: Aug 23 2011 - 7:56am
Last seen: 2 weeks 4 days 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 - 5 years 2 months ago
0

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.

Dale

dbooth's picture
53
Joined: Aug 23 2011 - 7:56am
Last seen: 2 weeks 4 days ago
Feedback
randomness