title: How to update column in JPA native query which annothed with @Lob
body: <p>I have an entity class and repository. Here I'm trying to execute update query but not working.
  How to update Lob column in native query or any another solution on jpa query to update Lob column.</p>
  <pre><code>@Entity
  @Table(name = &quot;comment&quot;)      
  public class Comment implements Serializable {
  
  @Basic
  @Lob
  @Column(name=&quot;Article_COMMENT&quot;, columnDefinition=&quot;TEXT&quot;)
  private String articleComment;
  
  @Basic
  @Column(name = &quot;ID_ARTICLE&quot;)
  private Long articleId;
  
  }
  
  @Repository
  public interface commentRepository extends JpaRepository&lt;Comment, Long&gt; {
  
     @Query(value = &quot;UPDATE comment set articleComment=: articleComment WHERE articleId =: articleId&quot;, nativeQuery=true)
     void  updateComment(@Param(&quot;articleComment&quot;) String articleComment, @Param(&quot;articleId&quot;) Long articleId );
  
  }
  
  </code></pre>
  <p>Error:</p>
  <pre><code>No results were returned by query.
  
  JpaSystemException thrown with message: could not extract ResultSet; nested exception is org.hibernate.exception.GenericJDBCException: could not extract ResultSet
  
  </code></pre>