MySQL JDBC Connector for Jasper Server

1

Hello.

Does everyone have or know of a guide for installing MySQL Server JDBC Driver on Jasper Server? I had no trouble installing it on the Studio but nothing I have found has worked for me on the Server.

I am using Jasper Server Community Edition version 5.6.0 on Ubuntu. I've installed using the Jasper Server installer (not a custom install) and everything is working fine. So, from what I can tell, there are not OS, Compatibility, Java version, or similar issues.

Any help would be greatly appreciated.

Thanks!

Bob

bob_8's picture
55
Joined: May 20 2014 - 10:59am
Last seen: 5 years 1 month ago

2 Answers:

3

Just add the mysql-connector-java-5.1.31-bin.jar to tomcat/lib folder and restart JasperReport Server.

Detailed steps below:

http://community.jaspersoft.com/wiki/connecting-jasperreports-server-you...

 

hozawa's picture
54688
Joined: Apr 24 2010 - 4:31pm
Last seen: 6 months 1 week ago

Thank you Hozawa. That is what I was looking for. I followed the instructions and it worked.

bob_8 - 5 years 5 months ago
0
djohnson53's picture
79416
Joined: May 25 2012 - 11:10am
Last seen: 9 min 12 sec ago

Thanks djohnson53. But I had tried the instructions there. I don't want to change the native Postgres database. I want Jasper Server to be able to access a remote MySQL Database for date. So both JDBC drivers (for Postgres and MySQL) have to be active. I think that's when I get into trouble? The server hands, then crashes when I try to access the remove MySQL database, and I haven't found anything useful in any of the logs.

Any thought? I would very much appreciate any and all pointers, ideas, theories, etc.

Thanks again.

bob_8 - 5 years 5 months ago

That instruction is just to specify database during installation and not to add jdbc to existing JasperReport Server.

hozawa - 5 years 5 months ago
Feedback
randomness