4 Replies Latest reply on Aug 30, 2010 10:29 AM by Claus Ibsen

    transactions in camel (jms + jdbc)

    Pawe? Weso?owski Newbie

      Hi,

       

      Is there any tutorial that shows how to set up camel route (+ all necessary configuration) which contains jms and jdbc endpoints working in the same transaction. In other words I want to roll back all the changes made via jms as well as jdbc when exception occurs.

       

      I can configure route with support for transactions when only one of the mentioned endpoints is used, but I have failed with doing it for both of them.

       

      Maybe is there some tricky way to overcome this problem?

       

      My route:

       

       

          <log message="Got1 $" />     <pipeline>       <to uri="bean:documentToSQL" />       <log message="SQL command: $" />

             

       

      Any help will be appreciated

       

      Thanks in advance!

       

      wesoly