Can we proceed even if no ResultSet Returned In JDBC Sender Adapter ?

[former_member189387]

Hi friends ,

My scenario is JDBC to RFC . I am reading table using JDBC Sender Adapter and i am passing values to RFC .

If my select Query has not returned any row then it won't come to Pipeline right ?

What i want is

<b> If no rows returned then call one RFC to insert the remarks .

If rows found call another RFC to insert the values </b>

How can i handle the Situtation ?

Expecting your reply asap

Regards.,

V.Rangarajan

[prateek · Accepted solution]

Change ur scenario a bit...

Switch to JDBC Lookup. This way u would do the necessary configurations during mapping

Regards,

Prateek

[former_member189387 · Accepted solution]

Hi prateek ,

Thanks for your reply . Can please expalin little more about this . I am new to xi .

Best Regards .,

V.Rangrajan

[udo_martens]

Hi Rangarajan,

i answered your question and shown up a solution: .

Double postings makes it difficult for all involved people to inform theirselfes about the point of discussion.

The polling sender adapter is doing nothing, if no rows selected. So how do want to send a message?

You have to use the JDBC receiver adapter, invoke the message by a job in ERP, for example with a self written RFC or a proxy. You can decide at ERP side, which function module it to be called. Of coz there are other possibilities, for example to put the logic into a business process, but you wont have success with the sender adapter.

Regards,

Udo

[former_member189387]

Hi Udo,

Thanks for ur reply . I understood.

Regards .,

V.Rangarajan