JDBC Synchronus Scenareo..

[tharaka_fernando]

Dear All Gurus...

Need a clarification from you on a simple question wich is on PI - JDBC scenareos...

Is there any impact, if we always try to develop JDBC syncronus methods rather than concerntrating on Asynchronus.. Cos I have heard (I might be worng) it is recommended to use Asyncronus methods for JDBC than Synchronus...?

Thanks

[rajasekhar_reddy14 · Accepted solution]

Hi ,

JDBC receiver adapter supports Sync communication, if your business requirement demands sync integration then you can always develop sync scenarios using JDBC but you have to consider couple of points like volume of messages and complexity.

Reprocessing failure message not possible in PI when u deal with Sync scenarios.

Async scenarios always gives more flexibility .

I worked on Sync/Async scenario integration using JDBC but never faced any issues.

PS:Use stored procedure in receiver JDBC scenario to handle high volume.

Thank you,

Raj

[udo_martens]

Hi,

the paradigma is simple: Asynchronously as possible, synchronously as necessary. E.g.: If you have dynamic requests - the SQL SELECT clause is not static - then you have a good reason build up synchronous processes, because you cannot make use of jdbc sender adapter.

/Udo