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
2 Answers:
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...
In the Community Edition Installation Guide: http://community.jaspersoft.com/documentation/jasperreports-server-community-install-guide/v56/working-jdbc-drivers
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.
That instruction is just to specify database during installation and not to add jdbc to existing JasperReport Server.
Thank you Hozawa. That is what I was looking for. I followed the instructions and it worked.