[esb-issues] [JBoss JIRA] Commented: (JBESB-1579) JBESB-Internal/DeadLetterService PersistAction transaction isolation level

[Noel Rocher (JIRA)]

    [ http://jira.jboss.com/jira/browse/JBESB-1579?page=comments#action_12401461 ] 
            
Noel Rocher commented on JBESB-1579:
------------------------------------

I'm using an Oracle database for message store and JBoss ESB service in JBoss AS

> JBESB-Internal/DeadLetterService PersistAction transaction isolation level
> --------------------------------------------------------------------------
>
>                 Key: JBESB-1579
>                 URL: http://jira.jboss.com/jira/browse/JBESB-1579
>             Project: JBoss ESB
>          Issue Type: Bug
>      Security Level: Public(Everyone can see) 
>          Components: Message Store
>    Affects Versions: 4.2.1 CP1
>            Reporter: Noel Rocher
>            Priority: Minor
>             Fix For: 4.2.1 CP2
>
>
> this action is based on the class "org.jboss.internal.soa.esb.persistence.format.db.DBMessageStoreImpl"
> where the transaction isolation level is setup to Connection.TRANSACTION_READ_UNCOMMITTED :
> Code:
> ...
>     public boolean redeliver(URI uuid) throws MessageStoreException
>     {
>         boolean isDelivered=false;
>         boolean error=false;
>         Connection con = null;
>         try
>         {
>             con = mgr.getConnection();
>             con.setAutoCommit(false);
>             con.setTransactionIsolation(Connection.TRANSACTION_READ_UNCOMMITTED);
>             
> ...
> 	
> This is producing only warnings but the exception make the redelivry to fail :
> Code:
> ...
>         catch (SQLException e)
>         {
>             if (logger.isDebugEnabled()) {
>                 logger.debug("Deadlocks may occur under normal processing");
>                 logger.debug(e.getMessage(), e);
>             }
>             error=true;
>         } 
> ...
> 	

-- 
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
-
For more information on JIRA, see: http://www.atlassian.com/software/jira