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

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; } ...