Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Urgent: "where" clause for polling database Adapter

User_DBMQ2Aug 3 2009 — edited Aug 14 2009

Hi
I am creating a database Polling (logical delete OPEN to CLOSED) adapter that polls a table for records which have a "SCHEDULED" date field.
The Polling Adapter should pick up those records where the status is OPEN and SCHEDULED<=SYSDATE.

DB Adapter wizard does not allows this where clause(SCHEDULED<=SYSDATE) to be set; so i tried modifying the Toplink SQL with custom SQL. But it does not works. Please suggest a workaround.

Please help.

Thanks
Debashis

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 11 2009

Added on Aug 3 2009

#adapter, #bpel, #soa, #soa-process-management

8 comments

3,082 views