Synchronous communication of JDBC adapter with BPM

[Former Member]

Hello XI-Experts,

Could you please give me example where BPM is having a Synchronous communication with JDBC adapter??

plz do help.

Thanks & Regards,

Vanita

[justin_santhanam · Accepted solution]

Vanita,

Let's consider the below scenario.

A File contains the SQL query, you need to fetch the data from DB system using that SQL query and write it to a file. You can configure like below

File Adapter to pick the file and send it to BPM

Mapping Transformation to create the SQL request

Call DB using JDBC adapter Synchronously

Mapping Transformation to Convert the Response from DB and write it to a file.

Does it seems to be a valid scenario you are looking for? Any questions let us know.

If you are looking for any blogs then check below:

Synchronous JDBC: /people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

File-RFC-File: /people/arpit.seth/blog/2005/06/27/rfc-scenario-using-bpm--starter-kit

~Raj.

[Former Member]

Thanks for your kind response.

I was able to create that Scenario.

Regards,

Vanita