6 Replies Latest reply on Nov 8, 2017 7:57 AM by Sławomir Wojciechowski

    Solution architecture

    Sławomir Wojciechowski Newbie

      Hello,

      I have general question about jbatch architecture solution for required app. This batch should:

      1. delete/truncate table on db1

      2. load to table from point 1 data from db2

      3. execute sql on db1 (using table from point 1) and return results to db2

       

      I have problem on 1 point. How to delete or better truncate table using jberet? I cant do it using jdbcItemReader->jdbcItemWriter becouse no result set is returned. I tried to create batchlet that call dao but then I got "no transaction exception". Point 2 i 3 looks like easy to make.

      Mayby my all idea is bad. Mayby I should do this proces in other way?

       

      Thanks for sugestions

      Regards

      sw