bchjasperreports

Use Oracle Database with JasperReports

JasperReports natively allows the use of OracleDB as main data source. If you ever wanted to use a more scalable database and professional for your JasperReports installation, here is how.

Step 1: Install JDBC drivers

If you haven’t installed the JDBC driver corresponding to the database server you want to connect, please follow the instructions to install the OracleDB driver.

Step 2: Add new data source

  • Log in to JasperReports.

  • Go to “Data Source > New Data Source”.

  • Select “JDBC Data Source” as the data source type.

  • Fill in the details of your database (username, password, hostname… etc.).

Step 3: Test the connection

  • Click on the “Test Connection” button. If everything was configured correctly, you should see a “Successful connection” message.

Step 4 (Optional): Disable MySQL

If you will not use MySQL as another data source, you can permanently disable it in the stack. This ensures it would not start and consume system resources. In order to do so, execute the commands below:

$ sudo /opt/bitnami/ctlscript.sh stop mysql
$ sudo sed -i '1i exit 0' /opt/bitnami/mysql/scripts/ctl.sh
Last modification October 1, 2018