If Connection Lost in JDBC or no resultset returned how to handle ?

[former_member189387]

Hi Friends ,

I have a scenario like . I have read data from SQL Server and send to rfc .

I have setted the poll intervals for sender JDBC Adapter as 2 hours (Once in 2 hours data has to come ) . select Query as Where Tag ='N' like that.

I need to know If no data has sent once in 2 hours , I need to send some remarks to another RFC .

<b> If no result has returned by that query the Control won't come to XI right ? Then How can i inert the remarks to another rfc as "No records Received "</b>

How can i hadle this ?

Expecting your reply asap

Best Regards .,

V.Rangarajan

[udo_martens · Accepted solution]

Hi Rangarajan,

you cannot achieve that with JDBC sender adapter. Schedule a job at sap, which is calling a RFC or Proxy and use JDBC receiver adapter. It will give back a result, or, if no connection, an exception.

Regards,

Udo

[bhavesh_kantilal]

Try to do something on the SAP system that checks if there is no data in the past 2 hours, then trigger the required info.

From XI there is nothing much you can do apart from lots of customizations which are better done on R3

regards

Bhavesh