Spring data jpa动态查询不适用于Date类型参数

Question

我使用spring数据jpa，为了生成动态查询，我使用spring数据jpa规范。除了日期之外，它还能正常工作。我得到了以下例外：

 Parameter value [2017-06-01] did not match expected type [java.time.LocalDate (n/a)]; nested exception is java.lang.IllegalArgumentException: Parameter value [2017-06-01] did not match expected type [java.time.LocalDate (n/a)]] 

但是我传入的参数值是java.util.Date类型。有什么理由？

以下是我的实体：

private String name;

@Column(name = "user_id")
private Long userId;

@Column(name = "version_id")
@Id
@GeneratedValue(strategy=GenerationType.IDENTITY)
private Long versionId;

@Column(name = "created_date")
private LocalDate createdDate;

这里是

public ViewDetailSpecificationsBuilder createSearchSpecifications(ViewSearch view) {
    ViewDetailSpecificationsBuilder builder = new ViewDetailSpecificationsBuilder();
    if (StringUtils.isNotBlank(view.getName())) {
        builder.with("name", Operation.DEFAULT, view.getName());
    }       
    if (view.getStartDate() != null) {
        DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd");
        LocalDate date = LocalDate.parse(view.getStartDate(), formatter);
        builder.with("createdDate", Operation.GREATHERTHANEQUALTO, date);
    }
    if (view.getVersion() != null) {
        builder.with("version", Operation.DEFAULT, view.getVersion());
    }
    return builder;
}

这引发了以下异常：

org.springframework.dao.InvalidDataAccessApiUsageException: Parameter value [Thu%Jun%01%00:00:00%AMT%2017] did not match expected type [java.util.Date (n/a)]; nested exception is java.lang.IllegalArgumentException: Parameter value [Thu%Jun%01%00:00:00%AMT%2017] did not match expected type [java.util.Date (n/a)]

如果我格式化开始日期（formatter.format（开始日期））它抛出上述异常。

Answer 1

不，您传递的不是字符串，就是java。sql。日期