Hibernate查询实例化报错：无法解析UserBatchCountDto类

问题描述 #

在Spring Boot项目中使用Hibernate执行自定义JPQL查询时，仓库接口UsersRepository的@Query方法尝试通过短名称实例化UserBatchCountDto获取聚合数据，但Hibernate抛出SemanticException，提示无法解析该类。使用全类名实例化DTO时查询正常，但希望用更简洁的写法。

报错信息 #

Caused by: org.hibernate.query.SemanticException: Could not resolve class 'UserBatchCountDto' named for instantiation

相关代码 #

UsersRepository.java

import static org.test.model.UserBatchCountDto.*;

@Repository
public interface UsersRepository extends JpaRepository<UserEntity, UserEntity.UserEntityId> {

      @Query("""
             SELECT new UserBatchCountDto(u.batchId, COUNT(u))
             FROM UserEntity u
             WHERE u.dateUserReceived BETWEEN :startDate AND :endDate
             GROUP BY u.batchId""")
      List<UserBatchCountDto> findUserCountPerBatchForDateRange(@Param("startDate") ZonedDateTime startDate, @Param("endDate") ZonedDateTime endDate);
}

UserBatchCountDto.java

@Data
@Builder
@AllArgsConstructor
@NoArgsConstructor
public class UserBatchCountDto {
   private String batchId;
   private Long batchRecordCount;
}

UserEntity.java

@Builder
@Data
@Entity
@EntityListeners(AuditingEntityListener.class)
@Table(name = "user_submissions")
@AllArgsConstructor
@NoArgsConstructor
@IdClass(UserEntity.UserEntityId.class)
public class UserEntity {

    @Column(name = "batch_id")
    @NotNull
    private String batchId;

    @Column(name = "date_user_received")
    @NotNull
    private ZonedDateTime dateUserReceived;

}

已尝试操作 #

• 验证DTO包结构与导入语句匹配
• 检查DTO导入拼写无误
• 确认DTO已编译并在项目构建路径中
• 重启应用服务器排查缓存/加载问题
• 全类名实例化DTO可正常运行，但希望简化写法

解决方案 #

1. 用Hibernate的@Import注解（Hibernate 5.4+支持） #

在仓库接口上添加@org.hibernate.annotations.Import注解，指定要导入的DTO类，JPQL就能识别短名称：

import org.hibernate.annotations.Import;
import org.test.model.UserBatchCountDto;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;
import org.springframework.stereotype.Repository;

@Repository
@Import(UserBatchCountDto.class)
public interface UsersRepository extends JpaRepository<UserEntity, UserEntity.UserEntityId> {

      @Query("""
             SELECT new UserBatchCountDto(u.batchId, COUNT(u))
             FROM UserEntity u
             WHERE u.dateUserReceived BETWEEN :startDate AND :endDate
             GROUP BY u.batchId""")
      List<UserBatchCountDto> findUserCountPerBatchForDateRange(@Param("startDate") ZonedDateTime startDate, @Param("endDate") ZonedDateTime endDate);
}

2. 改用Spring Data接口投影 #

通过定义投影接口，让Spring Data自动映射查询结果，无需手动实例化DTO：

定义投影接口

public interface UserBatchCountProjection {
    String getBatchId();
    Long getBatchRecordCount();
}

修改仓库方法

@Query("""
       SELECT u.batchId as batchId, COUNT(u) as batchRecordCount
       FROM UserEntity u
       WHERE u.dateUserReceived BETWEEN :startDate AND :endDate
       GROUP BY u.batchId""")
List<UserBatchCountProjection> findUserCountPerBatchForDateRange(@Param("startDate") ZonedDateTime startDate, @Param("endDate") ZonedDateTime endDate);

3. 保留全类名写法（最稳妥） #

如果不想改动配置或结构，直接使用全类名是最直接的方案，虽然代码稍长但不会有解析问题：

@Query("""
       SELECT new org.test.model.UserBatchCountDto(u.batchId, COUNT(u))
       FROM UserEntity u
       WHERE u.dateUserReceived BETWEEN :startDate AND :endDate
       GROUP BY u.batchId""")

内容的提问来源于stack exchange，提问作者Dev6174