Cameron Braid wrote:
I couldn't find any info on this subject on the hibernate site. There are examples of simple criteria based queries, but nothing with relationships.
Does anyone have any code that achieves something like this ? Or refrence to anything that shows how ?
Is it possible, or is it yet to be implemented ?
Thanks
Cameron
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cameron Braid
Sent: Wednesday, 1 October 2003 10:28 PM
To: [EMAIL PROTECTED]
Subject: RE: [Hibernate] I need help with the Criteria API when using joins
I forgot to include the exception I was getting
net.sf.hibernate.QueryException: could not resolve property: order.state [null]
at net.sf.hibernate.persister.AbstractPropertyMapping.toColumns(A
bstractPro
pertyMapping.java:42)
at net.sf.hibernate.expression.AbstractCriterion.getColumns(Abstr
actCriteri
on.java:35)
at net.sf.hibernate.expression.SimpleExpression.toSqlString(Simpl
eExpressio
n.java:40)
at
net.sf.hibernate.loader.CriteriaLoader.(CriteriaLoader.java:53)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:3426)
at
net.sf.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:149)
-----Original Message-----hibernateSession.createCriteria(OrderItem.class);
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Cameron Braid
Sent: Wednesday, 1 October 2003 9:28 PM
To: [EMAIL PROTECTED]
Subject: [Hibernate] I need help with the Criteria API when using joins
I am using Hibernate 2 beta 3.
I can use the criteria api successfully to query properties of the 'root' persistent class (OrderItem.class)
Criteria = session.createCriteria(OrderItem.class);
though when I want to query acros a many to one relationship, I can't work out how to do it.
I have an existing text query that I want to convert to allow me to make options optional :
String txt = "from orderItem in class " +
OrderItem.class.getName() ; String joiner = " where "; if (filter.getState() != null) {
txt = txt + joiner + " orderItem.order.state = :orderState";
joiner = " and ";
}
... more filter options here ...
Query q = hibernateSession.createQuery(txt);
if (filter.getState() != null) { q.setParameter("orderState", filter.getState()); }
.. more param bindings here ..
I have tried this :
Criteria criteria =
if (filter.getState() != null) { criteria.add(Expression.eq("order.state", filter.getState())); }
Which results in an error saying that 'order' ...
I have tried using aliases - though I don't know what I am doing here ;) criteria.createAlias("order", "order"); I have tried using "this.order.state" instead of "order.state"
I have run out of ideas.
Can anyone help ?
Thanks.
Cameron
------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf _______________________________________________
hibernate-devel mailing list [EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/hibernate-devel
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
hibernate-devel mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/hibernate-devel
------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel
