FINE_CONF_ENTITY Table Modification Through Data Entry

Version

Application Scenario

Most platform configuration items are stored in the FINE_CONF_ENTITY table in FineDB.

Some configuration items do not support front-end configuration pages or cannot be modified through FINE_CONF_ENTITY visual configuration. In this case, you can modify these configuration items only by modifying the FINE_CONF_ENTITY table.

Note:

1. Modifying FineDB files may cause irreparable bugs, so do not modify FineDB files unless necessary.

2. Prioritize using the front-end configuration page or the FINE_CONF_ENTITY visual configuration method to modify configuration items.

3. Some values of the FINE_CONF_ENTITY table are fixed and cannot be modified. Even if you successfully modify the values, the original fixed logic will still take effect.

Function Description

This document takes a simple example to introduce how to modify the table fields of FINE_CONF_ENTITY through data entry.

Example:

Modify the value of CustomConfig.printWidget in the FINE_CONF_ENTITY table of FineDB to true.

Steps:

1. Back up platform configurations.

2. Connect the FineDB database to get the to-be-modified FINE_CONF_ENTITY table.

3. Create a data entry template to modify the table fields of FINE_CONF_ENTITY through data entry.

4. Modify the table fields and submit the modification to FineDB for storage.

5. Restart the project.

Note:

If you cannot log in to the decision-making platform, you can manually back up the FineDB file in the path %FR _HOME%/webapps/webroot/WEB-INF/embed.

Before you modify the table fields of FINE_CONF_ENTITY, it is recommended that you back up the platform configuration items manually or automatically. For details about backup methods, see Backup and Restoration.

Taking manual backup as an example, log in to the decision-making platform as the admin and select Manual Backup in System Management > Intelligent O&M > Backup & Restoration > Platform Configuration.

The default backup path is .../backup. The backup file is stored in the path %FR_HOME%/webapps/webroot/backup, as shown in the following figure.

FineDB Database Information Obtaining

Log in to the decision-making platform as the admin and choose System Management > System Setting > General.

If the value of External Database is To Be Configured, you can view the FineDB database information by referring to FineDB Database Introduction.

If the value of External Database is Configured, you can click it to view the information of the external FineDB database.

FineDB Database Connection

Create a data connection named FineDB. You can get the related configuration information in section "FineDB Database Information Obtaining."

Note:

1. The built-in FineDB database is an HSQL database that creates an in-memory database when used, which will occupy a large amount of memory when the data volume is large. Therefore, do not create a built-in FineDB database data connection in the FineReport project unless necessary.

2. This document only introduces how to connect to the built-in FineDB database in the designer.

The following table shows specific connection information.

Setting Item	Value
Database	Others
Driver	com.fr.third.org.hsqldb.jdbcDriver
URL	jdbc:hsqldb:file://${ENV_HOME}/embed/finedb/db Note: Compatible with Windows/Linux/Mac.
Username	sa
Password	Keep empty.

Note:

Note: After establishing a FineDB data connection, it is necessary to control data connection using permissions, otherwise the database might be accessed and modified by unauthorized personnel.

Create a data entry template to modify the table fields of FINE_CONF_ENTITY through data entry.

Data Preparation

Create a data query ds1, select FineDB for the data connection, and enter the SQL statement SELECT * FROM PUBLIC.FINE_CONF_ENTITY WHERE ID ='CustomConfig.printWidget' to get to-be-modified table fields.

Report Design

Body Content Setting

Create a general report, set cells A2 to B2 to expand vertically, with the left parent cell of B2 being cell A2. The following figure shows the template style.

Data Entry Widget Setting

Since you need to modify the CustomConfig.printWidget field through data entry, set the B2 cell to a text widget.

Data Entry Attribute Setting

Choose Template > Data Entry Attribute > Submit and add Built-in SQL.

1. Set Database to FineDB and Table to FINE_CONF_ENTITY.

2. Bind the cells to the data columns in the database table and set ID to the primary key.

1. Click the Save button to save the report. Click the dropdown icon and select Data Entry Preview to preview the report.

2. Modify the value of the CustomConfig.printWidget field from false to true.

Click Submit. If the prompt message "Success" is displayed, the modified data has been stored in FineDB.

3. After successfully submitting the data entry, restart the project to make the configuration take effect.

In Database Query of ds1, click Preview, the value of the CustomConfig.printWidget field in the FINE_CONF_ENTITY table has been modified to true.

Platform Configuration Restoration

If you want to restore the platform configuration after modifying the field value because the effect does not perform as well as expected, you can log in to the decision-making platform to restore the backup file in section "Platform Configuration Backup" in this document. For details, see Backup and Restoration.

Decision-Making Platform Login Failure After the Modification

Note:

If you cannot log in to the decision-making platform before modifying the table fields, the following steps to reset the platform configuration will not take effect.

If you can log in to the decision-making platform before modifying the fields in the FINE_CONF_ENTITY table, but cannot log in to or perform a data entry preview on the template after the modification, you can refer to the following steps to reset the platform configuration:

1. According to the backup path set in section "Platform Configuration Backup", locate the backup FineDB file, and replace the existing FineDB file with the backup file to restore the platform configuration.

Taking the manual backup as an example, in the path %FR_HOME%/webapps/webroot/backup/config/manual, locate the backup content with the folder name (backup time). Unzip the config.zip file to obtain the FineDB file. Replace the FineDB file in %FR_HOME%/webapps/webroot/WEB-INF/embed.

2. Restart the project.