我为我的表创建了一个数据类，该数据类在命名查询中引发错误

Question

实体名称与表名称类似。

@Table
@Entity(name = "CKYCUploadTransactions")
@Access(AccessType.FIELD)
@NamedQueries({
       @NamedQuery(name = "CKYCUploadTransactions.byUserId", query = "select k from CKYCUploadTransactions k where" +
               "k.userId = :user_id"),
       @NamedQuery(name = "CKYCUploadTransactions.byUserIdAndTxnTypeAndStatus", query = "select k from CKYCUploadTransactions k where" +
               "k.userId = :user_id AND k.txnType = :txn_type AND k.status = :status"),
       @NamedQuery(name = "CKYCUploadTransactions.byUserIdAndContext", query = "select k from CKYCUploadTransactions k where" +
               "k.userId = :user_id and k.context = :context")
})
@Data
public class CKYCUploadTransactions {

    @Id
    @Column(name = "id")
    @GeneratedValue(strategy = GenerationType.AUTO)
    private Long id;

    @Column(name = "user_id")
    private String userId;

    @Column(name = "context")
    private String context;

    @Column(name = "txn_type")
    private String txnType;

    @Enumerated(EnumType.STRING)
    @Column(name = "status", length = 20)
    private Status status;

    public enum Status{
        initiated,
        success,
        failed
    }

}

我不明白为什么它会抛出此错误，我创建了另一个类似的实体，但没有遇到那里的问题。

异常：命名查询中的错误：CKYCUploadTransactions.byUserIdAndTxnTypeAndStatus、CKYCUploadTransactions.byUserIdAndContext、CKYCUploadTransactions.byUserId

Answer 1

您可以按照此 JPA 命名查询

CKYCUploadTransactions.byUserId
应该是
CKYCUploadTransactions.findByUserId