Steps for database connection failure

1.1 Problem phenomenon

The functions of FineBI are increasing day by day, and there are more and more types of adapted databases. How to check the connection problems of these databases has also become cumbersome. This article introduces three self-check methods for users when the database connection fails.

1.2 Cause analysis

The database connection failure may be caused by incorrectly filled in the connection information, or the problem of the database connection environment. This article provides three troubleshooting ideas and methods based on the above reasons:

• Check if the URL is correct.

• Run the test tool to check whether there is any problem with the connection environment other than BI, including the database and database driver.

• Check the background error log to check whether there is a JAR package conflict between the database driver and BI.

2.1 Check the URL

One possibility of database connection failure is that the connection information is incorrectly filled. Refer to "Range of database connection support" to find the correct URL format for the corresponding database, and check whether the URL is filled in correctly. As shown below:

2.2 Data connection self-check tool

2.2.1 Install the tool

Download attachment: 

Test Connection.rar

Copy bootstrap.jar andfine-test.jar in the attachment to any directory (English directory, no special characters such as spaces in the path), and then copy the corresponding database driver to this directory. As shown below:

2.2.2 Start the tool

1) Start cmd, executejava -jar bootstrap.jar in the directory where the JAR package is located, and enter 1 according to the prompt, as shown in the following figure:

2) Enter the database driver code, URL, username, password, etc. according to the prompt, as shown in the following figure:

2.2.3 Self-check

If "SQL query time-consuming" appears after entering the SQL statement to be queried, it indicates that the tool is successfully connected. If an error occurs in the middle, it indicates that there is a problem with the database connection environment other than BI, and you need to check the database and database driver.

2.3 Drive isolation plugin

Check FineBI's system error log (error log path:%FineBI%/logs/fanruan.log). If one of the following three errors is reported in the log: NoClassFoundException, NoClassDefFoundError, NoSuchMethodError, then there may be a conflict between the JAR package of the database driver and the JAR package that comes with FineBI, and the driver isolation plugin needs to be installed.

2.3.1 How to install the driver isolation plugin

For the 5.1 version released on 2020-01-15, please refer to the 2020-01-15 version of the driver isolation plugin.

For versions before 2020-01-15, please refer to Driver Isolation Plugin.