JRM <3.5.1 "unknown Oracle major version" after upgrading to Oracle 19c

book

Article ID: 209163

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

After having upgraded the database used by JRM from Oracle 12c to Oracle 19c, logon is impossible.

The error in jrm.log:

[ WARN][localhost-startStop-1]  DATE org.hibernate.dialect.resolver.StandardDialectResolver.resolveDialectInternal(): unknown Oracle major version [19]
[FATAL][localhost-startStop-1]  DATE com.levatis.uc4.toolbox.util.HibernateSessionFactory.rebuildSessionFactory(): Error Creating SessionFactory
javax.persistence.PersistenceException: [PersistenceUnit: com.levatis.LRM] Unable to build EntityManagerFactory

...

Caused by: org.hibernate.HibernateException: Unable to determine Dialect to use [name=Oracle, majorVersion=19]; user must register resolver or explicitly set 'hibernate.dialect'

 

 

Cause

JRM was not compatible with Oracle 19c until 3.5.1 and superior.

Environment

Release : 3.5.0 and inferior

Component : JRM

Resolution

Oracle 19c has started being supported in JRM 3.5.1 and superior ( currently 3.5.2).

This can be checked in the Compatibility Matrix page:

https://downloads.automic.com/tools/compatibility_matrix?compatibility-mode=component&offering_version_id=components&lifecycle_entity_id=1409731986394&version_id=1588575762227

Solution:

You will have to either upgrade JRM to 3.5.1+ or downgrade the Oracle database to the previously working version.