Hibernate criteria _ how to use criteria to return only one element of an object instead the entire object

Question

Hello,

I'm trying to get only the list of id of object bob for example instead of the list of bob. It's ok with a HQL request, but I would know if it's possible using criteria ?

An example :

final StringBuilder hql = new StringBuilder();
hql.append( "select bob.id from " )
    .append( bob.class.getName() ).append( " bob " )
    .append( "where bob.id > 10");

final Query query = session.createQuery( hql.toString() );
return query.list();

Answer 1

I think you could do that with Projections, something like

Criteria.forClass(bob.class.getName())
        .add(Restrictions.gt("id", 10))
        .setProjection(Projections.property("id"))
        );

Answer 2

or setProjection(Projections.id())

Answer 3

http://www.devarticles.com/c/a/Java/Hibernate-Criteria-Queries-in-Depth/2/