Spring data JPA solves the problem of using the PostgreSQL table name case

The domestic article looked again, actually did not find the fundamental problem solution, the following will enumerate this series of problem solving method:

1. Add the following configuration in the configuration file:

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

2. Add the following annotations on the entities and attributes, respectively:

 
// Table Name
@Table("\"User\"")
// field
@Column("\"Name\"")

Solve from the fundamental problem:

1, in fact, in the design of the database, including on the MySQL is not allowed to appear in uppercase table names, and the adjacent letters using an underscore mark.

2. From now on, you should turn your database design into lowercase and remove the code above.

Reference:

Https://stackoverflow.com/questions/36353492/jpa-uppercase-table-names

Https://stackoverflow.com/questions/28571848/spring-boot-jpa-insert-in-table-with-uppercase-name-with-hibernate

Spring data JPA solves the problem of using the PostgreSQL table name case