hibernate dialect for oracle 12c

Question

I'm using hibernate in my spring mvc project and I want to connect to oracle 12c database. I used org.hibernate.dialect.Oracle12cDialect, but, this returns me org.hibernate.boot.registry.selector.spi.StrategySelectionException: Unable to resolve name [org.hibernate.dialect.Oracle12cDialect] as strategy [org.hibernate.dialect.Dialect]. How can I set dialect for oracle 12c? I'm using hibernate 4.3.9.

Answer 1

(Maven) for:

    <dependency>
        <groupId>org.hibernate</groupId>
        <artifactId>hibernate-core</artifactId>
        <version>5.4.9.Final</version>
    </dependency>

You might want to add this dialect:

<property name="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</property>

Answer 2

org.hibernate.dialect.Oracle12cDialect can be used with hibernate-core version 5.0

See: https://docs.jboss.org/hibernate/orm/5.0/javadocs/org/hibernate/dialect/Oracle12cDialect.html

Answer 3

Try to use org.hibernate.dialect.Oracle10gDialect, seems to be the highest possible version in Hibernate 4.3.9.

A dialect for 12c seems to be present in later versions, see this.