Hibernate Criteria Query to get specific columns

by

Use Projections to specify which columns you would like to return.

Example

SQL Query 

SELECT user.id, user.name FROM user;

Hibernate Alternative

Criteria cr = session.createCriteria(User.class)
    .setProjection(Projections.projectionList()
      .add(Projections.property("id"), "id")
      .add(Projections.property("Name"), "Name"))
    .setResultTransformer(Transformers.aliasToBean(User.class));

  List<User> list = cr.list();

More Related Contents:

  1. Hibernate 5 :- org.hibernate.MappingException: Unknown entity
  2. Using Hibernate’s ScrollableResults to slowly read 90 million records
  3. JPA and Hibernate – Criteria vs. JPQL or HQL
  4. The server time zone value ‘AEST’ is unrecognized or represents more than one time zone
  5. Unable to get spring boot to automatically create database schema
  6. Hibernate: Automatically creating/updating the db tables based on entity classes
  7. No Dialect mapping for JDBC type: 1111
  8. @GeneratedValue polymorphic abstract superclass over MySQL
  9. Spring boot JPA insert in TABLE with uppercase name with Hibernate
  10. Can Hibernate work with MySQL’s “ON DUPLICATE KEY UPDATE” syntax?
  11. Spring, Hibernate, Blob lazy loading
  12. How can I use MySQL assign operator(:=) in hibernate native query?
  13. How to transform a flat result set using Hibernate
  14. Hibernate Group by Criteria Object
  15. Enum in Hibernate, persisting as an enum
  16. When are connections returned to the connection pool with Spring JPA (Hibernate) Entity Manager?
  17. com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed
  18. SQL Error: 0, SQLState: 08S01 Communications link failure [duplicate]
  19. Invalid syntax error “type= MyISAM” in DDL generated by Hibernate
  20. Hibernate: Create Mysql InnoDB tables instead of MyISAM
  21. No matter what, I can’t batch MySQL INSERT statements in Hibernate
  22. com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source
  23. org.hibernate.InstantiationException: No default constructor for entity: : principal.Cliente
  24. Is there a more efficient way of making pagination in Hibernate than executing select and count queries?
  25. How to setup Hibernate to read/write to different datasources?
  26. Hibernate Criteria API: get n random rows
  27. Unable to get multiple Table entities through Stored procedure using hibernate
  28. Make hibernate backquote all table / column names
  29. No Database selected when retrieving from mysql website
  30. How to perform a non-polymorphic HQL query in Hibernate?

Leave a Comment