@ColumnTransformer选择列时没有别名

Question

我需要加密和解密一些列这样的。

@Entity
@Table(name = "Person")
@Data
public class Person {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "ID", unique = true, nullable = false)
    private Long id;

    @Column(name = "NAME", columnDefinition = "varchar")
    @ColumnTransformer(read = "pgp_sym_decrypt(decode(NAME, 'hex'), 'key')", write = "encode(pgp_sym_encrypt(?, 'key'), 'hex')")
    private String name;

    @ManyToOne
    @JoinColumn(name = "PARENT_ID")
    private Person parent;

}

这句话的意思是：

当我使用PersonRepository.findOneByParentId（10L）时;并查看日志 sql 是

    select
        person0_."id" as id1_99_,
        pgp_sym_decrypt(decode(NAME, 'hex'), 'key') as name2_99_
    from
        "public"."person" person0_
    left outer join
        "public"."person" person1_
            on person0_."parent_id"=person1_."id" 
    where
        person1_."id"=?

这句话的意思是：

此错误消息：

ERROR: column reference "name" is ambiguous

这句话的意思是：

为什么@ColumnTransformer不添加列“name”的表别名，我该怎么办

Answer 1

我有这个问题，添加forColumn属性对我有用。

@列变压器（forCol列="lastName"，