Can the isolation level be changed per transaction if using Hibernate?
I want to add it to the following code:
int num = entityManager.createNamedQuery("deleteUserInfo")
.setParameter("userId", userId).executeUpdate();
Asked
Active
Viewed 956 times
0
blackeyedcenter
- 188
- 1
- 12
-
Are you running on Spring? – djb Sep 23 '19 at 14:51
-
No. I'm not using Spring. – blackeyedcenter Sep 24 '19 at 07:51
-
https://www.waitingforcode.com/hibernate/transaction-isolation-in-hibernate/read – djb Sep 25 '19 at 08:56
-
According to this document, I understand that the isolation level can be changed per system but cannot be changed per transaction. Do you also think so? – blackeyedcenter Sep 27 '19 at 07:40
-
"Normally, the isolation level is set at java.sql.Connection level, through setTransactionIsolation(int level) method". I think that means you can change it whenever you want to – djb Sep 30 '19 at 08:06
-
Umm.. I Don't know how to get `java.sql.Connection` from `EntityManager`. – blackeyedcenter Sep 30 '19 at 08:31
-
hmm, I always get it from the datasource, or the connection pool. Maybe this ? https://stackoverflow.com/questions/3493495/getting-database-connection-in-pure-jpa-setup – djb Sep 30 '19 at 08:36
-
@djb Thank you for your comment! I will check it. – blackeyedcenter Oct 02 '19 at 07:34