[ http://jira.jboss.com/jira/browse/JBAS-828?page=history ] Scott M Stark resolved JBAS-828: --------------------------------
Resolution: Done Fix Version: JBossAS-3.2.6 Final This was fixed in the 3.2.4 release. Its now up to the db/driver to determine whether it allows switching the isolation level. > Can't change database isolation mode since v3.2.2 > ------------------------------------------------- > > Key: JBAS-828 > URL: http://jira.jboss.com/jira/browse/JBAS-828 > Project: JBoss Application Server > Type: Bug > Versions: JBossAS-3.2.6 Final > Reporter: SourceForge User > Assignee: Scott M Stark > Priority: Blocker > Fix For: JBossAS-3.2.6 Final > > > SourceForge Submitter: sbocquet . > 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! -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa - If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira ------------------------------------------------------- This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting Tool for open source databases. Create drag-&-drop reports. Save time by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. Download a FREE copy at http://www.intelliview.com/go/osdn_nl _______________________________________________ JBoss-Development mailing list JBoss-Development@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-development