JDBC adapter

[Former Member]

Hi,

I have a business requirement in which <b>I should pick data from Oracle db once a week</b>. I can configure that in <b>Sender JDBC adapter</b> and put <b>polling interval as 7days24 hrs60</b>.

But my question is what if the <b>Oracle system is down</b> at that time? The JDBC adapter will run at that time, find the system down and then wait for next 7 days. I want to retry after sometime or triger the interface manually.

What are the ways to avoid this?

thanks for any help.

KP

[Former Member · Accepted solution]

You can mention <b>Retry Interval (secs)</b>, if you do not pass any value in this it takes the default poll interval. I did not test this but I believe it works.

http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm

regards

Shravan

[Former Member]

Hi,

why don't you use an event coming from Oracle db to make XI looking for data?

LG

Matt

[Former Member]

Matt,

CAn you please elaborate on your solution?

Also any idea can I use JDBC adapter with ODBC databases?

thanks,

KP