本文介绍了尝试保存到MySQL日期时出现JpaRepository SQL语法错误的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我的MySQL表中有以下一行:

I have the following row in my MySQL Table:

https://i.stack.imgur.com/u0FC4.png

此列表示为:

    @Column(name="release")
    @DateTimeFormat(pattern = "yyyy-MM-dd")
    private LocalDate release;

它绑定到Thymeleaf形式,如下所示:

And it is bound to a Thymeleaf form like so:

    <label for="release">Release date</label>
    <input type="date"
      th:field="*{movie.release}"
      th:value="*{movie.release}"
      id="release"
      class="form-control mb-3">

现在,如果我直接将日期插入MySQL数据库,日期将被加载并在表格上设置为正确的日期: https://i.stack.imgur.com/e35lr.png 但是每次我尝试保存或编辑电影时,都会出现以下错误:

Now if I insert a date into the MySQL db directly, the date is loaded and set to the correct date on the form:https://i.stack.imgur.com/e35lr.pngBut every time I try to save or edit the movie I get the following error:

即使我将发行日期设置为null,Hibernate也不会保存电影.如果我完全删除了日期的@Column并将其从Thymeleaf表单中删除,则该对象将正确保存,不会出现错误.因为JpaRepository正在生成所有查询,所以我看不到语法可能是错误的.我也尝试过使用标准java.util.Date作为具有相同问题的类型.

Even if I set the release date to null Hibernate won't save the movie.If I completely remove the @Column for the date and remove it from the Thymeleaf form, the object is saved properly without errors. Because JpaRepository is generating all the queries I can't see how the Syntax could be wrong. I've also tried with standard java.util.Date as the type with the same issue.

删除@DateTimeFormat会出现以下错误:

Removing the @DateTimeFormat gives the following error:

使用Spring Boot 2.3.5.RELEASE

Using Spring Boot 2.3.5.RELEASE

推荐答案

原来问题出在MySQL中的列名上- release 是受保护的单词,使用时会引起查询问题.当我尝试删除该列时应该已经注意到,因为它不会像其他列那样自动填充名称...

Turns out the problem was with the column name in MySQL - release is a protected word and causes issues with the query when used. Should have noticed when I tried to drop the column, as it would not auto-fill the name like it does for other columns...

这篇关于尝试保存到MySQL日期时出现JpaRepository SQL语法错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-20 05:45
查看更多