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

[sawandj]

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]

can any 1 help...

 

[ogavavka]

Which component in Jaspersoft ETL did you use ?

[sawandj]

i didn’t use any component at first place , because first i tried to create the DB connection but it was not getting connected...

 

[dbooth]

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.

[john.v.little]

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)

[dbooth]

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