Apache Camel: How do I achive a transactional route in Camel if I have a DB access in a route and then an FTP...











up vote
0
down vote

favorite












My route:



from(jms:queue:xxx)

...

.process(_db_access__here_will_be_written_in_db)

...

.to(ftp:yyy)


The problem is, after the message will be read from a queue, the data will be written in the Database, but if the ftp endpoint producer failed to write a file in the directory, I get an error in the route but the changes in the DB will not be rollbacked.




I want to commit the changes to DB only when the file will be
successfully written to ftp directory. How can I do that in my route?







java ftp apache-camel rollback transactional







share|improve this question


























    up vote
    0
    down vote

    favorite












    My route:



    from(jms:queue:xxx)
    
...
    
.process(_db_access__here_will_be_written_in_db)
    
...
    
.to(ftp:yyy)


    The problem is, after the message will be read from a queue, the data will be written in the Database, but if the ftp endpoint producer failed to write a file in the directory, I get an error in the route but the changes in the DB will not be rollbacked.




    I want to commit the changes to DB only when the file will be
    successfully written to ftp directory. How can I do that in my route?







    java ftp apache-camel rollback transactional







    share|improve this question
























      up vote
      0
      down vote

      favorite









      up vote
      0
      down vote

      favorite











      My route:



      from(jms:queue:xxx)
      
...
      
.process(_db_access__here_will_be_written_in_db)
      
...
      
.to(ftp:yyy)


      The problem is, after the message will be read from a queue, the data will be written in the Database, but if the ftp endpoint producer failed to write a file in the directory, I get an error in the route but the changes in the DB will not be rollbacked.




      I want to commit the changes to DB only when the file will be
      successfully written to ftp directory. How can I do that in my route?







      java ftp apache-camel rollback transactional







      share|improve this question













      My route:



      from(jms:queue:xxx)
      
...
      
.process(_db_access__here_will_be_written_in_db)
      
...
      
.to(ftp:yyy)


      The problem is, after the message will be read from a queue, the data will be written in the Database, but if the ftp endpoint producer failed to write a file in the directory, I get an error in the route but the changes in the DB will not be rollbacked.




      I want to commit the changes to DB only when the file will be
      successfully written to ftp directory. How can I do that in my route?







      java ftp apache-camel rollback transactional




      java ftp apache-camel rollback transactional






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Nov 10 at 16:12









      Oli

      7610




      7610
























          1 Answer
          1






          active

          oldest

          votes

















          up vote
          0
          down vote













          you are looking at transacted client.



          you also may add transacted if you are using camel-sql



          sql:insert into tables value (id=:#myId)?transacted=true





          share|improve this answer








          New contributor




          chiochuan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
          Check out our Code of Conduct.


















          • Unfortunatly that is not that easy. "transacted=true" is useful only for a consumer and not for distributed XA Transaction Manager.
            – Oli
            yesterday











          Your Answer






          StackExchange.ifUsing("editor", function () {
          StackExchange.using("externalEditor", function () {
          StackExchange.using("snippets", function () {
          StackExchange.snippets.init();
          });
          });
          }, "code-snippets");

          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "1"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          convertImagesToLinks: true,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: 10,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });














           

          draft saved


          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53240846%2fapache-camel-how-do-i-achive-a-transactional-route-in-camel-if-i-have-a-db-acce%23new-answer', 'question_page');
          }
          );

          Post as a guest


















          1 Answer
          1






          active

          oldest

          votes








          1 Answer
          1






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes








          up vote
          0
          down vote













          you are looking at transacted client.



          you also may add transacted if you are using camel-sql



          sql:insert into tables value (id=:#myId)?transacted=true





          share|improve this answer








          New contributor




          chiochuan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
          Check out our Code of Conduct.


















          • Unfortunatly that is not that easy. "transacted=true" is useful only for a consumer and not for distributed XA Transaction Manager.
            – Oli
            yesterday















          up vote
          0
          down vote













          you are looking at transacted client.



          you also may add transacted if you are using camel-sql



          sql:insert into tables value (id=:#myId)?transacted=true





          share|improve this answer








          New contributor




          chiochuan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
          Check out our Code of Conduct.


















          • Unfortunatly that is not that easy. "transacted=true" is useful only for a consumer and not for distributed XA Transaction Manager.
            – Oli
            yesterday













          up vote
          0
          down vote










          up vote
          0
          down vote









          you are looking at transacted client.



          you also may add transacted if you are using camel-sql



          sql:insert into tables value (id=:#myId)?transacted=true





          share|improve this answer








          New contributor




          chiochuan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
          Check out our Code of Conduct.









          you are looking at transacted client.



          you also may add transacted if you are using camel-sql



          sql:insert into tables value (id=:#myId)?transacted=true






          share|improve this answer








          New contributor




          chiochuan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
          Check out our Code of Conduct.









          share|improve this answer



          share|improve this answer






          New contributor




          chiochuan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
          Check out our Code of Conduct.









          answered 2 days ago









          chiochuan

          11




          11




          New contributor




          chiochuan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
          Check out our Code of Conduct.





          New contributor





          chiochuan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
          Check out our Code of Conduct.






          chiochuan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
          Check out our Code of Conduct.












          • Unfortunatly that is not that easy. "transacted=true" is useful only for a consumer and not for distributed XA Transaction Manager.
            – Oli
            yesterday


















          • Unfortunatly that is not that easy. "transacted=true" is useful only for a consumer and not for distributed XA Transaction Manager.
            – Oli
            yesterday
















          Unfortunatly that is not that easy. "transacted=true" is useful only for a consumer and not for distributed XA Transaction Manager.
          – Oli
          yesterday




          Unfortunatly that is not that easy. "transacted=true" is useful only for a consumer and not for distributed XA Transaction Manager.
          – Oli
          yesterday


















           

          draft saved


          draft discarded



















































           


          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53240846%2fapache-camel-how-do-i-achive-a-transactional-route-in-camel-if-i-have-a-db-acce%23new-answer', 'question_page');
          }
          );

          Post as a guest






































































          -

          Popular posts from this blog

          Bressuire

          Image
          Subprefecture and commune in Nouvelle-Aquitaine, France Bressuire Subprefecture and commune Chateau de Bressuire and the Eglise Notre-Dame Coat of arms Location of Bressuire Bressuire Show map of France Bressuire Show map of Nouvelle-Aquitaine Coordinates: 46°50′27″N 0°29′14″W  /  46.8408°N 0.4872°W  / 46.8408; -0.4872 Coordinates: 46°50′27″N 0°29′14″W  /  46.8408°N 0.4872°W  / 46.8408; -0.4872 Country France Region Nouvelle-Aquitaine Department Deux-Sèvres Arrondissement Bressuire Canton Bressuire Government  • Mayor .mw-parser-output .nobold{font-weight:normal} (2014–20) Jean Michel Bernier Area 1 180.59 km 2 (69.73 sq mi) Population (2014) 2 19,300  • Density 110/km 2 (280/sq mi) Time zone UTC+01:00 (CET)  • Summer (DST) UTC+02:00 (CEST) INSEE/Postal code 79049 /79300 Elevation 98–236 m (322–774 ft) (avg. 173 m or 568 ft) 1 French Land Register data, which exclude
          Read more

          Vorschmack

          Image
          Vorschmack Ukrainian Jewish-style vorschmack served on rye bread Course Hors d'oeuvre Region or state Eastern Europe Associated national cuisine Ashkenazi Jewish, Finnish, German, Ukrainian, Polish, Russian Main ingredients Ground meat and/or fish Cookbook: Vorschmack   Media: Vorschmack Vorschmack or forshmak (Yiddish: פֿאָרשמאַק ‎, from archaic German Vorschmack , "foretaste" [1] or "appetizer" [2] ) is an originally East European dish made of salty minced fish or meat. Different variants of this dish are especially common in Ashkenazi Jewish and Finnish cuisine. Some varieties are also known in Russian and Polish cuisine. Contents 1 In Jewish cuisine 2 In Russian cuisine 3 In Polish cuisine 4 In Finnish cuisine 5 See also 6 References In Jewish cuisine According to Gil Marks, the German name points to the possible Germanic origin of this dish. [1] William Pokhlyobkin descr
          Read more

          Quarantine

          Image
          For other uses, see Quarantine (disambiguation). Signal flag "Lima" called the "Yellow Jack" which when flown in harbor means ship is under quarantine. A simple yellow flag (also called the "Yellow Jack") had historically been used to signal quarantine (it stands for Q among signal flags), but now indicates the opposite, as a signal of a ship free of disease that requests boarding and inspection. A quarantine is used to separate and restrict the movement of people; it is 'a restraint upon the activities or communication of persons or the transport of goods designed to prevent the spread of disease or pests', for a certain period of time. [1] This is often used in connection to disease and illness, such as those who may possibly have been exposed to a communicable disease. [2] The term is often erroneously used to mean medical isolation, which is "to separate ill persons who have a communicable disease from those who are healthy
          Read more