On Wed, May 26, 2010 at 9:25 AM, MasterLotis <[email protected]> wrote: > > Hi all, > > I have do some camel to pick up data from database do some update and > send it using ActiveMQ component with Failover Transport. > > pollingdatabase -->begeintransaction--> do some update --> send to > jms-->commit > > When internet connection was disconnected or Broker die, Triggered > Failover to start and still locked my update table. > I have other application that used same database It can not do anything > to locked table > until broker come back or internet connection are back online. > I dont know How to rollback transaction from TransportListener. > > Thank you for all of your suggestion.
AMQ should have some options to setup eg max number of retry connect attempts etc. And maybe even a timeout for sending. And you may have to use a sendSync=true or is it sendAsync=false option to tell the client to wait until the message is actually send so the client can get the exception if failed, so the TX can rollback. The AMQ website should have some pieces of info for that. Otherwise I recon to pickup the ActiveMQ in Action book > -- > View this message in context: > http://old.nabble.com/How-can-I-rollback-transaction-when-using-failover--tp28677356p28677356.html > Sent from the Camel - Users mailing list archive at Nabble.com. > > -- Claus Ibsen Apache Camel Committer Author of Camel in Action: http://www.manning.com/ibsen/ Open Source Integration: http://fusesource.com Blog: http://davsclaus.blogspot.com/ Twitter: http://twitter.com/davsclaus
