PLEASE help with setting up a Data Adapter

[george_17]

Hi all

I have installed the community Jaspersoft Studio as a poster suggested.

I have a mysql database hosted on my linux server.

I have checked and validated all the remote connections and locally on the server using phpmyadmin

for the dataadapter i am using JDBC Driver org.gjt.mm.mysql.Driver

and Jdbc url jdbc:mysql://91.208.99.2:1187/themeats_01

I use the validated correct user/password 

i test and it fails ... with the message... Reason java.lang.ClassNotFoundException org.git.mm.mysql.Driver cannot be found net.sf.jasperreports 6.4.0.finalorg.gjt.mm.mysql.Driver
 

PLEASE ... can anyone tell me how to fix this...

 

thanks

george

 

 

 

[reportdev]

download the mysql driver first. 

In the data adapter configuration, go to Driver Classpath tab. 

Add the driver to this classpath and it should work fine. 

[hozawa]

Also, unless you are using a very old version of mysql jdbc driver, I recommend that you use "com.mysql.jdbc.Driver" instead of "org.gjt.mm.mysql.Driver"

[george_17]

BRILLIANT ... THANK YOU SO MUCH!!!!