jdbc sender adapter in synchronous mode

[Former Member]

Dear Experts,

I am on PI 7.0 SP 14. I would like to know whether it is possible to use jdbc sender adapter in

synchrounous mode. The scenario is jdbc to web service . The response from webservice should be inserted into the database. If we use the insert statement in the response mapping will it work ?

Thanks

Aju

[Former Member]

Aju,

Use BPM

JDBC Sender->XI->SOAP->XI->JDBC receiver

Yes it is possible..

Regards,

[dharamveer_gaur2]

Hi

If you use BE then it will through error that Mode Best Effort is not allowed.

So solution of your problem

You will have a BPM which 1.receives the message from the sender JDBC adapter, 2.makes the syncronous SOAP call and get the result back and

3.make a jdbc call(using a JDBC receiver channel) to do an update of your original record in the staging table

[Former Member]

Hi Aju

JDBC sender adapter doesn't support synchronous mode. How ever you can use update command parameter which can act as sync. mode.

Regards

Raj

[dharamveer_gaur2]

I think Without use of BPM Sender Sync is not possible. So use BPM to send response.

[Former Member]

Hi,

In JDBC sender communication channel we have an option of BE. In which context do we use that ?

Thanks,

Aju

[pedro_baroni3]

Hi Aju,

See Thread:

Regards

[dharamveer_gaur2]

Hi

JDBC sync is possible but only at Receiver, look this blog