Summary of built-in jdbc driver version

FineBI contains a lot of built-in drivers, and the corresponding JDK version of these drivers is JDK1.8. During use, ensure that the driver is consistent with the JDK version. If you use the built-in driver, the environment JDK needs to be version 1.8; if you don't want to change the environment's JDK version, you need to replace the driver version consistent with the JDK under the project. Below we will list some of the built-in drivers and matching JDK versions included in FineBI.

The built-in drivers and matching JDK versions are shown in the following table:

The address of the driver JAR package is: %FineBI%/webapps/webroot/WEB-INF/lib. If the JDK version does not match, you can go to this path to replace the driver version.

If the environment JDK version is 1.7 and you want to connect to the SQL Server database, but the version does not match the built-in driver, you need to copy the SQL Server driversqljdbc41.jar to the above directory and delete sqljdbc42.jar.