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

royskatt
royskatt New Altair Community Member
edited November 5 in Community Q&A
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
Tagged:

Answers

  • royskatt
    royskatt New Altair Community Member
    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

Categories