HQL problem with composite ids...

samy · **Joined:** Tue Jan 27, 2004 10:59 am **Posts:** 24

Hi,

Error as follows:
net.sf.hibernate.QueryException:
could not resolve property type: isValid

my .hbm.xml filehas:
<discriminator
column="isValid"
type="boolean"
/>
How do we query for a boolean in HQL...
What is wrong ?
Please help
~Thanks.

gavin · **Posted:** Thu Feb 12, 2004 12:43 pm

foo.class

michael · **Posted:** Thu Feb 12, 2004 12:46 pm

To elaborate a bit more: You can use .class to refer to the discriminator property value in your HQL. So this should works:

from Something s where s.class

Better think about using Polymorphic queries though.

samy · **Joined:** Tue Jan 27, 2004 10:59 am **Posts:** 24

As addendum to above,

my actual query is (wondering if there is anything wrong with this:)
final String QUERY =
"from c in class " + CreditCard.class +" where c.isValid=" + true;

Thanks~

samy · **Joined:** Tue Jan 27, 2004 10:59 am **Posts:** 24

geoglm:
Polymorphic queries...example syntax please...
Thanks

samy · **Joined:** Tue Jan 27, 2004 10:59 am **Posts:** 24

geoglm:
Polymorphic queries...example syntax please...
Thanks

michael · **Posted:** Thu Feb 12, 2004 12:50 pm

samy · **Joined:** Tue Jan 27, 2004 10:59 am **Posts:** 24

gavin...

COuld you please elaborate...
My query currently already has .class in it
final String QUERY =
"from c in class " + CreditCard.class +" where c.isValid=" + true;

Do I need quotes around "true" above...is my syntax correct....

Thanks!

michael · **Posted:** Thu Feb 12, 2004 12:53 pm

Your syntax is long deprecated and I think not even correct. Read my sample I posted on how to use .class

samy · **Joined:** Tue Jan 27, 2004 10:59 am **Posts:** 24

Thanks again.
so i should say:
from Something s where s.class.isValid = true...
......?

Thanks.

michael · **Posted:** Thu Feb 12, 2004 12:57 pm

from Something s where s.class = true

.class is an alias for the discriminator value.

samy · **Joined:** Tue Jan 27, 2004 10:59 am **Posts:** 24

Thanks again.
Not sure if I am interpreting correctly or no, but do we not need to have
class.attribute=true, instead of class=true, as in, from Something s where s.class.isalid=true...

I am currently getting this exception:
"from "
+ CreditCard.class
+ " c where c.isValid="
+ true;
for :
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:134)
Caused by: net.sf.hibernate.QueryException: unexpected token: class [from c class com.credit.CreditCard where class com.credit.CreditCard =true]

Thanks for the reply!

michael · **Posted:** Thu Feb 12, 2004 2:14 pm

No, it's just like I posted, why don't you believe me? http://www.hibernate.org/hib_docs/reference/html/query-language.html#query-language-s5

emmanuel · **Posted:** Thu Feb 12, 2004 2:15 pm

Code:

from CreditCard c where c.isValid=true

Code:

from CreditCard as c where c.isValid=true

Both are valid

emmanuel · **Posted:** Thu Feb 12, 2004 2:19 pm

Disregard my post, read too fast.