can I configure oracle database to jasperreports community edition?

[popkorn]

I put oracle as db for jasperreports server and when i build using js-install it failed.I used jasperreports-server-cp-5.6.1-bin war file and manually tried to build this.This is the error msg i got :

validation.xml JasperServer CE doesn't support oracle DB type!

How to connect oracle db for jasperreports community edition in war file distribution ?

[hozawa]

You can use Oracle DB as a reporting database but not as a repository to save JasperReports Server information.

[popkorn]

Thanks Hozawa for the comment. I saw tat in the JAsper server installation guides, it's mentioned as it's possible and there was a configuration for it.

 

Pls kindly clarify me.

[elizam]

Once you have installed and set up your JRS with a community supported database (MySQL/MariaDB or PostGRES), you need to create data sources for the databases you want to use to make reports. Here's a link:

http://community.jaspersoft.com/documentation/jasperreports-server-administration-guide/v561/jdbc-data-sources

[hozawa]

JasperReports Server repository is a database to save information about your users and reports. Just use something like MySQL. To do this, just setup MySQL and go through the JasperReports Server installation steps as is outline in the Installation guide.

After installation, login to JasperReports Server and create a "Datasource" to use data from Oracle. Specify your report to use this datasource.