For given situation:
- Multiple messages are sent to IS
- Based on that messages JDBC adapter should be called(thousands inserts per 1 incoming message), but only after other service gives green light for it (could be 15 minutes from receiving first input message). There could also be a case when few input messages are linked(by some parameter in message), and all those inserts should be called at the same time.
Client insists on having all of those thousands messages published via UMS, and waiting there for a service which will give green light to call DB.
I am wondering how to deliver that, should I publish the documents without creating a trigger and then create some java service which will take documents from the queue/topic? Should pub.publish or pub.jms services be used for that?
I also have doubts if that’s a proper way to handle the situation(having tens of thousand messages stuck in queue for minutes, what if the ‘green light service’ fails, etc).
Would appreciate your input on that issue.