Spring JPaRepository不识别Column

10 浏览
0 Comments

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输出。

0
0 Comments

问题出现的原因:

虽然我在创建表的SQL语句中使用了驼峰命名法,但是pgadmin将大写字母改为了小写字母。我将实体类的命名规范改为全部小写后,问题得到解决。

解决方法:

将实体类的命名规范改为全部小写。

0