only JDBC-sender channel

[Former Member]

Hi Experts,

the scenario is as following:

i have a database, i want to delete some entries with 2 where conditions ...

why do i have to create a huge scenario with 2 async messages jdbc sender for polling and receiver for deleting...

with the sender i can use the update statement .. why cant i use him standalone .. like every 60 seconds delete the entries..

thanks for your help

[santhosh_kumarv · Accepted solution]

Hi,

Yes it is much reasonable. You can have a Delete statement in the Update SQL Statement of the Sender JDBC Adapter.

Thanks

SaNv...

[Former Member · Accepted solution]

i meant, i cant activate the sender adapter alone .. i always need the complete scenrio with sender agreement etc...

why isnt it possible to activate only the sender .. ?

[former_member181985 · Accepted solution]

Hmm.......

With only sender agreement you can acheive this.

1. JDBC sender channel

2. associate this channel with Business System or Business Service, any message interface name, any namespace....to create a sender agreement.

But every time it gets executed, you will see a message NO_RECEIVER_CASE in the moni for each message.

Thanks,

Gujjeti.

[Former Member · Accepted solution]

Hi,

> why isnt it possible to activate only the sender .. ?

I would say the aim of PI is to transfer messages from system A to system B.

In your scenario you only have system A and you don't want to transfer any message.

So maybe PI is the wrong tool for your requirement.

But if you still want to use it perhaps this blog helps a little bit:

Regards

Patrick

[Former Member · Accepted solution]

thanks guys.

last 2 answers were very good.

answered

[santhosh_kumarv · Accepted solution]

>>why isnt it possible to activate only the sender .. ?

It is not possible because for the adapters to start its function it needs the configuration objects to be available in its cache. So it its mandatory to have the directory objects.

Thanks

SaNv...