Spring Data JPA: How can Query return Non- Entities Objects or List of Objects?

by

You can do something like

@NamedQuery(name="findWhatever", query="SELECT new path.to.dto.MyDto(e.id, e.otherProperty) FROM Student e WHERE e.id = ?1")

Then the MyDto object would just need a constructor defined with the correct fields i.e.

public MyDto(String id, String otherProperty) { this.id = id; this.otherProperty = otherProperty; }

More Related Contents:

  1. What’s the difference between JPA and Hibernate? [closed]
  2. Is it possible to use raw SQL within a Spring Repository
  3. Can someone explain mappedBy in JPA and Hibernate?
  4. JPA CascadeType.ALL does not delete orphans
  5. How does the FetchMode work in Spring Data JPA
  6. Hibernate – @ElementCollection – Strange delete/insert behavior
  7. ImprovedNamingStrategy no longer working in Hibernate 5
  8. @PreUpdate and @Prepersist in hibernate/JPA (using session)
  9. Hibernate bidirectional @ManyToOne, updating the not owning side not working
  10. Spring boot JPA insert in TABLE with uppercase name with Hibernate
  11. JPA/Hibernate Static Metamodel Attributes not Populated — NullPointerException
  12. How do I properly cascade save a one-to-one, bidirectional relationship on primary key in Hibernate 3.6
  13. Can I combine a @Query definition with a Specification in a Spring Data JPA repository method?
  14. Spring Data JPA: Batch insert for nested entities
  15. Silently ignored remove()
  16. Mapping array with Hibernate
  17. Refresh and fetch an entity after save (JPA/Spring Data/Hibernate)
  18. Hibernate generates negative id values when using a sequence
  19. Spring JpaRepository – Detach and Attach entity
  20. java.lang.IllegalStateException: Multiple representations of the same entity with @ManyToMany 3 entities
  21. How to map sql native query result into DTO in spring jpa repository?
  22. Difference between save and saveAndFlush in Spring data jpa
  23. spring data jpa @query and pageable
  24. Apparent connection leak detected with Hikari CP
  25. Hibernate triggering constraint violations using orphanRemoval
  26. Why has javax.persistence-api been replaced by jakarta.persistence-api in spring data jpa starter?
  27. Change Table Name of an Entity on runtime? [duplicate]
  28. How to make a database listener with java?
  29. JPA: difference between @JoinColumn and @PrimaryKeyJoinColumn?
  30. Java EE Architecture – Are DAO’s still recommended when using an ORM like JPA 2?

Leave a Comment