I. Overview
Firebird is an open source, free, full-featured, powerful, efficient, lightweight and maintenance-free database tool that can currently run on Windows, Linux and various Unix operating systems, and provides most of the SQL-99 standard functions. It can not only run as a database server in a multi-user environment, but also provide the realization of an embedded database.
II. Steps
1. Download the driver
As shown in the following table:
| Database version | Driver |
|---|---|
| 2.5、3.0 | |
You need to put the downloaded driver in the %FR_HOME%\webapps\webroot\WEB-INF\lib path, and restart the designer. As shown below:
2. Define data connection
1) Click "Server>Define Data Connection" to create a new JDBC data connection, as shown in the figure below:
2) Configure the data connection according to the actual situation, as shown in the following figure:
The configuration items are shown in the following table:
| Setting items | Value | Remarks |
|---|---|---|
| Database | Others | - |
| Driver | org.firebirdsql.jdbc.FBDriver | Can be entered manually |
| URL | The format is: jdbc:firebirdsql://IP of the server where the database is located:port number/specific path where the database is located Note: "Port number" can be omitted. | Example 1: jdbc:firebirdsql://192.168.5.5/E:\fbdata\test.fdb Example 2: jdbc:firebirdsql://192.168.5.63/C:\data\sola.IB |
| User Name/Password | Enter the user name and password of the actual database | - |
3) Click "Test Connection", the connection is successful. As shown below:
Previous：[Platform] Data Connection to Microsoft SharePoint List
