Hibernate Community • View topic - How to use "Criteria" to query "many-to-one" with the "or"

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

How to use "Criteria" to query "many-to-one" with the "or"

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

lonelone

Post subject: How to use "Criteria" to query "many-to-one" with the "or"

Posted: Thu Mar 24, 2011 10:11 pm

Newbie

Joined: Thu Mar 24, 2011 9:42 pm
Posts: 4

hi
I have three class

Code:

class Link{
int id;
Point pointA;
Point pointZ;
...
}
class Point{
int id;
Circuit circuit;
...
}
class Circuit{
int id;
...
}

now I want to query the Link which the pointA.circuit.id=1 or pointZ.circuit.id=1
the sql is

Code:

select * from Link where pointA.id in (select id from Point where circuit.id=1) or pointZ.id in (select id from Point where circuit.id=1)

how should i do?
thank you!

Top

Page 1 of 1

[ 1 post ]

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