Hibernate executeUpdate() throws exception for PostgreSQL native query with returning *

Question

Hibernate executeUpdate() for insert or update native query with returning * gives and exception and also does not update the tables.

SQLQuery query = session.createSQLQuery(
      "INSERT INTO public.account (username) VALUES ('xx'), ('yy'), ('zz') RETURNING user_id");

Transaction tx = session.beginTransaction();
query.executeUpdate();
tx.commit();

Exception:

org.postgresql.util.PSQLException: A result was returned when none was expected.

Laurenz Albe · Accepted Answer · 2019-03-15 10:25:00Z

2

executeUpdate() is only appropriate if the SQL statement does not return result rows.

Use iterate(), list() or scroll() instead.

answered Mar 15, 2019 at 10:25

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Hibernate executeUpdate() throws exception for PostgreSQL native query with returning *

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related