MQSeries.net :: View topic

ghada · Posted: Thu Aug 10, 2006 6:44 am Post subject: Warehouse Node

Hi all

Im using WBIMBv6 on WinXP

My flow is

MQInput-> Warehouse -> MQOutput

all what I want is to store the message in the DB, so I decided to use Warehouse node, I read the information about it in the info center and the posted topics but I really can't configure the warehouse

All what I did is:
1-Created a table on my DB ( Oracle 9i )
CREATE TABLE ALE.MESSAGE_STORAGE (
MESSAGE_ID VARCHAR2(20) NOT NULL,
MESSAGE_TXT BLOB NOT NULL,
PRIMARY KEY(MESSAGE_ID)
)

2- Defined a message set that contains my messages
3- added a Warehouse node into the flow
4- I defined an RDB definition file which points to my table
5- when I opened a map file it asked for the source so I attached the message definition and for the destination I chosed the table MESSAGE_STORAGE
6- When I tried to map the message root to the field MESSAGE_TXT it made an error claiming that it cant map a complex type to BLOB field

I really Dont know what should I configure to do so,I ll be glad to receive any recommendations

thanks
Ghada