[ACCEPTED]-How to use hibernate criteria to return only one element of an object instead the entire object?-criteria

Accepted answer

Score: 47

I think you could do that with Projections, something 1 like

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

Score: 20

Similarly you can also:

Criteria criteria = session.createCriteria(bob.class);

criteria.add(Expression.gt("id", 10));

criteria.setProjection(Projections.property("id"));

criteria.addOrder(Order.asc("id"));

return criteria.list();

Score: 8

or setProjection(Projections.id())

Score: 2

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

Score: 2

SessionFactory sessionFactory;    
Criteria crit=sessionFactory.getCurrentSession().createCriteria(Model.class);
crit.setProjection(Projections.property("id"));
List result = crit.list();

This code code will give you list of ids 3 in the model class like [1,2,3]. if you wants to 2 get the array list like [{"id":1},{"id":2}] then use the following 1 code

SessionFactory sessionFactory;    
Criteria crit=sessionFactory.getCurrentSession().createCriteria(Model.class); 
crit.setProjection(Projections.property("id").as("id")); 
List result = crit.setResultTransformer(Criteria.ALIAS_TO_ENTITY_MAP).list();

Score: 1

Another option (though a bit un hibernate-esque) is 1 to use "raw" sql, like this:

List<Long> myList = session.createSQLQuery("select single_column from table_name")
          .addScalar("single_column", StandardBasicTypes.LONG).list();

Source: stackoverflow.com

Hibernate query a foreign key field with ID

Hibernate Criteria: distinct entities and then limit

Referring to an earlier aliased field in a criteria query

SQL 'LIKE' operator in Hibernate Criteria API

Search by nested property of collection field with criteria api

Sed with multiple criteria

Does between in HQL compare strictly or not?

Hibernate Mapping Package

Null vs empty collections in Hibernate

Differerence between hibernate types: boolean, yes_no, true_false

Cookie Warning

We use cookies to improve the performance of the site. By staying on our site, you agree to the terms of use of cookies.