HQL: Using Boolean in Named Queries

Question

Can you please help me? I have error in querying boolean value "r.isDefault = true".

In my HQL named query:

<named-query name="RptQuery.queryDefaultByCode">
    <query>
        SELECT r FROM RptQuery r WHERE r.code = ?1 AND r.isDefault = true
    </query>
</named-query>

I get error: Caused by: org.hibernate.HibernateException: Errors in named queries: RptQuery.queryDefaultByCode

In my persistence.xml:

<property name="hibernate.query.substitutions" value="true='Y', false='N', yes='Y', no='N'"/>

In my pojo:

private boolean isDefault;

@Column(name = "CPMN_IS_DEFLT", length = 1)
@Type(type = "yes_no")
public boolean isDefault() {
    return this.isDefault;
}

public void setDefault(boolean isDefault) {
    this.isDefault = isDefault;
}

Thank you in advance!

Answer: Just found a minor error:

r.isDefault = true

should be

r.default = true

Thanks.

Thanks and it works, please post your solution as answer and accept your own answer. It will help others — Emdadul Sawon
– Emdadul Sawon, Commented Dec 16, 2018 at 14:45

giannisapi · Accepted Answer · 2012-04-26 14:00:36Z

48

try this : where r.isDefault is true

answered Apr 26, 2012 at 14:00

giannisapi

2,7713 gold badges25 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

HQL: Using Boolean in Named Queries

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related