数据库中的字段名是PM2.5,我的实体类是这样的
@Column(name = "`PM2.5`")
private String PM25;
在PhysicalNamingStrategyStandardImpl模式下,
physical-strategy: org.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl
使用@Column(name = "`PM2.5`")没问题
但是在SpringPhysicalNamingStrategy模式下,
physical-strategy: org.springframework.boot.orm.jpa.hibernate.SpringPhysicalNamingStrategy
使用@Column(name = "`PM2.5`")就报错,提示找不到列
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'dust1minda0_.pm2_5' in 'field list'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4187)
因为我数据库中很多字段是a_b这种带下划线这种形式,
所以我想使用SpringPhysicalNamingStrategy这种策略,这种策略,可以直接把驼峰转成下划线,
但是就PM2.5这一列,在数据库命名中不规范,我该怎么解决?