Return Hibernate entity on UPDATE query

Question

I'm trying to use hibernate to make a simple SQL UPDATE query and map the result row into Hibernate entity (Using the createSQLQuery).

String updateQuery = 
        String.format("UPDATE \"user\" "
                + "SET chips_balance=chips_balance + %d, diamonds_balance=diamonds_balance + %d "
                + "WHERE id=%d", chips_delta, diamonds_delta, userId); 

        User user = (User)session.createSQLQuery(updateQuery).uniqueResult();

This throws an Exception:

org.hibernate.exception.GenericJDBCException: could not extract ResultSet

Cause:

org.postgresql.util.PSQLException: No results were returned by the query.

How can I make this work? (Using the RETURNING keyword)

Shvalb · Accepted Answer · 2021-08-31 15:32:19Z

8

This is how to achieve it:

String updateQuery = 
        String.format(  "UPDATE \"user\" "
            +       "SET chips_balance=chips_balance + %d, diamonds_balance=diamonds_balance + %d "
            +       "WHERE id=%d "
            +       "RETURNING *", 100, 5, 64); 
            
User user = (User) session.createSQLQuery(updateQuery)
        .addEntity(User.class)
        .uniqueResult();

The key point here is to use "RETURNING *" and map it to the entity using .addEntity(User.class)

edited Aug 31, 2021 at 15:32

user11814208

answered Feb 11, 2016 at 21:15

Shvalb

1,9254 gold badges32 silver badges66 bronze badges

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

Collectives™ on Stack Overflow

Return Hibernate entity on UPDATE query

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