MQSeries.net :: View topic

pottas · Posted: Sat Sep 08, 2007 4:10 am Post subject:

Hi,
I am running the following configuration on Windows(XP) :
Message Broker Toolkit: 6.0.2, Interim Fix 8
Message Broker: MQSI 6.0.0.5
File Extender Support Pack v5

I have the following scenario:
The client wants to put processed records to a DB2 database. When all his records are loaded into the database, he wants a Broker Message Flow to kick off and read the records from the database - without putting a message to an MQ queue to invoke the flow or putting a file to a location in order for File extender to invoke a flow. It basically boils down to a (sort of) polling solution. He wants Broker to poll the database and invoke a flow based on the records in the database.
I considered using a java program that polls the datbase and once it finds something, invoke the flow via MQ or File extender. The other option (which I am not too comfortable with) is to put a message on the queue, invoke a flow that interrogates the database, waits for x seconds and puts the message on the same queue again...
OK, I know it sounds weird, but do any of you perhaps have some ideas around this?

Thanks, appreciated.