时间戳

首页 > 解决方案 > Hibernate添加了一个select中不存在的列

hibernate - Hibernate添加了一个select中不存在的列

问题描述

我有实体类：

@Getter
@Setter
@Entity
@Table(name = "ktp_vats_affiliate", schema = "ktp")
@SequenceGenerator(name = "seq", sequenceName = "seq_vats_affiliate_seq", schema = "ktp", allocationSize = 1)
public class VatsAffiliate extends VersionedEntity {
    private static final long serialVersionUID = 2390179214465024152L;
    @Id
    @Column(name = "ID")
    @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "seq")
    protected Long id;
    @Column(name = "MRF_NAME")
    private String mrfName;
    @Column(name = "AFFILIATE_NAME")
    private String affiliateName;
    @Column(name = "X_TERR_REF_ID")
    private String xTerrRefId;
    @Column(name = "CITY_NAME")
    private String cityName;
    @Column(name = "CITY_ID")
    private String cityId;
}

创建表脚本是：

create table KTP_VATS_AFFILIATE
(
    ID             number        not null,
    MRF_NAME       varchar2(128) not null,
    AFFILIATE_NAME varchar2(128) not null,
    X_TERR_REF_ID  varchar2(128),
    CITY_NAME      varchar2(128) not null,
    CITY_ID        varchar2(128) not null
);
-- Create/Recreate indexes
-- Constraint and sequence

我也有 CRUD 存储库类：

@Repository
public interface VatsAffiliateRepository extends CrudRepository<VatsAffiliate, Long> {
}

当我调用 repository.findOne(id) 方法时抛出“由：java.sql.SQLSyntaxErrorException：ORA-00904：“VATSAFFILI0_”。“INLOCK”：无效标识符引起。休眠创建选择不存在的列“INLOCK”，可能是什么问题？

先感谢您。

标签： hibernate

解决方案

抱歉，我发现了问题；不在 Hibernate 中。此类“VersionedEntity”具有字段锁定。

推荐阅读