[ http://jira.jboss.com/jira/browse/JBESB-1283?page=all ] Mark Little updated JBESB-1283: ------------------------------- Fix Version/s: 4.2.1 CP1 (was: 4.3) -- 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

[ http://jira.jboss.com/jira/browse/JBESB-1283?page=all ] Work on JBESB-1283 started by Tom Fennelly. -- 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

[ 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). -- 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

[ http://jira.jboss.com/jira/browse/JBESB-1283?page=comments#action_12390539 ] Mark Little commented on JBESB-1283: ------------------------------------ I had a look today and am happy to take it on. -- 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

[ http://jira.jboss.com/jira/browse/JBESB-1283?page=all ] Mark Little reassigned JBESB-1283: ---------------------------------- Assignee: Mark Little -- 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

[ http://jira.jboss.com/jira/browse/JBESB-1283?page=comments#action_12391561 ] Tom Fennelly commented on JBESB-1283: ------------------------------------- While looking at something else I saw something that rang a bell here :-) The test I was using on this was using a <local-tx-datasource> configured datasource, which doesn't support 2pc according to http://wiki.jboss.org/wiki/Wiki.jsp?page=ConfigDataSources. May be nothing to do with it, but I thought I'd add the comment anyway. -- 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

[ http://jira.jboss.com/jira/browse/JBESB-1283?page=comments#action_12391565 ] Tom Fennelly commented on JBESB-1283: ------------------------------------- That's what I was thinking too Kev.... Just testing ya ;-) -- 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

[ http://jira.jboss.com/jira/browse/JBESB-1283?page=all ] Mark Little closed JBESB-1283. ------------------------------ -- 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