1 Reply Latest reply on Dec 15, 2016 4:57 PM by Tom Cunningham

    How to get the number of updated records in SQL component in Switchyard

    Mostafa Elsarnagawe Newbie

      I am using Switchyard for some projects. I have a camel route that uses a reference service that has SQL binding. The query updates some records in the database. I want to get how many records has been affected by this update statement to proceed further in my Camel route.

      I have checked the sql-component in Camel and it says it returns an Integer with the number of the updated rows. I changed the input type of the service to be java:org.apache.camel.Exchange and the output type to be java:java.lang.Integer but I am still get nothing in the Camel Route. both Headers and Body are do not contain this value.

      How can i get this value?