Spring Boot 3.0.2升级后Hibernate/JPA 6更新查询验证失败

问题场景 #

原有JPA更新方法在Spring Boot升级前可正常运行，升级至3.0.2版本后触发类型不匹配的验证错误：

原有JPA更新方法 #

@Modifying( clearAutomatically = true )
@Query( "update versioned LookupMaster set state =  'PUBLISHED' , value = newValue, newValue = null, updatedDate = current_timestamp where ( name = :tableName and state = 'MODIFIED')" )
void commitLookupTableChanges( String tableName );

报错信息 #

Caused by: java.lang.IllegalArgumentException: org.hibernate.query.SemanticException: The assignment expression type [java.lang.String] did not match the assignment path type [com.nokia.nsw.lookuptable.model.RowState] for the path [alias_2093546827.state] [update versioned LookupMaster set state =  'PUBLISHED' , value = newValue, newValue = null, updatedDate = current_timestamp where ( name = :tableName and state = 'MODIFIED')]

RowState枚举定义 #

public enum RowState {
    MODIFIED, DELETED, PUBLISHED
}

解决方案 #

Spring Boot 3.x对应的Hibernate 6.x版本增强了JPQL的语义校验，不再自动将字符串字面量转换为枚举类型，需按以下方式修改JPQL：

• 方案1：直接引用枚举类的全限定名+枚举值
  修改state的赋值和条件判断部分，使用枚举的完整类路径加枚举值的格式：

  @Modifying( clearAutomatically = true )
  @Query( "update versioned LookupMaster set state = com.nokia.nsw.lookuptable.model.RowState.PUBLISHED , value = newValue, newValue = null, updatedDate = current_timestamp where ( name = :tableName and state = com.nokia.nsw.lookuptable.model.RowState.MODIFIED)" )
  void commitLookupTableChanges( String tableName );
  

• 方案2：通过命名参数传递枚举实例
  如果需要动态调整枚举值，或追求代码简洁性，可以将枚举作为方法参数传入：

  @Modifying( clearAutomatically = true )
  @Query( "update versioned LookupMaster set state = :publishedState , value = newValue, newValue = null, updatedDate = current_timestamp where ( name = :tableName and state = :modifiedState)" )
  void commitLookupTableChanges( String tableName, @Param("publishedState") RowState publishedState, @Param("modifiedState") RowState modifiedState );
  

  调用方法时直接传入RowState.PUBLISHED和RowState.MODIFIED即可。

说明 #

Hibernate 6.x严格执行JPQL的类型匹配规则，字符串字面量无法直接赋值给枚举类型字段，必须显式指定枚举的合法引用方式，才能通过语义校验。

内容的提问来源于stack exchange，提问作者user3080775