"Error after upgrade from Oracle 11g to Oracle 12c"

Hello,

I am using Rapidanalytics, version 5.3 (Open Source). After upgrading the underlying database from Oracle 11g to Oracle 12c, I get this error message:

10:19:47,438 ERROR [STDERR] 20809 [Thread-8] WARN org.hibernate.dialect.resolver.StandardDialectResolver - unknown Oracle major version [12]
10:19:47,439 ERROR [AbstractKernelController] Error installing to Start: name=persistence.unit:unitName=RapidAnalytics-CE-1.3.013.ear/lib/RapidAnalytics_Entity.jar#RapidRepositoryEntity state=Create: javax.persistence.PersistenceException: [PersistenceUnit: RapidRepositoryEntity] Unable to build EntityManagerFactory
...
Caused by: org.hibernate.HibernateException: Unable to determine Dialect to use [name=Oracle, majorVersion=12]; user must register resolver or explicitly set 'hibernate.dialect'

Does anyone know how to fix this?

Btw, there are no downloads on sourceforge anymore, is the OS version totally abandoned now?

Regards,
royskatt

Find more posts tagged with

AI Studio

Server

Errors

Oracle

Accepted answers

All comments

royskatt

I solved the problem:

In the config file located at

/your_rapidanalytics_folder/server/default/deployers/ejb3.deployer/META-INF/jpa-deployers-jboss-beans.xml

you have to add the following entry:

<entry>
    <key>hibernate.dialect</key>
    <value>org.hibernate.dialect.Oracle10gDialect</value>
</entry>

Afterwards you'll be able to start the server again normally.

Regards,
royskatt