[ 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

Reply via email to