2008/7/17 Ryan Stewart <[EMAIL PROTECTED]>: > > I have a Camel route that runs in an ActiveMQ broker. This route stores some > data in an Oracle database, and then puts a message on a persistent queue, > which uses JDBC persistence and stores the data in that same database. I'd > like both of these activities to occur in a single transaction. Since they > both use the same database, this should be able to happen in a simple, local > transaction. Is there any support for this in Camel or ActiveMQ?
Sure - though when using JDBC and JMS together you need to use JTA and XA. While ActiveMQ can support Oracle as a persistence option, on the ActiveMQ broker - it cannot currently take part in a JDBC-only persistence transaction on the JMS client side. Currently the broker side use of JDBC persistence is a separate transaction. To use JTA / XA just create a Spring JTA transaction manager and register it with the JDBC and JMS components. -- James ------- http://macstrac.blogspot.com/ Open Source Integration http://open.iona.com
