createNativeQuery with mapping not working after migrating to Hibernate 5.4.32

Hibernate ORM
1

Hi!
we recently switched to Hibernate 5.4.32 from 5.4.25 final. The following code started failing with the following exception trace

	at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1423)
	at java.lang.Thread.run(Thread.java:748)
Caused by: org.hibernate.MappingException: Unknown SqlResultSetMapping [GetRoutePackageResponseMapper]
	at org.hibernate.query.internal.NativeQueryImpl.setResultSetMapping(NativeQueryImpl.java:150)
	at org.hibernate.internal.AbstractSharedSessionContract.createNativeQuery(AbstractSharedSessionContract.java:1044)
	... 152 more

Code to retrieve Result from  a stored procedure
private OrderResponse getOrder(String orderId) {
  return (OrderResponse) entityManager
                    .createNativeQuery("select * from pkg_order.getOrder(?)", "OrderResponseMapper")
                    .setParameter(1, orderId)
                    .getSingleResult();
}
@SqlResultSetMapping(
        name = "OrderResponseMapper",
        classes = @ConstructorResult(
                targetClass = OrderResponse.class,
                columns = {
                        @ColumnResult(name = "ORDERID", type = String.class),
                        @ColumnResult(name = "DATE", type = String.class),
                        @ColumnResult(name = "STATUS", type = String.class)
                }
        )
)
@AllArgsConstructor
@Data
public class OrderResponse {
    private String orderId;
    private String date;
    private String status;
}

The same code works with 5.4.25 final. We did not make any other change.
This map namedSqlResultSetMappingMap in empty in NamedQueryRepository after the upgrade

2

Since this class is not an entity, I guess that you also updated something else other than Hibernate e.g. Spring? Did you change the class scanning or did the new Spring version change the package scanning? I guess that this class is simply not scanned anymore by Hibernate and due to that, will not pick up the result set mapping.

3

Thanks for the reply @beikov, Yes we did but to debug this I upgraded only the hibernate dependency and it is still not working. If we revert the change it is working. The spring boot data version 2.4.1 uses Hibernate 5.4.25.Final which is working for a long time.
Not working


        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
            <version>2.4.1</version>
            <exclusions>
                <exclusion>
                    <groupId>org.hibernate</groupId>
                    <artifactId>hibernate-core</artifactId>
                </exclusion>
            </exclusions>
        </dependency>
        <dependency>
            <groupId>org.hibernate</groupId>
            <artifactId>hibernate-core</artifactId>
            <version>5.4.32.Final</version>
        </dependency>

Working

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
            <version>2.4.1</version>
       </dependency>

There is a change between 5.4.32.Final and 5.4.25.Final which is causing the problem.

4

Please try out the different versions between 5.4.25.Final and 5.4.32.Final and let us know from which version on it starts failing.