How to make JDBC Receiver Adapter on PCK work synchronously?

[Former Member]

Hi,

we have a scenario where we want to extract data from an Oracle DB with a select staement like the following:

SELECT ID, _FIRST_NAME, LAST_NAME FROM EMPL_TABLE WHERE ID='1027'

We want to use a JDBC Receiver Adapter in synchronous mode as the documentation states that in synchronous mode results from queries can be transferred.

How do I make my JDBC Receiver Adapter work synchronously instead of 'Exactly Once'. The option for 'Best Effort that I see in the Sender JDBC Aapter is not available.

Regards

Carsten

[udo_martens · Accepted solution]

Hi Carsten,

qos is defined by the sender, i think JDBC receiver is always synchronous. You need to create the jdbc receiver format: http://help.sap.com/saphelp_nw2004s/helpdata/de/2e/96fd3f2d14e869e10000000a155106/content.htm

Regard,

Udo

[Former Member · Accepted solution]

Thank you Udo!

That did the trick. I now see in the Audit Log of Channel Monitoring that the Receiver Adapter with the Select statement was executed with QoS: BestEffort.

However I am still struggling to find the message with the result of the SELECT statement. Any advice?

Carsten