I have created 3 components with JDBC adapter. The following is how I wish they would work:
Component1 reads 1 record from the file and call a st procedure that checks for duplicate data in the tables. If duplicate, do nothing, else publish a document1 (as publishandwait for reply1). It should do the same thing for the next record after it receives the Reply from Component3.
Component2 picks up document1 and do some data massaging and publish a document2.
Component3 picks up document2 and insert into table, and then publish a reply1, which is the same DocType as the reply doc in Component1.
However, when I run them, Component1 publishes the first Document1 and waits forever. Component2 and Component3 do not seem to be triggered at all.
Could someone please tell me what I did wrong with the pulishandwait ?