JOC should run with ORACLE 12c

Current Situation

JOC Cockpit does not run with Oracle 12c. The reason for this is an error in the inventory plugin.

When using the org.hibernate.dialect.Oracle10gDialect dialect in the hibernate configuration file, an error occurs +

java.lang.ClassCastException: [Ljava.lang.Object; cannot be cast to java.lang.String

When using the org.hibernate.dialect.Oracle12cDialect the initialization of the inventory fails with empty sql statement

When using the ojdbc6.jar driver the login to the database is not possible (wrong user/password).

Desired Behaviour

The user can add an own JDBC driver for Oracle 12c and an own hibernate configuration file during the JobScheduler setup.

Workaround / Patch

• Download the patch from here
  • The patch solves the issue for Oracle 12c and MSSql
• copy the file to $scheduler_home/lib/patches
• restart JobScheduler
• remove the patch when updating to JobScheduler > 1.11.3