I. Overview
1. Version
| FineReport Version | Function Changes |
|---|---|
| 10.0 | - |
| 10.0.18 | The built-in driver version was changed from ojdbc14.jar to ojdbc8.jar. |
2. Application scenario
The Oracle database system is a set of software products with distributed database as the core provided by the American Oracle company (Oracle). It is currently one of the most popular client/server (CLIENT/SERVER) or B/S architecture databases.
This article describes the steps for Oracle data connection.
Note: Please refer to [Platform]Configure Data Connection for detailed introduction of each setting item of platform data connection
II. Configuration information
| Drive | DatabaseName | URL | Driver download link | Support database version |
|---|---|---|---|---|
oracle.jdbc.driver. OracleDriver | sid_name | jdbc:vertica://ip:port/sid_name | odbc14.jar Note: If you want to use the driver, you need to put the driver in the webapps\webroot\WEB-INF\lib path of the project, delete ojdbc8.jar, and restart the project | Oracle 9.2.0 / 9i Oracle 10.1 Oracle 10.2 / 10g-R2 |
| service_name | jdbc:oracle:thin:@//ip:port/service_name or jdbc:oracle:thin:@ip:port/service_name | |||
| TNSName | jdbc:oracle:thin:@TNSName | |||
| FineReport built-in ojdbc8.jar driver package, no need to download | Oracle 11.1 Oracle 11.2 / 11g-R2 Oracle 12.1 / 12c-R1 Oracle 12.2 / 12c-R2 Oracle 13 and above Oracle 19c |
Note 1: Oracle ojdbc latest download address oracle official website.
Note 2: If FineReport does not have a built-in driver for JDBC data connection, the user needs to place the corresponding driver in%FR_HOME%\webapps\webroot\WEB-INF\lib folder. If you still can't connect after putting in the driver, you can check whether the driver version needs auxiliary JAR package.
III. Operation steps
1. New data connection
1) Log in to the data decision system as an administrator, click Management>Data Connection>Data Connection Management, and click New Data Connection, as shown in the following figure:
Note: If a non-administrator user wants to configure a data connection, the administrator needs to assign it the authority of the data connection node under the management system. For specific operations, please see Data Connection Authorization
2) Select Oracle under the 「Commonly Used」 option, as shown in the figure below:
2. Configure the data connection
1) Enter the corresponding data connection information according to the actual situation, as shown in the following figure:
2) Click to Test Connection, or click click to connect to the database under 「Mode」, if a Connection Successful prompt pops up, it means that the database is successfully connected, as shown in the following figure:
After the connection is successful, the mode will automatically select the default value, as shown in the following figure:
Note 1: The original intention of the model is to make it easier for other functions to read the data in the database, just select 「default」.
Note 2: When connecting to a multi-mode database, the SQL statement needs to be searched with the mode name prefix, for example SELECT * FROM "ABBY"."FR_S_UEP"
3) Click the Save button in the upper right corner.
3. View the effect
1) After the Oracle database is successfully connected, you can edit、 rename、copy、delete and other operations on the platform, as shown in the following figure:
2）At the same time, the successfully configured data connection is automatically generated in the FineReport designer, as shown in the following figure:
IV. Matters needing attention
The designer menu bar File>Options>Advanced is checked by default to Display All Oracle Tables. It is prone to performance problems when connecting to Oracle. It is recommended that users uncheck the box before connecting.
