Spring JPA native query with Projection gives “ConverterNotFoundException”

by

with spring data you can cut the middle-man and simply define

public interface IdsOnly {
  Integer getId();
  String getOtherId();
}

and use a native query like;

@Query(value = "Id, OtherId from TestTable where CreationDate > ?1 and Type in (?2)", nativeQuery = true)
    public Collection<IdsOnly> findEntriesAfterDate(Date creationDate, List<Integer> types);

check out https://docs.spring.io/spring-data/jpa/docs/current/reference/html/#projections

More Related Contents:

  1. Dynamic spring data jpa repository query with arbitrary AND clauses
  2. setMaxResults for Spring-Data-JPA annotation?
  3. Spring Data JPA – ZonedDateTime format for json serialization
  4. How does the FetchMode work in Spring Data JPA
  5. Handling soft-deletes with Spring JPA
  6. Filtering database rows with spring-data-jpa and spring-mvc
  7. Spring CrudRepository findByInventoryIds(List inventoryIdList) – equivalent to IN clause
  8. Can I combine a @Query definition with a Specification in a Spring Data JPA repository method?
  9. why do we have to use @Modifying annotation for queries in Data Jpa
  10. JPA: update only specific fields
  11. Spring-Data FETCH JOIN with Paging is not working
  12. Does Spring Data JPA have any way to count entites using method name resolving?
  13. Why use returned instance after save() on Spring Data JPA Repository?
  14. Spring JpaRepository – Detach and Attach entity
  15. Use abstract super class as parameter for Spring data repository
  16. How to replace table name with parameter value while using Spring Data JPA nativeQuery
  17. How to use @Transactional with Spring Data?
  18. Spring-boot: required a bean named ‘entityManagerFactory’ that could not be found
  19. JPQL Like Case Insensitive
  20. Spring Data JPA: query ManyToMany
  21. Encoded password does not look like BCrypt
  22. How to store @Query sql in external file for CrudRepository?
  23. Spring Data JPA find by embedded object property
  24. Spring Data JPA findOne() change to Optional how to use this?
  25. How to enable LockModeType.PESSIMISTIC_WRITE when looking up entities with Spring Data JPA?
  26. Best way of handling entities inheritance in Spring Data JPA
  27. Autowiring fails: Not an managed Type
  28. How to persist LocalDate with JPA?
  29. Spring Data + JPA with multiple datasources but only one set of Repositories
  30. Externalize query in spring boot application

Leave a Comment