I am working on one business problem looking for solution how to achieve?
I have two tables.
WP_USER(user_id, email,....,address_id, contract_accepted)
once contract_accepted column change in db I want to initiate the BPEL process in which I want to send the user's data(user who accepted the contract) to other webservice.
Do you need wp_adderss table in your process? How?
Is the contract_accepted field always have the same values?
In general you can initiate a bpel process by polling a DB table.
After the initiation you have few options, like delete the polled record or update a field in the polled record etc....
contract_accepted is the date field and it will always change once user accept the contract.
I need user and his address to send the other service in my BPEL process. I dont want to change anything in user table after read.
I am new in SOA BPEL please help.