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.
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
when i click on check connection. it get the above error message.
help will be really appriciated...
thanks and regards..
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.