Cameron Braid wrote:
Sorry.. I meant to say that I was using 2.1 beta 3.
Which doco ? The doco at http://www.hibernate.org/hib_docs/reference/html/query-criteria.html
Or is there a 2.1 beta 3 specific set of docs..
DO I need to get them from CVS ? If so which repo ?
Cheers,
Cameron
-----Original Message-----
From: Gavin King [mailto:[EMAIL PROTECTED] Sent: Thursday, 2 October 2003 6:30 PM
To: Cameron Braid
Cc: [EMAIL PROTECTED]
Subject: Re: [Hibernate] I need help with the Criteria API when using joins
You need to be using Hibernate 2.1. It is covered in the doco for 2.1.
Cameron Braid wrote:
I couldn't find any info on this subject on the hibernatesite. There
are examples of simple criteria based queries, but nothing with relationships.relationship, I can't
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-----
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
allow me towork out how to do it.
I have an existing text query that I want to convert to
doing heremake options optional :hibernateSession.createCriteria(OrderItem.class);
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
_______________________________________________;) 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