| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| New WMQI user--need help inserting into a database |
« View previous topic :: View next topic » |
| Author |
Message
|
| kumarp |
 Posted: Wed May 21, 2003 6:09 am Post subject: New WMQI user--need help inserting into a database |
 |
|
Novice
Joined: 20 May 2003
Posts: 23
|
Hi all,
I am a new user to WMQI, and I am trying to develop a simple application that takes a message from the input queue, inserts data into a db2 database table, and then outputs the original message. Very basic stuff. I have an input node, a database insert node, and two output nodes--one from the output terminal of the db insert, and one from the failure terminal of the db insert node.
The problem is that my message keeps going to the node connected to the failure terminal, and nothing is being inserted into the database. Any ideas of why this might be?
I also have some questions about general WMQI concepts. I have been reading the reference books, but still haven't been able to make sense of some things, so any insight anyone could shed would be most useful. Thanks!!!
1) Message flows: In the database node, you have the option of choosing an input message and an output table and adding columns to the table. Is this necessary, or can you just type the ESQL in the pane below? Basically, are the input/output panels for this node just for convenience so you don't have to type out the names of your data elements?
2) I read in the Working with Messages book (SC34-6039-02) that WMQI can convert messages from one physical format to another. How do I actually do this? For example, if I have an input message in a custom wire format, like an imported C structure, but I want the output message to have XML tags, what do I need to do?
Thanks very much! |
|
| Back to top |
|
 |
| Jonasli |
| Posted: Thu May 22, 2003 1:17 am Post subject: |
|
|
Apprentice
Joined: 24 Apr 2003
Posts: 34
Location: Beijing
|
hi, Kumarp, i am a newbie too, maybe just share some experience to u, ^_^
| Quote: |
The problem is that my message keeps going to the node connected to the failure terminal, and nothing is being inserted into the database. Any ideas of why this might be?
|
answer:
firstly, u should check the event viewer for ur error forNT platform or the syslog for unix platform, then u can get the error message about ur db action. i think,
secondly, if u can not get above, u can use command to read message flow trace as following steps:
1. firstly open the user trace by the control center for ur message flow.
2. mqsichangetrace YourBrokerName -u -e YourExecuteGroup -r
3. mqsireadlog YourBrokerName -u -e YourExecuteGroup -o aaa.dat
4. mqsiformat -i aaa.dat -o aaa.txt
5. read ur aaa.txt,
above, u should find the error, i think, otherwise, disconnect the failure terminater to outputq, then try it,
| Quote: |
1) Is this necessary,
|
different to components, u should must add the database define for output.
u can not add the input pane, if add message or table columns, just for ur easy to write the ESQL.
if u add it, u can draw and drop the field to ur ESQL.
| Quote: |
2) I read in the Working with Messages book (SC34-6039-02) that WMQI can convert messages from one physical format to another. How do I actually do this? For example, if I have an input message in a custom wire format, like an imported C structure, but I want the output message to have XML tags, what do I need to do?
|
for this question, i think u should do some example of MQSI<
simpleest step:
1., first define the message set,
2. import ur C struct from .h file,
3. define the message by the import compound type(usual),
4. define the CWF for message set, and update ur information.
5. (option) define ur xml format,
6. design ur message flow as, InputNode --> computeNode-->outputNode
7, update the property of ur Node of message flow.
8. inputNode to ur Messageset contents
9. write ESQL in computeNode, to build ur XML message,
sorry, maybe simple, good lucky, |
|
| Back to top |
|
|
| kirani |
| Posted: Thu May 22, 2003 3:46 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
| kumarp wrote: |
The problem is that my message keeps going to the node connected to the failure terminal, and nothing is being inserted into the database. Any ideas of why this might be?
|
Try capturing the ExceptionList information by adding a trace node to the catch terminal of your MQInput node. Make sure you don't have DB Node's failure terminal connected.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| sshaker |
| Posted: Mon May 26, 2003 8:43 am Post subject: |
|
|
Disciple
Joined: 20 Sep 2002
Posts: 185
|
i strongly suggest the mqsi workshop for newbies.. as it is very useful in understanding the concepts.. and people start developing with ease.. including debugging.. from 6th day onwards..(it is a 5 day workshop)..
_________________
shaker |
|
| 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
|
|
|
|
