How to map the result set of a JPA NativeQuery to a POJO using SqlResultSetMapping

by

@SqlResultSetMapping annotation should not be put on a POJO. Put it at (any) @Entity class. “Unknown SqlResultSetMapping [foo]” tells you, that JPA provider doesn’t see any mapping under name ‘foo’. Please see another answer of mine for the correct example

More Related Contents:

  1. Mapping PostgreSQL JSON column to a Hibernate entity property
  2. Error creating bean with name ‘entityManagerFactory’ defined in class path resource : Invocation of init method failed
  3. How to choose the id generation strategy when using JPA and Hibernate
  4. JPQL Create new Object In Select Statement – avoid or embrace?
  5. Hibernate, @SequenceGenerator and allocationSize
  6. What is the difference between Unidirectional and Bidirectional JPA and Hibernate associations?
  7. How to remove entity with ManyToMany relationship in JPA (and corresponding join table rows)?
  8. JPA/Hibernate Native Queries do not recognize Parameters
  9. What is the easiest way to ignore a JPA field during persistence?
  10. @Transactional method called from another method doesn’t obtain a transaction
  11. @PreUpdate and @Prepersist in hibernate/JPA (using session)
  12. Hibernate bidirectional @ManyToOne, updating the not owning side not working
  13. JPA how to make composite Foreign Key part of composite Primary Key
  14. Spring boot JPA insert in TABLE with uppercase name with Hibernate
  15. Getting [SQLITE_BUSY] database file is locked with select statements
  16. Silently ignored remove()
  17. Hibernate/JPA DB Schema Generation Best Practices
  18. How to set a default query timeout with JPA and Hibernate?
  19. Is it possible to dynamically define column names in Hibernate / JPA?
  20. Change database schema during runtime based on logged in user
  21. Hibernate: “Field ‘id’ doesn’t have a default value”
  22. How to map sql native query result into DTO in spring jpa repository?
  23. Persisting UUID in PostgreSQL using JPA
  24. Batch inserts with JPA/EJB3
  25. Name attribute in @Entity and @Table
  26. Why should anybody put annotations on the getters or setters when using JPA to map the classes?
  27. Hibernate using JPA (annotated Entities) and liquibase
  28. Mapping JPA or Hibernate projection query to DTO (Data Transfer Object)
  29. JPA: Override Auto generated ID [duplicate]
  30. TransactionRequiredException Executing an update/delete query

Leave a Comment