HQL报错期望java.time.Duration，但方法参数为LocalDateTime

AI 小北

2026-8-3

Hibernate 6 JPQL日期运算参数类型不匹配问题

问题现象

在JpaRepository中编写JPQL查询，接收一个String和3个LocalDateTime参数，应用启动正常，但调用查询时抛出类型不匹配错误：

Argument [2023-01-23T11:43:59] of type [java.time.LocalDateTime] did not match parameter type [java.time.Duration (n/a)]

参数已被RestController正确解析，但Hibernate生成查询时出现异常。

相关代码

Repository代码

public interface ExchangePairRepository extends JpaRepository<MyEntity, Long> {

@Query("SELECT ep.unit FROM MyEntity ep WHERE ep.id= :id AND ((ep.context = 'start' AND ((ep.unit = 'day' AND (:start+ ep.duration day) > :now) "
        + "OR (ep.unit = 'month' AND (:start+ ep.duration month) > :now))) OR (ep.context = 'end' AND ((ep.unit = 'day' AND (:now + ep.duration day) > :end) "
        + "OR (ep.unit = 'month' AND (:now + ep.duration month) > :end)) ))")
List<String> findViable(@Param("matNrOrig") String id, @Param("start") LocalDateTime start, @Param("end") LocalDateTime end,
        @Param("now") LocalDateTime now);
}

实体类代码

@Entity
@Table(name = "my_entity")
@Data
public class MyEntity{
    (...)

@Column(name = "id_orig")
private String idOrig;

@Column(name = "id_target")
private String idTarget;

@Column(name = "context")
private String context;

@Column(name = "duration")
private int duration;

@Column(name = "unit")
private String unit;
}

使用环境：Hibernate 6.1.6.Final、Spring Boot 3.0.1、Java 17。