Configuring JasperReports Server with the Cassandra Connector
Summary
Details
Deploy the connector
Download the Cassandra Connector. Unzip it. Copy the files in WEB-INF into your JasperReports Server instance. Be sure to keep the folder structure when copying the files. In connector version 0.5.1 these are the files:
WEB-INF/applicationContext-CassandraDataSource.xml WEB-INF/bundles/CassandraDataSource.properties WEB-INF/lib/cassandra-clientutil-1.0.9.jar WEB-INF/lib/cassandra-jdbc-1.0.5-SNAPSHOT.jar WEB-INF/lib/cassandra-thrift-1.0.9.jar WEB-INF/lib/guava-r08.jar WEB-INF/lib/js-cassandra-datasource-0.5.1.jar WEB-INF/lib/json-org-1.0.jar WEB-INF/lib/libthrift-0.6.1.jar ** The json-org-1.0.jar file was not in the zip file. I had to download it from the web to get things to work. **
Special fix: remove the Hive libraries which ship with JasperReports Server since these conflict with Cassandra (clashing Thrift versions). Here are the scripted changes for a Linux instance, but you can just delete (or rename) the files manually:
mv WEB-INF/lib/hive-common-0.8.1.jar WEB-INF/lib/hive-common-0.8.1.ja_ mv WEB-INF/lib/hive-exec-0.8.1.jar WEB-INF/lib/hive-exec-0.8.1.ja_ mv WEB-INF/lib/hive-jdbc-0.8.1.jar WEB-INF/lib/hive-jdbc-0.8.1.ja_ mv WEB-INF/lib/hive-metastore-0.8.1.jar WEB-INF/lib/hive-metastore-0.8.1.ja_ mv WEB-INF/lib/hive-service-0.8.1.jar WEB-INF/lib/hive-service-0.8.1.ja_
Restart JasperReports Server.
Define a connection
Right-click on a folder in the Repository View in JasperReports Server. Use the context menu to add a data source. The data source definion should follow the model shown below.
Deploy reports
Use either the JasperReports Server web interface or iReport to deploy the report to JasperReports Server.
Log in or register to post comments