I. Overview
HSQL database is a free database written in Pure Java, licensed under bSD-style protocol. It is small compared to other databases, and a single HSQLDB.jar file contains the database engine, database drivers, and other user interface operations.
FineReport provides two ways to connect data:
Method 1: Connect to the database in the designer. For details, see [Designer]JDBC data connection.
Method 2: Connect to the data decision platform. This paper mainly introduces this way.
II. Data connection
1. Configuration information
Driver | URL | Driver download address |
com.fr.third.org.hsqldb.jdbcDriver | jdbc:hsqldb:file:[PATH_TO_DB_FILES] | 1) FR FineDB is HSQL database, no need to download 2) FR built-in ifxjdbC.jar driver package, no need to download |
2. Connection steps
1) The administrator logs in to the data decision system and selects the Manage>System>Data Connection>Data Connection Management, click New Data Connection, select HSQL under all options, and click OK, as shown below:
Note: If non-administrator users want to configure data connection, the administrator must assign the permission of the data connection node in the management system to them. For details, see Data Connection Authorization.
2) Enter the data connection information in the configuration information format described in Section II .Advanced Settings are optional. For details, see [Platform] Data Connection. After input information, the interface is as follows:
3) Click Test Connection, or Click to Connect Database in mode. If the "Connection Successful" prompt box pops up, the database is successfully connected, as shown in the picture below:
4) Select the mode after the test connection is successful. Select the corresponding mode as required. Otherwise, the first mode will be selected by default. As shown below:
5) Click the Save button in the upper right corner after mode selection, and the data connection will be added successfully. As shown below: