解决spring-boot中 jpa不识别mysql大写表名问题

最新推荐文章于 2023-07-06 17:07:06 发布

Valin0927

最新推荐文章于 2023-07-06 17:07:06 发布

阅读量2.1k

点赞数

分类专栏： MySQL

MySQL 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

转载于https://blog.csdn.net/Halleycomett/article/details/78638639
错误信息

[] [http-nio-8022-exec-10] ERROR o.h.e.jdbc.spi.SqlExceptionHelper - Table 'fuwu_base.base_demo' doesn't exist
08:49:57.835 []

解决方法
添加 spring.jpa.hibernate.naming.physical-strategy=org.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl

spring: 
      datasource:
            type: com.alibaba.druid.pool.DruidDataSource
            url: jdbc:mysql://xx.xx.x.xx:3306/xx?useUnicode=true&characterEncoding=UTF8&useSSL=false
            username: root
            password: root
      jpa:  
            database-platform: org.hibernate.dialect.MySQL5Dialect
            database: mysql
            show-sql: true
            format-sql: true
            hibernate:
                  naming:
                     physical-strategy:  org.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl