Hibernate Community • View topic

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Criteria API Help

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

Aswin

Post subject: Criteria API Help

Posted: Sat Sep 22, 2007 2:55 am

Newbie

Joined: Sat Sep 22, 2007 1:48 am
Posts: 4

Hi,

I have 3 classes A,B,C and B,C having properties b1 and c1 respectively

I want to create an Equivalent of the following HQL in Criteria API.

from A where B.B1=212 or C.C1=12 : Query1

Is the above code equivalent to

Code:

      Criteria c=session.createCriteria(B.class);
      Criteria c1=c.createCriteria("b");
      Criteria c2=c.createCriteria("c");
      c1.add(Expression.eq("b1",212);
      c2.add(Expression.eq("c1",12);

I don't really know but i think the above Criteria is equivalent to

from A where B.B1=212 and C.C1=12 : Query2

if its so then what will will equivalent code for Query1,

Thanks in adv

Top

parallax555

Post subject:

Posted: Sun Sep 23, 2007 1:23 am

Newbie

Joined: Wed Aug 17, 2005 3:02 pm
Posts: 7

I'm guessing B and C are both properties in A. If that is the case, your code should look like this:

Code:

Criteria criteria = session.createCriteria(A.class);
criteria.createAlias("B", "b").createAlias("C", "c")
          .add(Expression.or(Expression.eq("b.b1", 212), Expression.eq("c.c1", 12)));

Top

Aswin

Post subject:

Posted: Sun Sep 23, 2007 2:18 am

Newbie

Joined: Sat Sep 22, 2007 1:48 am
Posts: 4

Thanks I have done exactly. And it works

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum