I. Overview
1. Version
| Finereport version | Functional changes |
|---|---|
| 10.0.16 | The designer data connection configuration is changed from the original direct input URL to the format of database name + host + port. The URL format is retained, and two-way linkage with configuration items is realized to reduce the difficulty of data connection configuration |
2. Function introduction
Hangao database is an object-relation database with very rich basic database functions, covering the core features of all mainstream databases, and meeting the basic needs of enterprise-level applications. Hangao Database introduced the most advanced open source database PostgreSQL kernel technology in the world, and made a series of research and development and optimization on the PostgreSQL community version.
II. Operation steps
Since Hangao Database refers to PostgreSQL kernel technology, we need to put the relevant drivers of PostgreSQL under the report project.
1. Copy the JAR package to the FR project
Copy postgresql-9.4.1208.jre7.jar to webroot/WEB-INF/lib of the report project. Then restart the designer.
For the download address of different versions of the driver package, see: PostgreSQL JDBC Driver
2. Configure data connection
1) Start the designer, click Server > Define Data Connection, and click the + sign in the upper left corner to add a new data connection.
2) Select the database type as Postgre; driver selection: org.Postgresql.Driver. Enter the corresponding content according to the database information, the URL will be automatically generated, or you can enter it directly.
URL: jdbc:postgresql://localhost:port/databaseName
3) Click Test Connection. After the test connection is successful, you can perform related operations on the data.
