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 the lib/ and lib/platform directories of your LuciadFusion installation (be sure to make a backup beforehand)

  • Place the downloaded ojdbc8.jar in the lib/ and lib/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.