JDBC Sender Adapter Configuration

[Former Member]

Hi All,

i want to know if we can configure JDBC sender adapter to run only when we ask it to.

Normally what happens is tht the JDBC Sender Adapter polls the database at specified intervals, i dont want that. I only want it to poll the database when i get a file from RFC.

Regards,

Sumit

[MichalKrawczyk · Accepted solution]

Hi,

>>>>I only want it to poll the database when i get a file from RFC.

this is not possible currently with the sender adapter

what you can do however is to create a BPM

that will start with the RFC(file)

and then invoke a receiver jdbc adapter

this way you can be sure that the jdbc will

only pool when you want to..

Regards,

michal

[bhavesh_kantilal · Accepted solution]

Sumit,

what you want to do this to Schedule your Sender JDBC adapter..This is not possible. Unfortuately.

One option is to use a receiver JDBC adapter with a BPM and a dummy file to trigger the interface.

take a look at this blog , for this approach,

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

Regard,

Bhavesh

[MichalKrawczyk · Accepted solution]

hi Bhavesh,

>>>>One option is to use a receiver JDBC adapter with a BPM and a dummy file to trigger the interface.

dummy file?

what for in this case if he has an RFC call

that can start the BPM ?

Regards,

michal

-

---

<a href="/people/michal.krawczyk2/blog/2005/06/28/xipi-faq-frequently-asked-questions"><b>XI / PI FAQ - Frequently Asked Questions</b></a>

[Former Member]

I configured the sender as follow:

Query SQL Statement:

SELECT table1.*

FROM table1, ZSWITCH

WHERE (ZSWITCH.Selector = 'X') AND

(ZSWITCH.tbname = 'table1')

Update SQL Statement:

UPDATE ZSWITCH

SET Selector = ''

WHERE tbname = 'table1'

use another interface to set the ZSWITCH Selector flag when u want start the jdbc sender .

bye

Domenico

[Former Member]

Hi,

Thank you.I had posted a similar questions a few dayz back and someone said that if we make the jdbc adapter synchronous it would solve our purpose, but it wont.

Bhavesh i went thru ur blog in the mornin b4 postin d question..btw itz a nice blog

Domenico : this is not what im looking for.

Cheers,

Sumit

Message was edited by: Sumit Khetawat

[bhavesh_kantilal]

Looks like I didnt read the last line No need of dummy file.. Just a BPM plus the blog.

<i>only want it to poll the database when i get a file from RFC.</i>

Regards,

Bhavesh