Aug 19

Installing jasperserver 4.0 with mysql 5.5

Installing jasperserver on tomcat with mysql5.5 it isn’t as straight forward as one might think (or as their manual implies). I was trying to install the latest version of jasperserver using the war method and found the script fails.
Reason: there are two files with the wrong syntax that need to be edited (this might also affect other versions of mysql and jasperserver). The files mentioned are located in this folder:
jasperreports-server-cp-4.0.0-bin/buildomatic/install_resources/sql/mysql/ and they are called:

js-create.ddl
quartz.ddl

Continue reading