« Return to Thread: help with jdbc transaction

RE: help with jdbc transaction

by Stephen Magee :: Rate this Message:

Some parts of this message have been removed. Learn more about Nabble's security policy.

Andrew,

Due to current pressures I won’t have a chance to put up an example config until next week, but in the mean time:

We have a UMO that takes a message of an ActiveMQ queue, updates a database and then publishes to another ActiveMQ queue all within a XA transaction (note that the queues are on separate brokers).

Without the changes that we have made we got a lot of XA errors and on stepping through the code noticed that the database was updated as soon as the insert/update was executed (i.e. before the message had been forwarded to the outbound queue).

We have had no problems with another part of the system that bridges the two remote ActiveMQ brokers in a XA transaction i.e. we only encountered the problem when a JDBC connection was involved.

We’re using Mule 1.3.2 with ActiveMQ, Oracle 10g and the Oracle JDBC driver. Mule is running standalone and using JOTM as the transaction manager.

Stephen

From: Andrew Perepelytsya [mailto:aperepel@...]
Sent: 07 March 2007 15:57
To: user@...
Subject: Re: [mule-user] help with jdbc transaction

****** This Message Originated From The Internet Please Be Aware Of Suspicious Attachments And Content ******

Stephen,

I'm not sure that is the right thing you are doing. Could you please post a detailed use case where you consider it was required?

Andrew

_________________________________________________________
DISCLAIMER

1. The information contained in this E-mail, including any files transmitted with it, is confidential and may be legally privileged. This E-mail is intended only for the personal attention of the stated addressee(s). Any access to this E-mail, including any files transmitted with it, by any other person is unauthorised. If you are not an addressee, you must not disclose, copy, circulate or in any other way use or rely on the information contained in this E-mail or any files transmitted with it. Such unauthorised use may be unlawful. If you have received this E-mail in error, please inform the sender immediately and delete it and all copies from your system. You may not forward this E-mail without the permission of the sender.

2. The views expressed in this E-mail are those of the author, and do not necessarily represent the views of AMT-SYBEX. Internet communications are not secure and AMT-SYBEX cannot, therefore, accept legal responsibility for the contents of this message nor for any damage caused by viruses.

AMT-SYBEX Limited is a UK company, registration number GB03036807 at address The Spirella Building, Bridge Road, Letchworth, SG6 4ET.

AMT-SYBEX (NI) Limited is a UK company, registration number NI024104 at address Edgewater Office Park, Edgewater Rd, Belfast, BT3 9JQ.
For more information on the AMT-SYBEX Group visit http://www.amt-sybex.com
_________________________________________________________

« Return to Thread: help with jdbc transaction