Hi,

I am using the camel jdbc endpoint, however it is giving me something of a
problem. I have a process where i receive an xml payload by ftp, i take that
payload and put it into a custom header parameter in the message and pass it
onto the jdbc endpoint to do a database insert. however, after doing the
insert the jdbc component seems to be wiping out all the headers that were
previously set. Is there anyway to stop the jdbc endpoint from deleting the
custom headers that have been added to the message. My route is below just
incase it helps to show what i am talking about.

    from(ftpIncomingURL) -- GET FILE FROM FTP
    .convertBodyTo(String.class)
    .choice()
    .when(header(FileComponent.HEADER_FILE_NAME).contains("_rpt.xml")) --
PASS ON
    .to("activemq:queue:"+ftpPollerQueueName)
    .when(header(FileComponent.HEADER_FILE_NAME).contains("_isin_rej.xml"))
-- REJECT
    .process(jdbcRejectProcessor) -- SET CUSTOM HEADER
    .to("jdbc:unavistajdbc")   -- UPDATE DATABASE
    .process(fsaRejectProcessor) -- CUSTOM HEADER GONE AND BODY EMPTY
    .choice()
    .when(header("jdbc.updateCount").isEqualTo(1))
    .process(logEvent)
    .to("activemq:queue:" + mainQueueName + "." + JMS_QUEUE_INCOMING_SUFFIX)
    .otherwise()
    .process(logNoEvent)
    .end()
    .end();

Many Thanks

Graham 



--
View this message in context: 
http://camel.465427.n5.nabble.com/Camel-JDBC-1-6-1-tp5716995.html
Sent from the Camel - Users mailing list archive at Nabble.com.

Reply via email to