Java Hibernate Create Native Query javax.persistence.TransactionRequiredException: Executing an update/delete query

Question

I have this problem, using native query on Hibernate. This the query :

Query query = session.createSQLQuery(
"UPDATE InvoiceItems SET current_balance = '"+current_balance+"' WHERE record_id = '"+record_id+"'");
query.executeUpdate();

but i get this error when run the query :

javax.persistence.TransactionRequiredException: Executing an update/delete query

any suggest ? i have try with this way : TransactionRequiredException Executing an update/delete query

Then why do the queries treat the fields as text fields? And why aren't you using parameterized queries? Maybe start with a tutorial, as you seem to have a lot of things wrong. — Kayaman, Jan 24 '20 at 10:13

score 1 · Accepted Answer · edited Jan 24 '20 at 10:40

1

You need a transaction.

Transaction txn = session.beginTransaction();
Query updateQuery = session.createQuery("UPDATE Post p SET p.title = ?1, p.body = ?2 WHERE p.id = ?3");
updateQuery.setParameter(1, title);
updateQuery.setParameter(2, body);
updateQuery.setParameter(3, id);
updateQuery.executeUpdate();
txn.commit();

from https://www.baeldung.com/jpa-transaction-required-exception

edited Jan 24 '20 at 10:40

Youcef LAIDANI

55,661
15
90
140

answered Jan 24 '20 at 10:28

JavaMan

1,142
12
22

Java Hibernate Create Native Query javax.persistence.TransactionRequiredException: Executing an update/delete query

1 Answers1