synchronous scenario

[former_member229310]

Hi,

I want to have synchronous service between JDBC & Proxy in PI 7.1. Also Response would like to update few fields in sql DB.

Please suggest which is best approach.

Thanks.

[rajasekhar_reddy14]

JDBC sender will not support Sync behavious,so you have to use BPM for this.

[Former Member]

Check this:

Thanks,

[former_member229310]

I checked the link before posting the question, but can this be treated as synchronous, as there are two async interfaces clubed to make it a sync like asyn-sync bridge.

Thanks for the response.

[Former Member]

Hi

your scenario is JDBC to PI to Proxy (Synchronous as you wanted to update few fields back in DB)

in this case use following way.

you have 1 outbound synchronous service interface - for JDBC sender

1 inbound synchronous service interface- for Proxy

2 Message Mapping (Request, Response)

- 1st mapping- JDBC to Proxy (you have JDBC sender Communication channel with select statement configured and in place of Update statement write u201CTest" so that this will not get triggered.)

- now in 2nd mapping u2013 Proxy to JDBC (on JDBC side in mapping use u201CUpdateu201D action and put your logic to update fields in DB)

Thanks,

Bhupesh