Spring JPaRepository未识别列

Question

我正在处理一个简单的Springendpoint。我当前的db表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;

当调用存储库的保存方法时，我得到了错误：

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。

Answer 1

尽管我在创建sql的表上使用骆驼大小写命名，但pgadmin将大写更改为小写。我将实体类的命名约定更改为所有小写，并且它有效。