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")

score 88 · Accepted Answer · edited May 23 '17 at 12:10

88

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 '17 at 12:10

Community

1
1

answered Mar 16 '15 at 22:54

Predrag Maric

23,938
5
52
68

29

for hibernate v5: spring.jpa.hibernate.naming.physical-strategy=org.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl – Enginer Feb 14 '17 at 18:01
2

Can this be done with an annotation instead of a properties file? – Sridhar Sarnobat Mar 07 '18 at 01:28
How can we achieve that in application.yml file?? – Syed Zeeshan Ali Feb 05 '20 at 10:59
@SyedZeeshanAli: It should be same like you do for server port similarly this key value pair should be defined – dev_2014 Aug 13 '20 at 18:15
@SyedZeeshanAli User below code. I confirmed it is working. ` sping: jpa: hibernate: naming: physical-strategy: org.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl ` – mazend Mar 20 '21 at 04:00
this did not work for me – Dhiraj Mar 28 '22 at 23:56

score 81 · Answer 2 · edited Nov 02 '18 at 23:00

81

For hibernate v5:

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

edited Nov 02 '18 at 23:00

Corey

664
9
18

answered Feb 14 '17 at 18:02

Enginer

3,048
1
26
22

catch23 · Answer 3 · 2023-08-25T21:00:10.233

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.

score 4 · Answer 4 · edited Jan 21 '23 at 17:08

4

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

edited Jan 21 '23 at 17:08

James Jithin

10,183
5
36
51

answered Mar 12 '20 at 06:34

nanna dash

41
1

score 1 · Answer 5 · answered Nov 10 '15 at 20:55

1

Use

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

answered Nov 10 '15 at 20:55

score 0 · Answer 6 · answered Jan 05 '22 at 18:52

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...

score -2 · Answer 7 · edited Jul 12 '18 at 05:00

-2

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

edited Jul 12 '18 at 05:00

slm

15,396
12
109
124

answered Jul 12 '18 at 04:35

user8106134

107
1
4

score -3 · Answer 8 · answered Jul 11 '18 at 17:46

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

Entity Class name is transformed into SQL table name with underscores

8 Answers8

Linked

Related