Criteria Query

noone · **Joined:** Thu Sep 23, 2004 11:53 am **Posts:** 83

Hibernate version:
3.1
Mapping documents:
NA
Code between sessionFactory.openSession() and session.close():
NA
Full stack trace of any exception that occurs:
NA
Name and version of the database you are using:
NA
The generated SQL (show_sql=true):
NA
Debug level Hibernate log excerpt:
NA

Can I return a single column using Criteria Queries? Example, If I have entity
Cat {
Name
Color
}

and I only want to return Name not the entire entity.

pksiv · **Posted:** Tue Sep 13, 2005 1:29 pm

noone wrote:

Hibernate version:
3.1

Can I return a single column using Criteria Queries? Example, If I have entity
Cat {
Name
Color
}

and I only want to return Name not the entire entity.

Not using Criteria queries. But you can using HQL easy enough.

moonlight · **Joined:** Mon Aug 29, 2005 9:46 am **Posts:** 102

As far as I know... No, it can't happen. But you could use "createQuery" instead and select only the column. Or you could get the object and ignore the other columns, using only the one you want.

eyalg · **Joined:** Tue Jun 14, 2005 12:44 pm **Posts:** 19

How about trying to set a projection on the column (property) name? You will receive only the requested column.

Code:

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

Good luck.

AkshayL · **Joined:** Tue Aug 28, 2012 1:35 am **Posts:** 1

eyalg wrote:

How about trying to set a projection on the column (property) name? You will receive only the requested column.

Code:

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

Good luck.

Thanks buddy. Projection works! :)