| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Questions on Database Node |
« View previous topic :: View next topic » |
| Author |
Message
|
| sangminli |
 Posted: Mon Oct 12, 2009 12:21 am Post subject: Questions on Database Node |
 |
|
Voyager
Joined: 26 Aug 2008
Posts: 75
Location: Hangzhou, China
|
I am studying wmb development, and looking at lab7 of mq66 course (http://ck20.com/MQ/MQ66/Lab7/), which I found in the Internet.
The example is using db2 database, but I am using an Oracle database.
I have a Database Node in my flow, and the Statement for the node is StoreMsg in the esql. Everytime I double-click the Database node, it created a new blank StoreMsg module. I don't know why. This is the Module:
CREATE DATABASE MODULE StoreMsg
CREATE FUNCTION Main() RETURNS BOOLEAN
BEGIN
INSERT INTO Database.XMGBRK6.COMPLAIN (MSGID, RECEIVED, MESSAGE)
VALUES (Root.MQMD.MsgId, CURRENT_TIMESTAMP,ASBITSTREAM(Root));
RETURN TRUE;
END;
END MODULE;
XMGBRK6 is the id I use to access the database, and COMPLAIN is the table I want to insert data.
Could you find if there is any problem with the Module? |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Mon Oct 12, 2009 2:51 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
You appear to be using stolen or otherwise unlicensed educational material. As far as I'm aware, the lab work for mq66 is not publicly available.
You otherwise appear to be experiencing a bug in the Toolkit, that has nothing to do with the database you are using. |
|
| Back to top |
|
|
| sangminli |
| Posted: Mon Oct 12, 2009 5:01 pm Post subject: |
|
|
Voyager
Joined: 26 Aug 2008
Posts: 75
Location: Hangzhou, China
|
| mqjeff wrote: |
You appear to be using stolen or otherwise unlicensed educational material. As far as I'm aware, the lab work for mq66 is not publicly available.
You otherwise appear to be experiencing a bug in the Toolkit, that has nothing to do with the database you are using. |
I am using the mb toolkit of:
Version: 6.1.0
Build id: 6.1.0.2-20080515_1211
The training should be using 6.0 toolkit, so I shouldn't meet problem with v6.1 toolkit.
And if I am having a toolkit bug, which level of toolkit I should be using?
thanks!!! |
|
| 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
|
|
|
|
