Difference between spring.jpa.properties.hibernate and spring.jpa.hibernate

user_13866126 0
Viewed 5913

I am working on a spring boot project and using spring data jpa with Hibernate as JPA implementation.

Currently in my application.yml I have the following properties,

spring:
    jpa:
        show-sql: true
        properties:
            hibernate:
                format_sql: true
                generate_statistics: true
        hibernate:
            ddl-auto: none
            dialect: org.hibernate.dialect.H2Dialect

There are Hibernate properties with different prefixes(spring.jpa.properties.hibernate and spring.jpa.hibernate)

What is the purpose of having these difference and can they be used interchangeably, meaning can I replace spring.jpa.properties.hibernate.format_sql with spring.jpa.hibernate.format_sql?

spring-data-jpa spring-boot hibernate
2 Answers

This is explained in the Spring Boot documentation:

-- all properties in spring.jpa.properties.* are passed through as normal JPA properties (with the prefix stripped) when the local EntityManagerFactory is created.

So, spring.jpa.hibernate.X properties are used by Spring, and spring.jpa.properties are passed on to whatever JPA implementation you are using, allowing you to set configuration properties that Spring does not have.

user_16159030

For simplification, there are no more than convention, exactly. Just care about value of key.

spring.jpa.show-sql=true
spring.jpa.properties.hibernate.format-sql=true
spring.jpa.properties.hibernate.generate_statistics=true
spring.jpa.hibernate.ddl-auto=true
spring.jpa.hibernate.dialect=org.hibernate.dialect.H2Dialect

or

spring.jpa.hibernate.dialect=org.hibernate.dialect.H2Dialect
spring.jpa.hibernate.ddl-auto=true
spring.jpa.show-sql=true
spring.jpa.properties.hibernate.format-sql=true
spring.jpa.properties.hibernate.generate_statistics=true

are the same.

For more information, you can see https://docs.spring.io/spring-boot/docs/current/reference/html/howto.html#howto-configure-jpa-properties

https://docs.spring.io/spring-boot/docs/current/reference/html/howto.html#howto-configure-hibernate-naming-strategy just for easy for remember something.

In addition, all properties in spring.jpa.properties.* are passed through as normal JPA properties (with the prefix stripped) when the local EntityManagerFactory is created.

(source: https://docs.spring.io/spring-boot/docs/current/reference/html/howto.html#howto-configure-jpa-properties)

user_37289010
Related