Bugs item #860337, was opened at 2003-12-15 07:58 Message generated for change (Comment added) made by mring33621 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: 9 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! ---------------------------------------------------------------------- Comment By: Matthew S. Ring (mring33621) Date: 2004-01-05 10:37 Message: Logged In: YES user_id=944195 I don't know if Sun's Specs say anything about this behavior, but this change is probably for safety. A workaround might be to have your DAOs use a separate DataSource to get their connections. That way, you're using 2 different factories to build 2 differently configured connections. ---------------------------------------------------------------------- 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
