CODEWITHSUNDEEP
hibernatespring-bootjpa
casol
casol

Reputation: 516

Functioning of Spring Boot Hibernate dialect properties?

Could someone explain what exactly this configuration does?

spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.MySQL5InnoDBDialect

I found that the SQL dialect makes Hibernate generate better SQL for the chosen database or to generate SQL optimized for a particular DBMS. For this particular example it is MySQL but what is the difference between Oracle DB or PostgreSQL?

Upvotes: 0

Views: 1225

Answers (1)

Jaspreet Jolly
Jaspreet Jolly

Reputation: 1313

Short Answer

The dialect in the Hibernate context, will take care of database data type, like in oracle it is integer however in SQL it is int, so this will by known in hibernate by this property, how to map the fields internally.

Upvotes: 1

Related Questions