How do I set the Hibernate dialect in SpringBoot?

Question

I have a custom dialect to set for Hibernate in SpringBoot. The dialect is for Gemfire. The instructions are for XML-based config.

However, I am using SpringBoot and I cannot figure out how to set this property.

The dialect is com.pivotal.gemfirexd.hibernate.GemFireXDDialect

score 91 · Accepted Answer · edited Aug 22 '19 at 06:09

91

In application.properties

spring.jpa.properties.hibernate.dialect = com.pivotal.gemfirexd.hibernate.GemFireXDDialect

edited Aug 22 '19 at 06:09

mate00

2,727
5
26
34

answered Jul 26 '16 at 05:39

Alex Fernandez

1,892
14
17

I am using `spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.PostgreSQL10Dialect`, but Hibernate ignores it, does not invoke `org.hibernate.boot.model.naming.Identifier.render(Dialect)`, and instead invokes `org.hibernate.boot.model.naming.Identifier.render()`, so I am getting ticks in place of double quotes. – Cardinal System Apr 09 '21 at 21:08

score 25 · Answer 2 · edited Feb 28 '17 at 05:57

25

You can use this approach as well:

spring.jpa.database-platform=com.pivotal.gemfirexd.hibernate.GemFireXDDialect

edited Feb 28 '17 at 05:57

niemmi

17,113
7
35
42

answered Feb 28 '17 at 05:30

Errol Carrasco

261
3
3

score 10 · Answer 3 · edited Jul 18 '23 at 06:57

10

Yet another way to set the dialect is via the spring.jpa.database property using a short DB name (case insensitive) as defined in the db vendors list. For example:

spring.jpa.database=postgresql

edited Jul 18 '23 at 06:57

roj

1,262
13
27

answered Feb 03 '22 at 19:11

Roman-Stop RU aggression in UA

14,905
3
48
53

score 1 · Answer 4 · edited Feb 05 '21 at 13:25

1

we can use this for activating oracle 10 g dialect

spring.jpa.database-platform=org.hibernate.dialect.Oracle10gDialect

edited Feb 05 '21 at 13:25

General Grievance

4,555
31
31
45

answered Feb 05 '21 at 11:58

Shashi Bhushan Jha

21
1

How do I set the Hibernate dialect in SpringBoot?

4 Answers4

Linked

Related