postgresql « Stored Procedure « JPA Q&A

  1. JPA Q&A
  2. Stored Procedure
  3. postgresql




1. JPA & PostgreSQL: How do I call a stored procedure with void return type?    stackoverflow.com

I'm trying to call a PL/pgSQL function that executes an update (language sql, returns void). I'm getting this exception: Internal Exception: org.postgresql.util.PSQLException: A result was returned when none was expected. persistence.xml: 

<named-native-query name="Clinic.deactivateByNotFoundInIncomingClinic">
  ...