How do you select a column using Hibernate?

java mysql hibernate hibernate-criteria
ThreaT picture ThreaT · May 18, 2012 · Viewed 61.7k times · Source

I would like to select a single column instead of a whole object, using Hibernate. So far I have this:

 List<String> firstname = null;

 firstname = getSession().createCriteria(People.class).list();

My problem is that the above code returns the whole People table as an object instead of just "firstname". I'm not sure how to specify to only return "firstname" instead of the whole object.

Answer

rizzz86 picture rizzz86 · May 18, 2012

You can set the Projection for this like:

.setProjection(Projections.property("firstname"))

With this you can only get the firstname in return.

I have found another link on stack with the same scenario. Hope this will also help How to use hibernate criteria to return only one element of an object instead the entire object?

Related questions

Hibernate Criteria Query to get specific columns

I am using Criteria Query in my code. It always fires select * from ... Instead I want to neglect one column(field) from my query as that field have large number of data stored in bytes. And that causing performance issue. …

Read More
Left join using hibernate criteria

I have two entity: Issue and Issue_Tracker. I am using Hibernate 3.6. SELECT `issues`.`issue_id`, `issues`.`issue_raised_date`, `issues`.`issue_description`, `issue_tracker`.`tracker_status` FROM `issues` LEFT JOIN `issue_tracker` ON `issues`.`issue_id` = `issue_tracker`.`issue_…

Read More
Hibernate CriteriaBuilder to join multiple tables

I'm trying to join 4 tables using hibernate criteriabuilder.. Below are the tables respectively.. ` @Entity public class BuildDetails { @Id private long id; @Column private String buildNumber; @Column private String buildDuration; @Column private String projectName; } @Entity public class CodeQualityDetails{ @Id private long …

Read More