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.

score 17 · Answer 1 · edited Oct 15 '19 at 16:49

17

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

edited Oct 15 '19 at 16:49

bish

3,381
9
48
69

answered Sep 06 '16 at 21:26

Darshna

201
2
3

1

I think that more details will be good. Add some additional links to documentation and some explanations will be great also. – Spell Sep 06 '16 at 21:48
While link-only answers are generally against SO policy, this is a great concise answer – usr-local-ΕΨΗΕΛΩΝ Dec 18 '18 at 15:51
`org.hibernate.dialect.Oracle12cDialect` cannot be used below Hibernate 5.0. This class is absent from Hibernate 4.3 (previous release prior to 5.0) and lower as can be seen in the [4.3 javadoc](https://docs.jboss.org/hibernate/orm/4.3/javadocs/). – Pierre C Feb 11 '22 at 16:05

wjans · Answer 2 · 2015-07-29T11:24:29.520

13

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.

edited Jul 29 '15 at 11:24

answered Jul 29 '15 at 11:15

wjans

10,009
5
32
43

You mean `Oracle10gDialect` works for oracle 12c same as 11g? – hamed Jul 29 '15 at 12:00
@hamed: Yes, it should work (apart from some version specific details). – wjans Jul 29 '15 at 12:03
For me Oracle10gDialect works for oracle 12c same as 11g. Thank you very much wjans! – Luke Aug 09 '16 at 15:48

score 0 · Answer 3 · answered Dec 16 '19 at 14:35

(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>

hibernate dialect for oracle 12c

3 Answers3

Linked