Camel sql Component should retrieve data when the particular column is null using select query

[darwinanirudh]

Dear Team ,

Route one :

<from uri="sql:{{sql.RecycleHBRSelectQuery}}?"/>

sql.RecycleHBRSelectQuery=select CDR_JSON from  suspense_details where
CDR_JSON is null

Route two :

<from uri="sql:{{sql.RecycleHBRSelectQuery}}?"/>

sql.RecycleHBRSelectQuery=select CDR_JSON from  suspense_details where
CDR_JSON is not null

I have scenario like the following field CDR_JSON is null i have perform one
set of operations and if it is not null then i would have to perform another
set of operations.

I want to know if there is any other i can implement this in a single route.

regards
Darwin







--
View this message in context: 
http://camel.465427.n5.nabble.com/Camel-sql-Component-should-retrieve-data-when-the-particular-column-is-null-using-select-query-tp5799613.html
Sent from the Camel - Users mailing list archive at Nabble.com.