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