Hibernate:
select blacklist0_.black_id as black_id1_0_,
blacklist0_.black_name as black_na2_0_,
blacklist0_.create_time as create_t3_0_,
blacklist0_.creater as creater4_0_,
blacklist0_.extend_one as extend_o5_0_,
blacklist0_.extend_two as extend_t6_0_,
blacklist0_.modify_time as modify_t7_0_,
blacklist0_.modifyer as modifyer8_0_,
blacklist0_.package_name as package_9_0_,
blacklist0_.ts as ts10_0_
from black_list_table blacklist0_
where 1=1
order by blacklist0_.ts desc limit ?
jpa生成的sql如上图所示,而我们实体类定义如下所示:
@Id
@Column(name="blackId")
private String blackId;
@Column(name="blackName")
private String blackName;
@Column(name = "packageName")
private String packageName;
明显发现 实体类定义的是blackId,而JPA生成的是black_id,最后发现是因为少个了配置,
在application.properties里添加
spring.jpa.hibernate.naming.physical-strategy=
org.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl