[FIXED] How to prevent Spring Boot/Hibernate from converting entity column names from PascalCase to snake_case?

Issue

I stumbled upon a strange error today. One of my Java Persistence Application programming interface (JPA) entities in Spring Boot application is not working. I tracked the problem down to a single column:

@javax.persistence.Column(name = "NameWrittenInPascalCase")
java.lang.String c;

When I checked the Structured Query Language (SQL) query which Spring Boot/Hibernate generates I discovered the problem. It seams that Spring Boot or Hibernate converts the NameWrittenInPascalCase into name_written_in_pascal_case (just written in snake case). (In database, of course, my column name is written in PascalCase).

For gods sake, why?

And how to prevent it from doing so?

If you need aditional info, I use Spring Boot version 2.5.7.

Solution

in your project application.properties file set the naming strategy:

spring.jpa.hibernate.naming-strategy=org.hibernate.cfg.EJB3NamingStrategy

Default value is org.springframework.boot.orm.jpa.SpringNamingStrategy


UPDATE:

If previous property does not solved your problem, you can use this one (For newer versions of Hibernate):

spring.jpa.hibernate.naming.physical-strategy=org.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl

Answered By - Mehdi Rahimi