Bugs item #860337, was opened at 2003-12-15 14:58 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=860337&group_id=22866
Category: None Group: v3.2 Status: Open Resolution: None Priority: 5 Submitted By: St�phane BOCQUET (sbocquet) Assigned to: Nobody/Anonymous (nobody) Summary: Can't change database isolation mode since v3.2.2 Initial Comment: OS : All JDK Version : Sun 1.4.1 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 since the 3.2.2 version, the isolation level of a database connection cannot be changed (3.2.1 and 3.2.0 was possible !). The following code... myConnection.setTransactionIsolation (Connection.TRANSACTION_READ_UNCOMMITTED); ... returns an SQL isolation error : You cannot set isolation level during a managed transaction! ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=860337&group_id=22866 ------------------------------------------------------- This SF.net email is sponsored by: IBM Linux Tutorials. Become an expert in LINUX or just sharpen your skills. Sign up for IBM's Free Linux Tutorials. Learn everything from the bash shell to sys admin. Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click _______________________________________________ JBoss-Development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
