[esb-issues] [JBoss JIRA] Commented: (JBESB-1283) Add transactional context to SQL listener

[Tom Fennelly (JIRA)]

    [ http://jira.jboss.com/jira/browse/JBESB-1283?page=comments#action_12390229 ] 
            
Tom Fennelly commented on JBESB-1283:
-------------------------------------

I failed miserably on this :-(  I can't seem to get the transaction to commit properly (using HSQL as the DB).

I've committed the changes I made on this to a workspace (https://svn.labs.jboss.com/labs/jbossesb/workspace/SQLCourier_XA), including a new quickstart for testing it (helloworld_sql2_action).

Here's how I tried to describe the latest issue I was having...

"My latest issue is that it seems to be only half committing the transaction.  Yeah that sounds odd so let me explain... The SQLCourier deletes each row as it pulls it from the DB (HSQL) for processing.  If an error occurs, we don't do a rollback, but instead we do a compensatory reinsert of the message and then just commit it all as one transaction.  Well that's what I hoped would happen, but it's not... the insert is happening but the delete is not, which is weird when you consider that it's all happening as part of the the same transaction. "

The reason why we're doing a compensation vs a straightforward rollback is that we want the record's "retrytime" to be updated such that that record is not retried again for a configurable time period (otherwise the MessageAwareListener would get swamped on failed messages).

> Add transactional context to SQL listener
> -----------------------------------------
>
>                 Key: JBESB-1283
>                 URL: http://jira.jboss.com/jira/browse/JBESB-1283
>             Project: JBoss ESB
>          Issue Type: Task
>      Security Level: Public(Everyone can see) 
>          Components: Rosetta
>    Affects Versions: 4.2
>            Reporter: Kevin Conner
>         Assigned To: Tom Fennelly
>             Fix For: 4.2.1 CP1
>
>


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