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

[mostafa.elsarnagawe]

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?

[tcunning]

What version of SY / container are you using?

Are you using the SY SQL component as a reference, or are you updating the database through the camel route you are using?    It sounds like this is available in CamelSQLUpdateCount, which I'm guessing you are looking for (Apache Camel: SQL Component ), but how to get to it is going to depend on how you're executing that query (SY reference or part of the camel route)?