Jasper Reports integration with Rails and MySQL

[izreena]

 I have successfully integrate Jasper Reports with Rails using Oracle database, or Xml data source, but not with MySQL database.

I have been using guide from http://wiki.rubyonrails.org/rails/pages/howtointegratejasperreports to achieve that.

The error that I get when running this report from Rails is 

 

 

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

at java.net.URLClassLoader$1.run(Unknown Source)

at java.security.AccessController.doPrivileged(Native Method)

at java.net.URLClassLoader.findClass(Unknown Source)

at java.lang.ClassLoader.loadClass(Unknown Source)

at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)

at java.lang.ClassLoader.loadClass(Unknown Source)

at java.lang.Class.forName0(Native Method)

at java.lang.Class.forName(Unknown Source)

at XmlJasperInterface.report(XmlJasperInterface.java:96)

at XmlJasperInterface.main(XmlJasperInterface.java:67)

 

In the code below is snippet from my XmlJasperInterface (refer rails wiki) and the error is pointing at the mysql connector driver. I compiled XmlJasperInterface with Netbeans, and I have already added in MySQL JDBC library in my project. The classnotfound error still persists. Anyone has experience in this?

 

I think this is Java/Jasper problem, not Rails related, that's why I'm posting here.

 

Thanks :)

 

 

Code:

Post Edited by themillie at 07/09/2012 07:56