I was trying to use jasper reports with zend server in windows 7. I have installed PHP-JavaBridge in the server .
When i run the report page Iam getting an error like
Exception caught: Java Exception java.lang.ClassNotFoundException: com.mysql.jdbc.Driver java.lang.ClassNotFoundException: com.mysql.jdbc.Driver at java.net.URLClassLoader$1.run(Unknown Source) 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 sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source)
Please help me to fix this error as I am a novice in Jasper reports . Also please take me through the procedures to setup the .jar file in zend server .
Thanks in advance.
There is not much information to go by, I really do not know what are you doing with JasperReports when the error occurs :).
It looks like JR is trying to connect to a MySQL server using JDBC (I assume that is for filling the report) and there is no MySQL JDBC driver found. Hence the error "com.mysql.jdbc.Driver " you will need to add the MySQL JDBC driver (.jar file) in the classpath of your Java environment.
In this case JVM used by PHP-Java Bridge; I do not have experience with the Zend Java Bridge but from the docs you will find information on where ClassPath is defined see: http://files.zend.com/help/Zend-Platform/java_bridge.htm
You can download the JDBC driver for MySQL from here http://dev.mysql.com/downloads/connector/j/