Try OpenEdge Now
skip to main content
Business Process Portal Manager's Guide
Creating and deploying reports using JasperReport : Using a Database other than Business Process Server Connection Pool
 

Using a Database other than Business Process Server Connection Pool

If you want to use a database other than Business Process Server, then you must create a file in the same directory where your report is stored, with the name <report_name>.properties.datasource. This file should contain the JDBC URL, driver class, user name and password.

Sample code

A sample of this file is shown below:
########################################################################
# This file has been provided to set sample jasper jdbc datasource for sample jasper report
# jasper.reports.datasource.url: JDBC URL
# jasper.reports.datasource.driver: Driver Class
# jasper.reports.datasource.user: User
# jasper.reports.datasource.password: Password
########################################################################
jasper.reports.datasource.url=<your_database_url>
jasper.reports.datasource.driver=<your_database_driver>
jasper.reports.datasource.user=<your_database_user>
jasper.reports.datasource.password=<your_database_password>
In order to avoid compilation error(s), make sure that the driver classes already exist in your portalServer class path.