| Author |
Message
|
| omerakhter |
 Posted: Mon May 25, 2009 10:40 pm Post subject: Can we initiate a message flow from Database |
 |
|
Novice
Joined: 19 May 2009
Posts: 22
|
Hi,
I have a scenario where I have to read some records to create a message which is then transformed and is sent to a web service...
My question is that I could find any node which could start the message flow from database... I mean like MQInput or FileInput; a node that keeps on polling the source and generates a message to initiate the message flow whenever source is available.
I think may be polling a database table is not exactly feasible that is why such a node is not available. But can anyone advise some good way to do this?
Thanks |
|
| Back to top |
|
 |
| sarat |
| Posted: Mon May 25, 2009 10:45 pm Post subject: |
|
|
Centurion
Joined: 29 Jun 2005
Posts: 136
Location: India
|
Hi omerakhter,
Trigger the flow with a dummy message by putting on MQInput node queue.. Read the records from either compute or database nodes and create the xml
_________________
With Regards,
Sarat. |
|
| Back to top |
|
|
| sankritya |
| Posted: Mon May 25, 2009 10:55 pm Post subject: |
|
|
Centurion
Joined: 14 Feb 2008
Posts: 100
|
| You can use Timeout Notification by setting a configurable time ... |
|
| Back to top |
|
|
| Maximreality |
| Posted: Tue May 26, 2009 1:56 am Post subject: Re: Can we initiate a message flow from Database |
|
|
Acolyte
Joined: 04 Jun 2004
Posts: 65
Location: Copenhagen
|
If you have the JDBC adapter it can be used for this scenario (it can listen for new entries and then create an MQ message)
You can also make your own listener program using af messageflow and the timernode |
|
| Back to top |
|
|
| omerakhter |
| Posted: Wed May 27, 2009 9:21 pm Post subject: |
|
|
Novice
Joined: 19 May 2009
Posts: 22
|
I found out that it is possible to put records in AQ from oracle tables using a trigger. From there, we can put these records in MQ.
But for all this to work, we need Oracle Messaging Gateway(OMG) to be configured and started. Anybody knows a simple step by step procedure to do this? I'm stuck in configuring OMG. |
|
| Back to top |
|
|
|
|
