Entity Class name is transformed into SQL table name with underscores

Question

I have the following entity defined:

@Entity @Table(name = "EmailTemplate") public class EmailTemplate {

Despite the table annotation, I receive java.sql.SQLException: Invalid object name 'email_template'. How can I prevent an entity class such as EmailTemplate being transformed into email_template table name?

Edit:

I'm using Spring Boot: start JPA. From my build.gradle file,

compile("org.springframework.boot:spring-boot-starter-data-jpa")

Community · Accepted Answer · 2017-05-23 12:10:29Z

91

Spring by default uses org.springframework.boot.orm.jpa.SpringNamingStrategy which splits camel case names with underscore. Try setting spring.jpa.hibernate.naming-strategy=org.hibernate.cfg.EJB3NamingStrategy in application.properties. Check out this and this for more info.

edited May 23, 2017 at 12:10

CommunityBot

11 silver badge

answered Mar 16, 2015 at 22:54

Predrag Maric

24.5k5 gold badges57 silver badges72 bronze badges

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

6 Comments

Enginer Over a year ago

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

Sridhar Sarnobat Over a year ago

Can this be done with an annotation instead of a properties file?

Syed Zeeshan Ali Over a year ago

How can we achieve that in application.yml file??

dev_2014 Over a year ago

@SyedZeeshanAli: It should be same like you do for server port similarly this key value pair should be defined

mazend Over a year ago

@SyedZeeshanAli User below code. I confirmed it is working. ` sping: jpa: hibernate: naming: physical-strategy: org.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl `

|

Corey · Accepted Answer · 2018-11-02 23:00:51Z

For hibernate v5:

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

catch32 · Accepted Answer · 2023-08-25 21:00:10Z

For Spring Boot 2 (checked with 2.2.6.RELEASE) it should be configuration yml file:

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

So you could have model like:

@Table(name = "tblDepartments") public class Department { @Id @Column(name = "dpID") @GeneratedValue(strategy = GenerationType.IDENTITY) private Integer id; @NotEmpty @Size(min = 1, max = 25) @Column(name = "dpName", length = 25) private String name;

and populate tables at startup with data.sql:

INSERT INTO tblDepartments (dpName) VALUES ('Gryffindor'); INSERT INTO tblDepartments (dpName) VALUES ('Hufflepuff');

Also, found that for PostgreSQL additional step is needed:

@Entity @Table(name = "\"tblEmployees\"") public class Employee { @Id @Column(name = "\"empID\"") @GeneratedValue(strategy = GenerationType.IDENTITY) private Integer id; @NotEmpty @Size(min = 2, max = 25) @Column(name = "\"empName\"", length = 25) private String name;

Otherwise, the names at DB will be in lowercase, like tblemployees.

James Jithin · Accepted Answer · 2023-01-21 17:08:03Z

Use this in your appplication.properties.

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

user41871 · Accepted Answer · 2015-11-10 20:55:32Z

Use

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

gavenkoa · Accepted Answer · 2022-01-05 18:52:49Z

There are two most common org.hibernate.boot.model.naming.PhysicalNamingStrategys:

org.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl org.hibernate.boot.model.naming.CamelCaseToUnderscoresNamingStrategy # also deprecated in 2.6 in favor of CamelCaseToUnderscoresNamingStrategy # for removal in 2.8 org.springframework.boot.orm.jpa.hibernate.SpringPhysicalNamingStrategy

org.springframework.boot.autoconfigure.orm.jpa.HibernateProperties holds:

private void applyNamingStrategies(Map<String, Object> properties) { applyNamingStrategy(properties, AvailableSettings.IMPLICIT_NAMING_STRATEGY, this.implicitStrategy, () -> SpringImplicitNamingStrategy.class.getName()); applyNamingStrategy(properties, AvailableSettings.PHYSICAL_NAMING_STRATEGY, this.physicalStrategy, () -> CamelCaseToUnderscoresNamingStrategy.class.getName()); }

so by default CamelCaseToUnderscoresNamingStrategy is in use and you have underscores...

slm · Accepted Answer · 2018-07-12 05:00:22Z

org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute statement; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute statement

Both are required :

implicit-strategy physical-strategy

user8106134 · Accepted Answer · 2018-07-11 17:46:16Z

Solved.

Invalid Object Name: Springboot with JPA(SQL server)

In application.yaml/properties specify the

spring.jpa.hibernate.naming.implicit-strategy spring.jpa.hibernate.naming.physical-strategy

jpa: show-sql: false hibernate: ddl-auto: none # Defaults to "none" when NOT in embedded mode naming: implicit-strategy: org.hibernate.boot.model.naming.ImplicitNamingStrategyLegacyJpaImpl physical-strategy: org.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl

Collectives™ on Stack Overflow

Entity Class name is transformed into SQL table name with underscores

8 Answers 8

6 Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

8 Answers 8

6 Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Linked

Related