Skip to Content
Jan 06, 2022 at 10:32 AM


180 Views Last edit Jan 07, 2022 at 02:58 AM 2 rev


I want to do a JDBC lookup in CPI which then will determine the next process to be done with the main payload.

Here is my iFlow:



1. Step 1 will do a SFTP connection and get a file to be processed

2. Step 2, here I create a Content Modifier to prepare the SQL SELECT statement in the Message Body

3. Step 3, I use the JDBC adapter to execute the SELECT statement from step 2 and receive the lookup table

The problem here is, since the SQL statement in step 2 is stored in the Message Body, then the file content read from step 1 is overwritten from step 2.

My goal is to use the result of the JDBC call in step 3 to check against the file payload from step 1 then determine what the next step is. In another word, something similar to JDBC lookup.

So, the question is how to do JDBC lookup in CPI?

Thank you


image.png (20.6 kB)