No Dialect mapping for JDBC type: 1111

by

I got the same error because my query returned a UUID column. To fix that I returned the UUID column as varchar type through the query like “cast(columnName as varchar)”, then it worked.

Example:

public interface StudRepository extends JpaRepository<Mark, UUID> {

    @Modifying
    @Query(value = "SELECT Cast(stuid as varchar) id, SUM(marks) as marks FROM studs where group by stuid", nativeQuery = true)
    List<Student> findMarkGroupByStuid();

    public static interface Student(){
        private String getId();
        private String getMarks();
    }
}

More Related Contents:

  1. When are connections returned to the connection pool with Spring JPA (Hibernate) Entity Manager?
  2. Error creating bean with name ‘entityManagerFactory’ defined in class path resource : Invocation of init method failed
  3. How does the FetchMode work in Spring Data JPA
  4. How to fetch FetchType.LAZY associations with JPA and Hibernate in a Spring Controller
  5. Unable to get spring boot to automatically create database schema
  6. Hibernate: Automatically creating/updating the db tables based on entity classes
  7. @Transactional method called from another method doesn’t obtain a transaction
  8. How to set up default schema name in JPA configuration?
  9. Why does Hibernate disable INSERT batching when using an IDENTITY identifier generator
  10. @GeneratedValue polymorphic abstract superclass over MySQL
  11. Spring boot JPA insert in TABLE with uppercase name with Hibernate
  12. Spring data JPA and hibernate detached entity passed to persist on ManyToMany relationship
  13. Can I combine a @Query definition with a Specification in a Spring Data JPA repository method?
  14. Could not commit JPA transaction: Transaction marked as rollbackOnly
  15. Change database schema during runtime based on logged in user
  16. Spring JpaRepository – Detach and Attach entity
  17. Hibernate: Create Mysql InnoDB tables instead of MyISAM
  18. How to map sql native query result into DTO in spring jpa repository?
  19. Difference between save and saveAndFlush in Spring data jpa
  20. The onFlushDirty Hibernate Interceptor method is never called
  21. spring data jpa @query and pageable
  22. Hibernate, spring, JPS & isolation – custom isolation not supported
  23. Spring, JPA, and Hibernate – how to increment a counter without concurrency issues
  24. How to use Spring Boot with MySQL database and JPA?
  25. Mapping JPA or Hibernate projection query to DTO (Data Transfer Object)
  26. java.lang.IllegalStateException: No transactional EntityManager available
  27. How to setup Hibernate to read/write to different datasources?
  28. FetchMode join makes no difference for ManyToMany relations in spring JPA repositories
  29. TransactionRequiredException Executing an update/delete query
  30. How to find distinct rows with field in list using JPA and Spring?

Leave a Comment