MySQL JDBC Connector for Jasper Server

[bob_8]

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

[djohnson53]

In the Community Edition Installation Guide: http://community.jaspersoft.com/documentation/jasperreports-server-community-install-guide/v56/working-jdbc-drivers

 

[bob_8]

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.

[hozawa]

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-your-database

 

[hozawa]

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

[bob_8]

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

[djohnson53]

Sorry, try http://community.jaspersoft.com/wiki/connecting-jasperreports-server-your-database