Getting a single property from criteria query

[Hussein Baghdadi]

Hi.
Is it possible to get a single property instead of the whole object using Criteria queries ?
session.createCriteria("book.title")
instead of :
session.createCriteria(Book.class)
?

[Paul Sturrock]

From a criteria based query? Assuming this is Hibernate we are talking about, I don't think so. You can do this with HQL though. Why do you just need one property rather than the object?
[ April 24, 2007: Message edited by: Paul Sturrock ]

[Hussein Baghdadi]

Why do you just need one property rather than the object?

With HQL, you can write :
select book.title from Book book
So, I thought, what about Criteria ?

[Paul Sturrock]

Fair enough. Don't think its possible though.

[Jaap v Hengstum]

Getting a single property in a Criteria can be done using setProjection() :

Criteria criteria = session.createCriteria(Book.class)
  .setProjection(Projections.property("title"))
  .add(Expression.eq("id", bookID));

Above criteria will get only the title(s) of the selected book(s).

[saranga rao]

hi

You can also done this by..

Joining the table like createAlias() of the same table.

Regards
Saranga