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

Question

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.

Have you tried escaping the string with backticks? Like @javax.persistence.Column(name = "`NameWrittenInPascalCase`") — Dranna
– Dranna, Commented Dec 16, 2021 at 17:22
No, but it does not help. In query sent to server there is still name_written_in_pascal_case. :( — KRISTIJAN TOMASINI
– KRISTIJAN TOMASINI, Commented Dec 16, 2021 at 17:46
depending upon ur hibernate version the property name needs to be adjusted in application.properties. refer to this post: stackoverflow.com/questions/29087626/… — srp321
– srp321, Commented Dec 16, 2021 at 18:01
Oh, thank you. It looks like this question is possible duplicate of the question which you linked. I did not find it when i searched for it before. — KRISTIJAN TOMASINI
– KRISTIJAN TOMASINI, Commented Dec 20, 2021 at 14:25

Mehdi Rahimi · Accepted Answer · 2023-03-07 06:57:38Z

11

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

edited Mar 7, 2023 at 6:57

answered Dec 16, 2021 at 17:24

Mehdi Rahimi

2,7665 gold badges35 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

KRISTIJAN TOMASINI Over a year ago

Unfortunately, hibernate still sends name_written_in_pascal_case instead of NameWrittenInPascalCase even after setting this property.

Mehdi Rahimi Over a year ago

Try this property spring.jpa.hibernate.naming.physical-strategy=org.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl @KRISTIJANTOMASINI

KRISTIJAN TOMASINI Over a year ago

This fixed it! Thank you very much. Can you please update your answer so that i can accept it and give you reputation?

Collectives™ on Stack Overflow

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

1 Answer 1

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Linked

Related