如何在JPQL(Spring JPA查询)中使用JOIN进行UPDATE语句? [英] How can I do an UPDATE statement with JOIN in JPQL (Spring JPA Queries)?

问题描述

这是此问题的扩展在SQL中使用JOIN更新语句，但是我正在尝试使用Spring Data JPQL.

This is an extension of this question Update Statement with JOIN in SQL but I am trying to use Spring Data JPQL.

我正在尝试按以下方式在JPQL中将Update和JOIN一起使用

I am trying to use Update along with JOIN in JPQL as follows

@Modifying
@Query("UPDATE TotalValue tv JOIN LineItems li WHERE li.totalValue.totalValueId=:totalValuedId SET tv.totalAmount =sum(li.itemTotalValue) ")
void calculateTotalAmount(@Param("totalValuedId") Long totalValuedId);

但是，我得到如下错误

org.hibernate.hql.internal.ast.QuerySyntaxException:期望设置"，找到"JOIN"

org.hibernate.hql.internal.ast.QuerySyntaxException: expecting "set", found 'JOIN'

JPQL中无法进行UPDATE和JOIN吗?有什么选择.谢谢

Is UPDATE and JOIN not possible in JPQL ? What is the alternative. Thanks

推荐答案

JPQL语法似乎表明在UPDATE语句中实际上不可能进行JOIN.

The JPQL syntax seems to indicate that a JOIN is actually not possible in an UPDATE statement.

这篇关于如何在JPQL(Spring JPA查询)中使用JOIN进行UPDATE语句?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！