SpringDataJpa自动生成sql和数据库定义字段不统一

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

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值