How to set hibernate.format_sql in spring-boot?

Question

I'm using spring-boot autoconfiguration for database injection, with properties defined:

spring.jpa.database=POSTGRESQL
spring.jpa.show-sql=true
spring.jpa.hibernate.ddl-auto=update

But how can I set the hibernate.format_sql=true? Is that not supported by spring boot?

geoand · Accepted Answer · 2015-11-05T07:53:47.463

144

Spring Boot will let you set any available hibernate property using:

spring.jpa.properties.*

So spring.jpa.properties.hibernate.format_sql=true would work as well.

Check out this part of the documentation

edited Nov 05 '15 at 07:53

answered Sep 08 '14 at 08:58

geoand

60,071
24
172
190

score 22 · Answer 2 · answered Feb 25 '17 at 14:41

22

If you are using yml format to declare Spring Boot properties, you can use:

spring:
  datasource:
  jpa:
    properties:
      hibernate.format_sql: true

answered Feb 25 '17 at 14:41

Andrii Abramov

10,019
9
74
96

score 16 · Answer 3 · edited Apr 12 '17 at 07:50

16

jpa:
  hibernate:
    ddl-auto: update
  show-sql: true
  properties:
    hibernate.format_sql: true

edited Apr 12 '17 at 07:50

slfan

8,950
115
65
78

answered Apr 12 '17 at 07:20

xiaogege

161
1
2

score 9 · Answer 4 · answered Sep 08 '14 at 08:48

9

This is very much available

spring.jpa.hibernate.format_sql=true

answered Sep 08 '14 at 08:48

Ankur Singhal

26,012
16
82
116

OK thanks. I wonder why http://docs.spring.io/spring-boot/docs/1.1.5.RELEASE/reference/htmlsingle/ does not mention this property though... – membersound Sep 08 '14 at 08:56

score 7 · Answer 5 · answered Sep 08 '14 at 09:11

7

You can use : spring.jpa.properties.hibernate.format_sql=true

Apart from the documentation, I do follow example from here to configure my application. You can find a sample of properties being used in that.

answered Sep 08 '14 at 09:11

Vinay Veluri

6,671
5
32
56

score 0 · Answer 6 · answered Aug 23 '22 at 19:14

Follow this below properties

spring.jpa.properties.hibernate.format_sql=true

    #Turn Statics On
    spring.jpa.properties.hibernate.generate_statistics=true
    logging.level.org.hibernate.stat=debug
    
    #Show all queries
    spring.jpa.show-sql=true
    spring.jpa.properties.hibernate.format_sql=true
    logging.level.org.hibernate.type=trace

How to set hibernate.format_sql in spring-boot?

6 Answers6

Linked