java - QuerySyntaxException: 表未映射 [更新表 BOMmodel 设置 PA13 = Materialvalue + ReqQTY ]

Question

如上所示，我正在尝试使用其他两列（Materialvalue，ReqQTY）的总和来更新一列

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Service;
import com.example.demo2.model.BOMmodel;

public interface BOMrepository extends JpaRepository<BOMmodel, String> {
    @Modifying
    @Query("Update Table BOMmodel Set PA13 = Materialvalue + ReqQTY ")
      int updatePA();
}

实体看起来像这样

@Table(name = "bom_table")
@Entity
public class BOMmodel {
    @Id
    @GeneratedValue(strategy=GenerationType.AUTO)
    public Long id;
    public String ComponentNo;
    public Float ReqQTY;
    public String MatGroup;
    public Float Materialvalue;
    public Float PA13;
    public String kw;

但我收到以下错误：

org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'controller': Unsatisfied dependency expressed through field 'BOMrepos'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'BOMrepository': Invocation of init method failed; nested exception is java.lang.IllegalArgumentException: Validation failed for query for method public abstract void com.example.demo2.repository.BOMrepository.updatePA()!

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'BOMrepository': Invocation of init method failed; nested exception is java.lang.IllegalArgumentException: Validation failed for query for method public abstract void com.example.demo2.repository.BOMrepository.updatePA()!

java.lang.IllegalArgumentException: org.hibernate.hql.internal.ast.QuerySyntaxException: Table is not mapped [Update Table BOMmodel Set PA13 = Materialvalue + ReqQTY ]

我做了一些研究，发现使用表名而不是实体是导致此错误的常见原因，但事实并非如此。那么请有其他想法吗？

标签： javamysqlspring-data-jpa

Answer 1

Update bom_table Set PA13 = Materialvalue + ReqQTY

用那个