JPA Query selecting only specific columns without using Criteria Query?

by

Yes, like in plain sql you could specify what kind of properties you want to select:

SELECT i.firstProperty, i.secondProperty FROM ObjectName i WHERE i.id=10

Executing this query will return a list of Object[], where each array contains the selected properties of one object.

Another way is to wrap the selected properties in a custom object and execute it in a TypedQuery:

String query = "SELECT NEW CustomObject(i.firstProperty, i.secondProperty) FROM ObjectName i WHERE i.id=10";
TypedQuery<CustomObject> typedQuery = em.createQuery(query , CustomObject.class);
List<CustomObject> results = typedQuery.getResultList();

Examples can be found in this article.

UPDATE 29.03.2018:

@Krish:

@PatrickLeitermann for me its giving “Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: Unable to locate class ***” exception . how to solve this ?

I guess you’re using JPA in the context of a Spring application, don’t you? Some other people had exactly the same problem and their solution was adding the fully qualified name (e. g. com.example.CustomObject) after the SELECT NEW keywords.

Maybe the internal implementation of the Spring data framework only recognizes classes annotated with @Entity or registered in a specific orm file by their simple name, which causes using this workaround.

More Related Contents:

  1. JPA CascadeType.ALL does not delete orphans
  2. How can I validate two or more fields in combination?
  3. Storing a Map using JPA
  4. JPA support for Java 8 new date and time API
  5. How to properly express JPQL “join fetch” with “where” clause as JPA 2 CriteriaQuery?
  6. Hibernate – @ElementCollection – Strange delete/insert behavior
  7. JPA: unidirectional many-to-one and cascading delete
  8. In JPA 2, using a CriteriaQuery, how to count results
  9. How do I properly cascade save a one-to-one, bidirectional relationship on primary key in Hibernate 3.6
  10. Silently ignored remove()
  11. JPA Criteria builder IN clause query
  12. How to define unidirectional OneToMany relationship in JPA
  13. Hibernate generates negative id values when using a sequence
  14. java.lang.IllegalStateException: Multiple representations of the same entity with @ManyToMany 3 entities
  15. Rollback on every checked exception, whenever I say @Transactional
  16. Hibernate triggering constraint violations using orphanRemoval
  17. JPA Criteria Tutorial [closed]
  18. Really dynamic JPA CriteriaBuilder
  19. Change Table Name of an Entity on runtime? [duplicate]
  20. JPA Select latest instance for each item
  21. How to properly use findBySomeOtherId not findById in Spring data jpa?
  22. Bypass GeneratedValue in Hibernate (merge data not in db?)
  23. How does the FetchMode work in Spring Data JPA
  24. How to configure JPA for testing in Maven
  25. @GeneratedValue polymorphic abstract superclass over MySQL
  26. GenerationType.AUTO vs GenerationType.IDENTITY in hibernate
  27. Native query with named parameter fails with “Not all named parameters have been set”
  28. When should EntityManagerFactory instance be created/opened?
  29. java.lang.ClassNotFoundException: javax.persistence.Persistence cannot be found with JPA
  30. How to use Postgres JSONB datatype with JPA?

Leave a Comment