Hibernate Community • View topic - Select a distinct class in a criteria query?

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Select a distinct class in a criteria query?

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

pkulak

Post subject: Select a distinct class in a criteria query?

Posted: Fri Mar 11, 2005 11:27 pm

Regular

Joined: Tue Mar 01, 2005 2:35 pm
Posts: 60

Hibernate version:
3.0rc1

I would like to retrieve distinct objects from table A when joined to table B using the Criteria API. This is what it would look like in SQL:

SELECT DISTINCT a.*
FROM a INNER JOIN b ON ...
WHERE b.field ...

Is this possible? Thanks!

Top

jivesociety

Post subject: distinct funtionality in Criteria API

Posted: Thu Apr 07, 2005 11:49 am

Newbie

Joined: Mon May 10, 2004 5:45 pm
Posts: 9

So does the Criteria API support the 'distinct' sql functionality? If so, how do you use it? If not, when will it be implemented?

Top

Page 1 of 1

[ 2 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