I. Overview
1) Application scenarios
FineReport10.0 has JDK1.8 or JDK 11 built in, but these two JDK versions do not support direct connection to ODBC data sources. If you connect to the ODBC data source directly on the platform, you will receive the following error message:
How does the 10.0 decision platform connect to ODBC? More on this below.
2) Environment preparations
Download the file and unpack:
Will compress both files in the package
Jdbcodbc. DLL is placed under%FineReport_10.0%\jre\bin
Jdbc.jar is placed under %FineReport_10.0%\webapps\webroot\WEB-INF\lib. As shown below:
Note: If the report project is deployed on a server, such as a Tomcat server, you need to place jdbc.jar and jdbCODBC. DLL in the Lib and bin directories of the Tomcat respectively.
3) Configuration information
To create a JDBC data connection in the platform, the basic configuration information is as follows:
| The database | 驱动 | URL |
|---|---|---|
| Other JDBC | sun.jdbc.odbc.JdbcOdbcDriver | jdbc:odbc:Data source name |
II. Steps
1) Taking the local ODBC connection as an example, configure a local ODBC data source FR, as shown in the figure below:
2) Log in to the decision platform and select the Manage>System>Data Connection>Data Connection Management, click New Data Connection. As shown below:
3) Under Others options, create Other JDBC data connection as shown below:
4) Manually enter the ODBC driver, fill in the user name and password, and finally fill in the complete data connection URL. Click Test Connection, and click Save when successful, as shown below:
