| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Message Broker 6.1 File Input issue |
« View previous topic :: View next topic » |
| Author |
Message
|
| Barb |
 Posted: Tue Jul 14, 2009 7:46 am Post subject: Message Broker 6.1 File Input issue |
 |
|
Newbie
Joined: 14 Jul 2009
Posts: 2
|
Hi all, I am new to MQ and this is only the second project i have created. I have an issue I could do with your advice on.
I am creating a project used for 2 way messaging between my company and several other companies.
An external system places a csv message on the company queue in question with the reference and message id to be sent. The Message flow takes the csv, converts it to match the xml schema and sends the message. This bit is all working fine in bothe directions.
The problem i have is a few of the messages, we need to send, require a document to be sent with in the XML (Base 64 encoded). The message flow works out where the file is, from our database, by looking at reference and message id.
What i am having problems with is how do you bring this file into the message flow when it is the flow that determines which file is needed.
The file is not the only file in this folder so i need to grab a specific file and leave it there when finished. The file is already within our document store at this point.
From what i can see the FileInput Node only seems to be used for triggering a flow, not for accessing a file mid flow, and it needs to clear the message so it does not keep importing them again.
Any help or being pointed in the right direction would be very much appriciated.
Thanks |
|
| Back to top |
|
 |
| Vitor |
| Posted: Wed Jul 15, 2009 12:25 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
Sounds like you need a Java Compute Node to me.
It also sounds like you're setting the message id for use as a database key. There are many debates in this forum on why this is a bad idea.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| zpat |
| Posted: Wed Jul 15, 2009 1:14 am Post subject: |
|
|
Jedi Council
Joined: 19 May 2001
Posts: 5866
Location: UK
|
You could store these files in a database - WMB is designed to access databases and messages primarily.
You could send a MQ message to another application which accesses the file and imbeds it in the message as BASE64 encoded data.
You could use the ability of WMB to send HTTP requests to pick it up. To make a file HTTP accessible just run a web server on the same box. |
|
| Back to top |
|
|
| Barb |
| Posted: Wed Jul 15, 2009 2:13 am Post subject: |
|
|
Newbie
Joined: 14 Jul 2009
Posts: 2
|
Hi, thanks for the reply.
It shouldn't be too big a problem, we could either use the java node or we wrote the external application sending in the messages, so we can mod that to alse send in the file when needed. I shall have a look which is best suited.
Vitor - i shall have a look at the other forum posts to see what is being suggested. The message id is the id number relating to message in a table within sql server. This list along with the schema was agreed with all parties in advance to make sure we were sending the correct message.
Thanks both for your help on this. |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed Jul 15, 2009 7:01 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| Barb wrote: |
The message id is the id number relating to message in a table within sql server. This list along with the schema was agreed with all parties in advance to make sure we were sending the correct message.
|
Good plan; put simply, the msg id is an internal field used by the queue manager. It's not a good place to put business information especially if these leads to non-unique ids.
It's also a byte array despite a widely held belief it's a character string. This too has implications for how it's handled.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
