hozawa Posted August 3, 2014 Share Posted August 3, 2014 I'm able to run js-ant load-sugarcrm-db and js-ant load-foodmart-db with postgresql but the script errors out when using non-postgresql database. Yet in the JasperReports Server Install Guide, it shows steps to create sample databases in non-postgresql databases (e.g. p 38 explains how to install sample database in db2). Has anyone got this to work? Link to comment Share on other sites More sharing options...
dnaboka Posted August 4, 2014 Share Posted August 4, 2014 Hi,Do you have probelm with DB2 specifically? Could you list exact steps and attach log output for investigation Link to comment Share on other sites More sharing options...
Solution hozawa Posted August 4, 2014 Author Solution Share Posted August 4, 2014 JasperReports Server demo only support PostgreSQL. There's errors in the installation manual which needs to be fixed. Link to comment Share on other sites More sharing options...
marianol Posted August 4, 2014 Share Posted August 4, 2014 I think that the samples that come with 5.x only work from a Postgres Database, sicne the reports where created with postgres specific SQL. So you will need to manualy modify the reports and take out any Postgres specific SQL most likely schema names and field quoting Remember that the database is for sample reports so if you installed JRS with DB or MySQL as a repository DB you can just install the samples in a postgres instance and run them from there.The location of the samples (DB content and Repo exports) are in <js-install>/buildomatic/install_resources/ (under /export and sql) Link to comment Share on other sites More sharing options...
marianol Posted August 4, 2014 Share Posted August 4, 2014 Actually page 38 does not talk about the sample reports, It talks about how to load the sample database structure and data in DB2. And that is still correct buildomatic cannot init the create DB commands in DB2 and those need to be created from the command line. So the Documentation is correct. The js-ant-load targets do not install the sample reports just the sample data. Link to comment Share on other sites More sharing options...
hozawa Posted August 7, 2014 Author Share Posted August 7, 2014 Thanks for the clarification. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now