In JPA, does rollback occur for the native queries?

Question

I'm using JPA 1.0 with hibernate as my provider. Inside an entitymanager transaction, if a series of native queries are run (which include DELETE sql statements) and an error occurs, will the native queries rollback too on the error?

I ran into a deadlock problem in an oracle database and I noticed that it left the database inconsistent even though some of the transaction was rolled back. I'm wondering if the inconsistency resulted from the fact that one transaction succeeded but the other transaction rolled back but only up to a certain point?

Thanks..

Answer 1

A rollback doesn't rollback "JPQL queries" specifically, it rollbacks SQL statements and this includes SQL statements from "native queries".

Answer 2

Yes. The JPQL and native SQL queries are rolled back when an error occurs.