MySQL JDBC Connector for Jasper Server


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.



bob_8's picture
Joined: May 20 2014 - 10:59am
Last seen: 8 years 7 months ago

2 Answers:

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

Detailed steps below:


hozawa's picture
Joined: Apr 24 2010 - 4:31pm
Last seen: 3 years 12 months ago

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

bob_8 - 8 years 11 months ago
djohnson53's picture
Joined: May 25 2012 - 11:10am
Last seen: 1 year 4 months 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 - 8 years 11 months ago

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

hozawa - 8 years 11 months ago