java - 在实体中使用 Enum 时进行查询的问题

Question

我在问题实体中有以下内容:

@NamedQuery(name = "Question.allApproved",
    query = "SELECT q FROM Question q WHERE q.status = 'APPROVED'")

和

@Enumerated(EnumType.STRING)
private Status status;

// usual accessors

我遇到了这个异常:

Exception Description: Error compiling the query [Question.countApproved: SELECT COUNT(q) FROM Question q WHERE q.status = 'APPROVED'], line 1, column 47: invalid enum equal expression, cannot compare enum value of type [myCompnay.application.Status] with a non enum value of type [java.lang.String]. at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:501)

我该如何解决这个问题？

Answer 1

我认为你应该使用你的(完全合格的)Status 枚举而不是文字值，所以像这样:(假设你的 Status 枚举在 com .myexample 包)

@NamedQuery(name = "Question.allApproved", 
            query = "SELECT q 
                     FROM Question q 
                     WHERE q.status = com.myexample.Status.APPROVED").