on 03-18-2010 9:59 AM
Hi All,
I'm using JDBC sender adapter. My requirement is to stop JDBC Adpater from polling (Select) data immediately if there is no record in database matching select statement.
Is is possible to do this? I have also implemented availability time planning but it's not exactly what I'm looking for.
Thanks,
Pavin
Hi All,
Is is possible to use BPM to control JDBC sender adapter?
Thanks,
Pavin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This requirement couldn't make much sense to me.
Suppose there are no records left, then how will PI know this unless it actually polls the data. If you think of sending some indicator from database to PI indicating no new data, then you need to manage the time after which PI should restart polling data. Any such solution won't be logical anyway.
Regards,
Prateek
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Pavin,
There is no way you can stop the JDBC channel if there is no data left in the database. You can do this by using Channel availability time planning only. Once you start the channel it will poll the database continuously irrespective whether the data is available satisfying the SELECT query configured in the sender JDBC channel. This is never ending job. One can stop the channel either manually or using the availability time planning. With the second option, you can start and stop any channel automatically.
So please use that option in more effective manner in order to start and stop the channels automatically.
hope this information helps you to resolve your problem.
Regards,
Achari
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
This looks bit interesting, i think its not posible using standard functionality.
Regards,
Raj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.