This content has been marked as final.
Show 2 replies
-
1. Re: Does isolation has change in 3.2.2 ?
sbocquet Dec 10, 2003 9:29 AM (in response to sbocquet)Hi,
I need to be in TRANSACTION_READ_COMMITTED with my EJB, but also have a DAO that need to be in TRANSACTION_READ_UNCOMMITTED, in order not to block the users during the SELECT statements (because of long EJB updates in the databases)...
It seems that with the 3.2.2 version, the isolation level of a database connection cannot be changed (3.2.1 and 3.2.0 is possible !). The following code returns an SQL isolation error...myConnection.setTransactionIsolation(Connection.TRANSACTION_READ_UNCOMMITTED);
Is it right?
Why can we do this with 3.2.1 and not with 3.2.2 ? A bug ?
Finally, is there a solution to change the isolation level ?
Please, helppppppp.... -
2. Re: Does isolation has change in 3.2.2 ?
snanduri Dec 13, 2003 11:58 PM (in response to sbocquet)hi,
I am facing the same problem, when i switched over to 3.2.3 version, the code is failing with the "You cannot set isolation level during a managed transaction" error.
Anyone, please address this issue, this is critical for us too
Steve