jasperreports: configure datasource on server

1. Check if you have all the database connectors installed

On my case, I did not have the MySQL connector installed (com.mysql.jdbc.driver)

1.1. Download Connector

This connector can be downloaded from the official MySQL website

http://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-5.1.25.zip/from/http://cdn.mysql.com/

 

1.2. Copy Connector to Following Folder

/opt/jasperreports-server-cp-5.1.0/apache-tomcat/webapps/jasperserver/WEB-INF/lib

 

1.3. Confiure JasperServer's DataSource

1.3.1. For SugarCRM

Database Type: JDBC Data Source
JDBC Driver (required): com.mysql.jdbc.Driver
URL (required):  jdbc:mysql://192.168.1.1/(Database_Name)

1.3.2. For OpenBravo

 

Leave a Reply

Your email address will not be published. Required fields are marked *