| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Inserting into database |
« View previous topic :: View next topic » |
| Author |
Message
|
| paustin_ours |
 Posted: Wed Aug 11, 2004 5:43 pm Post subject: Inserting into database |
 |
|
Yatiri
Joined: 19 May 2004
Posts: 667
Location: columbus,oh
|
This is what am tryin to do.
I am tryin to insert a row onto my database table with the information from a XML I/P message.
I dont know if i have the data source mapped right. I get an empty row added to my table everytime i send a message, but does that mean i have mapped my data source correctly to the compute node and the problem is with my ESQL? and again all that am using is a simple
INSERT INTO Database.tablename(col1,col2) VALUES(X,Y);
and yeah i get this warning when i save my ESQL : Unresolved Database table Reference.
on the compute node i said datasource to be my database name, i also have a ODBC connection for the Database.
What am i missing here? 2.1 was soo much easier to handle |
|
| Back to top |
|
 |
| paustin_ours |
| Posted: Wed Aug 11, 2004 6:51 pm Post subject: Message Domain |
|
|
Yatiri
Joined: 19 May 2004
Posts: 667
Location: columbus,oh
|
OK It worked but i still have a question,
Only when i set the domain at the I/P node to XML and the reference in my ESQL to be InputRoot.XML.....does the insertion works, if i say MRM as the domain and say InputRoot.XML, it inserts an empty row with no data.
I thought i can use MRM domain and send XML messages, is this not true?
need more light on this plss |
|
| Back to top |
|
|
| Missam |
| Posted: Wed Aug 11, 2004 7:09 pm Post subject: |
|
|
Chevalier
Joined: 16 Oct 2003
Posts: 424
|
| If you are saying InputRoot.XML means you are using self defined XML messages.if you are saying InputRoot.MRM means you are dealing with pre defined messages which definition should be existed in the Message Repository.BY the way when you said Domain as MRM at i/p node.what did u give in the fields MessageSet MessageFormat and MessageType. |
|
| Back to top |
|
|
| paustin_ours |
| Posted: Wed Aug 11, 2004 7:33 pm Post subject: It is Self Defining XML |
|
|
Yatiri
Joined: 19 May 2004
Posts: 667
Location: columbus,oh
|
My Input message is XML - self defined,
i did try setting domain to MRM and message format to XML,messageset and type blank and ESQL with InputRoot.XML...and it wont work... it inserts blank rows onto database.
i tried leaving everything else blank and just the domain saying XML and ESQL with InputRoot.XML, it works.
whats wrong with the earlier declarations??? |
|
| Back to top |
|
|
| JT |
| Posted: Wed Aug 11, 2004 8:49 pm Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
| Quote: |
| whats wrong with the earlier declarations??? |
I encourage you to learn more about the MQInput node by reviewing the Message Flowsmanual:
| Quote: |
If you are using the MRM parser, select the correct message set from the drop-down list in Message Set. This list is populated with available message sets when you select MRM as the domain.
Leave Message Set blank for XML, XMLNS, JMS, and BLOB parsers.
If you are using the MRM parser, select the correct message from the drop-down list in Message Type. This list is populated with messages that are defined in the message set that you have selected.
Leave Message Type blank for XML, XMLNS, JMS, and BLOB parsers.
Select the format of the message from the drop-down list in Message Format. This list includes all the physical formats that you have defined for this message set. If you have used the default names for the physical formats, the list contains:
– CWF1 (the default Custom Wire Format id)
– XML1
– TDS1
If you specified different (non-default) names for any of these formats, your names appear in this list.
Leave Message Format blank for XML, XMLNS, JMS, and BLOB parsers. |
|
|
| 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
|
|
|
|
