This issue only affects LuciadFusion 2021.0 or earlier. The Oracle JDBC driver was updated in LuciadFusion 2021.1 to resolve the problem.
Due to a bug in the Oracle JDBC driver, it’s possible that LuciadFusion will fail during startup. The LuciadFusion log will contain the following lines:
Caused by: java.sql.SQLException: Invalid argument(s) in call at oracle.jdbc.driver.AutoKeyInfo.getNewSql(AutoKeyInfo.java:187)
This bug affects version 12.2.0.1.0 of the Oracle JDBC driver and has been fixed in later versions. To resolve this issue, you can manually upgrade the JDBC driver used by LuciadFusion.
To manually upgrade the JDBC driver:
-
Visit the Oracle JDBC download page: https://www.oracle.com/be/database/technologies/appdev/jdbc-downloads.html
-
Select any of the 18c, 19c or 21c JDBC drivers links (choose the same version as your database if you are unsure which one to pick)
-
Download the
ojdbc8.jar
from the download page for the selected version -
Remove the
ojdbc8-12.2.0.1.jar
from thelib/
andlib/platform
directories of your LuciadFusion installation (be sure to make a backup beforehand) -
Place the downloaded
ojdbc8.jar
in thelib/
andlib/platform
directories
The last two steps ensure that LuciadFusion uses the newer JDBC driver. LuciadFusion should now start without any issues.
See this Oracle knowledge article if you want read more about the bug in the JDBC driver: https://support.oracle.com/knowledge/Middleware/2278611_1.html.