External Database Configuration

Version

Application Scenarios

FineReport built-in database is HSQL database.

HSQL database cannot be accessed by multiple threads. Clustered environment and large amounts of data may cause its instability. Therefore, HSQL database is suitable for local trial of product functionality, while external database is suitable for the formal use of the platform.

Migration is based on existing data, and there are unpredictable problems in the migration process of old data. Therefore, you can choose to migrate the old data or directly enable a new database.

Functions

After configuring the external database for the report system, the stability of the report system can be ensured in cluster environments or situations with large amounts of data.

You can configure the external database during initialization or within the platform. These two configuration ways have the same configuration requirements and steps.

The types and versions supported by the external database are shown in the table below:

Note: It is recommended to choose MySQL or Oracle database as the external database.