I'm using PostgreSQL and Spring data JPA to execute update as following ```@Transactional @Modifying...

# spring

[rajesh]

I'm using PostgreSQL and Spring data JPA to execute update as following

@Transactional
@Modifying(flushAutomatically = true, clearAutomatically = true)
@Query(
     "UPDATE posts SET comments_count = comments_count +1 WHERE post_id = :postId RETURNING comments_count",
      nativeQuery = true
)
fun incrementCommentCounter(@Param("postId") postId: Long): Int

As i'm using native query with RETURNING clause, it throws exception as

o.h.engine.jdbc.spi.SqlExceptionHelper   : A result was returned when none was expected.

How should i execute this query with spring boot?

[iamkdblue]

have you override jpa?

[kqr]

https://gitter.im/spring-projects/spring-data

[rajesh]

@iamkdblue what do you mean by override jpa?