[esb-issues] [JBoss JIRA] Created: (JBESB-1810) There is no retry limit when using transacted SQL listener

[Jiri Pechanec (JIRA)]

There is no retry limit when using transacted SQL listener
----------------------------------------------------------

                 Key: JBESB-1810
                 URL: http://jira.jboss.com/jira/browse/JBESB-1810
             Project: JBoss ESB
          Issue Type: Bug
      Security Level: Public (Everyone can see)
          Components: Rosetta, Transports
    Affects Versions: 4.2.1 CP3
         Environment: FC8/PostgreSQL
            Reporter: Jiri Pechanec
         Assigned To: Kevin Conner
            Priority: Critical
             Fix For: 4.2.1 CP4


If the SQL listener is used and set to support transactions and an exception is thrown in pipeline the transaction is rolled back and the message is put back for processing. Unfortunately there is no retry limit so the same message is executed again and again and in case of more messages the performance goes down. There should be something like retry counter that after few unsuccessful execution will put the message to DLQ.

-- 
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