PLEASE help with setting up a Data Adapter
Posted on August 17, 2017 at 11:02am
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
Joined: Jul 21 2017 - 9:36am
Last seen: 3 years 4 months ago
Posted on August 17, 2017 at 11:30am
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.
Joined: Oct 12 2015 - 12:05pm
Last seen: 11 months 2 weeks ago
Posted on August 17, 2017 at 2:08pm
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"
Joined: Apr 24 2010 - 4:31pm
Last seen: 3 years 11 months ago
Posted on August 18, 2017 at 1:37am
BRILLIANT ... THANK YOU SO MUCH!!!!
Joined: Jul 21 2017 - 9:36am
Last seen: 3 years 4 months ago
