问 Spring Data JPA -从字符串转换日期和/或时间时转换失败

EN

我使用的是Spring Boot和Spring JPA。我有一个带有自定义 @Query 方法的存储库类。

public interface MarketForceRepository extends CrudRepository<MarketForceComment, Integer> {
    @Query("SELECT c FROM MarketForceComment c WHERE c.property.id = ?1 and c.commentDate >= '?1' AND  c.commentDate <= '?2'")
    List<MarketForceComment> getByPropAndDate(Integer propID, LocalDate start, LocalDate end);
    @Query("SELECT c FROM MarketForceComment c WHERE c.property.id IN ?1 and c.commentDate >= '?2' AND c.commentDate <= '?3'")
    List<MarketForceComment> getByPropsAndDates(List<Integer> propIDs, LocalDate start, LocalDate end);
}

MarketForceComment 类如下(部分)：

@Table(name = "MarketForceComment", schema = "dmb")
@Entity
public class MarketForceComment {
    @ManyToOne
    @JoinColumn(name = "PropertyID")
    private Property property;
    @Column(name = "CommentDate")
    private LocalDate commentDate;
    @Column(name = "Level")
    private int level;
    @Column(name = "Subject")
    private String subject;
    @Column(name = "Details", columnDefinition = "text")
    private String details;
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "ID")
    private Integer id;  
}

每当我尝试运行query方法时：

@Override
public List<CommentDTO> getCommentsByStore(int storeID, LocalDate date) {
    List<CommentDTO> dtoList = new ArrayList<>();
    marketRepo.getByPropAndDate(storeID, date.plusMonths(1), date)
            .forEach(c -> dtoList.add(mapper.map(c, CommentDTO.class)));
    guestRepo.getByPropAndDate(storeID, date.plusMonths(1).atStartOfDay(), date.atStartOfDay())
            .forEach(c -> dtoList.add(mapper.map(c, CommentDTO.class)));
    return dtoList;
}

我收到以下错误： com.microsoft.sqlserver.jdbc.SQLServerException: Conversion failed when converting date and/or time from character string.

我有点困惑。这似乎是一个格式问题(数据库管理系统想要一个'yyyy-MM-dd‘或类似的格式)，但我认为Java的LocalDate会被表达/转换成数据库系统可以解析的格式。

任何建议都将不胜感激。谢谢。

编辑：

作为参考，基本故障是参数(?1，?2，？3)的顺序：

public interface MarketForceRepository extends CrudRepository<MarketForceComment, Integer> {
    @Query("SELECT c FROM MarketForceComment c WHERE c.property.id = ?1 and c.commentDate >= ?2 AND  c.commentDate <= ?3")
    List<MarketForceComment> getByPropAndDate(Integer propID, LocalDate start, LocalDate end);
    @Query("SELECT c FROM MarketForceComment c WHERE c.property.id IN ?1 and c.commentDate >= ?2 AND c.commentDate <= ?3")
    List<MarketForceComment> getByPropsAndDates(List<Integer> propIDs, LocalDate start, LocalDate end);
}