在hibernate + spring数据中的本地插入查询 [英] native insert query in hibernate + spring data

问题描述

我尝试将以下代码添加到spring data jpa repository中：

  @Query（insert into commit_activity_link（commit_id，activity_id ）VALUES（？1，？2））
 void insertLinkToActivity（long commitId，long activityId）; 
  

但是应用程序无法以异常开始：

由于：org.hibernate.hql.internal.ast.QuerySyntaxException：意外标记：第1行第59列附近的VALU [插入commit_activity_link（commit_id，activity_id）VALUES（？1，？ 2）]

我错了？

解决方案 b

  @Query（value =insert into commit_activity_link（commit_id，activity_id）VALUES（？1，？2），nativeQuery = true）
  

I tries to add following code to spring data jpa repository:

  @Query("insert into commit_activity_link (commit_id, activity_id) VALUES (?1, ?2)")
  void insertLinkToActivity(long commitId, long activityId);

But app can't start with exception:

Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: VALUES near line 1, column 59 [insert into commit_activity_link (commit_id, activity_id) VALUES (?1, ?2)]

Where i'm wrong?

解决方案

I had to add nativeQuery = true to @Query

@Query(value = "insert into commit_activity_link (commit_id, activity_id) VALUES (?1, ?2)", nativeQuery = true)

这篇关于在hibernate + spring数据中的本地插入查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！