Interface Projection in SpringBoot / Hibernate for an Enum

Question

I am trying to use Hibernate native queries to select a single column from the database. The column type is an enumeration.

Java

public interface TicketSummary {

    TicketStatus getSummary();
}

@Repository
public interface TicketRepository extends JpaRepository<Ticket, TicketIdentity> {

    @Query(value = "SELECT status AS summary FROM ticket_service.ticket WHERE entitlement_id IN (:entitlementId)", nativeQuery = true)
    List<TicketSummary> findAllTicketsStatusSummary(UUID[] entitlementId);
}

SQL

CREATE TYPE ticket_service.ticket_state AS ENUM( 
    'CREATED',
    'IN_PROGRESS',
    'BLOCKED',
    'CLOSED',
    'COMPLETED'
);

I continuously get the following error when querying.

exception captured: No Dialect mapping for JDBC type: 1111; nested exception is org.hibernate.MappingException: No Dialect mapping for JDBC type: 1111

Debugging

Placing a breakpoint inside JdbcResultMetadata.getHibernateType displays the following

Kindly assist me in finding a solution to the same. Thank you in advance.

https://stackoverflow.com/questions/28192547/no-dialect-mapping-for-jdbc-type-1111/30562066 — Kayis Rahman, Sep 25 '20 at 11:35
I'm guessing `TicketStatus` is an enum. How are you mapping it in the `Ticket` entity? Is it working properly for the entity? — drkblog, Sep 25 '20 at 11:57
@drkblog Yes if I use the Ticket pojo it correctly maps to the TicketStstus enum. Following are the annotations used — freshprinze, Sep 25 '20 at 12:30
@NotNull @Enumerated(EnumType.STRING) @Type(type = "pgsql_enum") private TicketStatus status; — freshprinze, Sep 25 '20 at 12:36

Interface Projection in SpringBoot / Hibernate for an Enum

0 Answers0