Spring JPaRepository不识别Column
Spring JPaRepository不识别Column
我正在开发一个简单的Spring端点。我的当前数据库表SQL如下:
CREATE TABLE develop.usermetrics ( metricId SERIAL PRIMARY KEY, uid varchar(12), deptCode varchar(10), orgGroup varchar(10), orgUnit varchar(10), orgCode varchar(10), workLocationCode varchar(10), campusId varchar(20), userRole varchar(50), metricDate timestamp );
而我的实体包含:
@Table(name = "usermetrics") @Entity public class UserMetricsEntity { @Id @Column(name = "metricId") @GeneratedValue(strategy=GenerationType.IDENTITY) private Long metricId; @Column(name = "uid") private String uid; @Column(name = "deptCode") private String deptCode; @Column(name = "orgGroup") private String orgGroup; @Column(name = "orgUnit") private String orgUnit; @Column(name = "orgCode") private String orgCode; @Column(name = "workLocationCode") private String workLocationCode; @Column(name = "campusId") private String campusId; @Column(name = "userRole") private String userRole; @Column(name = "metricDate") private LocalDateTime metricDate;
在调用存储库的save方法时,我遇到了错误:
UserMetricsEntity{metricId=null, uid='105735781', deptCode='Z05511', orgGroup='F&O', orgUnit='CIO', orgCode='0F', workLocationCode='MPG', campusId='GDLPLANT', userRole='Fullstack Developer', metricDate=2021-11-01T12:45:22.588191} 2021-11-01 12:45:23.029 WARN 57529 --- [nio-8082-exec-3] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 0, SQLState: 42703 2021-11-01 12:45:23.029 ERROR 57529 --- [nio-8082-exec-3] o.h.engine.jdbc.spi.SqlExceptionHelper : ERROR: column "campus_id" of relation "usermetrics" does not exist
日志的第一行是实体的toString输出。