ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » JDBC Adapter Namespace Issue

Post new topic  Reply to topic
 JDBC Adapter Namespace Issue « View previous topic :: View next topic » 
Author Message
vk
PostPosted: Tue Sep 20, 2005 7:20 am    Post subject: JDBC Adapter Namespace Issue Reply with quote

Partisan

Joined: 20 Sep 2005
Posts: 302
Location: Houston

Hi,

I am using JDBC adapter to read records from a database and send them as XML messages to the WMQI 2.1 broker. I want these messages to be processed by the MRM parser. But the messages sent to the broker have a namespace prefix for each element and so the MRM parser is not able to understand the message.

If the XMLNamespaceFormat property is set to short, the namespace prefix is Q1. Whereas if the property is set to long, the namespace prefix is the Business Object name. In one of the manuals, I saw that if XMLNamespaceFormat is set to long, then the RFHMessageDomain can be MRM.

I ran the debug mode for the message flow. For both short and long namespace format, the MQMD and MQRFH2 are coming, but MRM is blank. Is there a way to handle the messages with namespace prefix in MRM? Or is there a way to stop the adapter from adding the namespace prefix?

Thanks in advance.

VK.
Back to top
View user's profile Send private message
jefflowrey
PostPosted: Tue Sep 20, 2005 7:34 am    Post subject: Reply with quote

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

You should migrate to version 5 of Message Broker.

Flat out, for a million reasons.

It will also fix your problem.

Start your migration process today.
_________________
I am *not* the model of the modern major general.
Back to top
View user's profile Send private message
vk
PostPosted: Tue Sep 20, 2005 7:52 am    Post subject: JDBC Adapter Namespace Issue Reply with quote

Partisan

Joined: 20 Sep 2005
Posts: 302
Location: Houston

Hi Jeff,

Thanks for the quick reply.

I saw that namespaces can be handled in WBI MB v5. We will be doing the migration soon. But it will take some time. All our current flows are in 2.1.

I need to do this requirement currently in 2.1. What is the best way of achieving this? It would be better if I can validate the incoming message, rather than defining the same as an XML domain.

Thanks,
VK.
Back to top
View user's profile Send private message
RocknRambo
PostPosted: Tue Sep 20, 2005 11:04 am    Post subject: Reply with quote

Partisan

Joined: 24 Sep 2003
Posts: 355

The retrevial from WBI Adapter is CwXML format. Its the BusinessObject name:fieldname,

You dont need a MRM parser for processesing...just invoke the XML parser from ur input node, and do the normal way in ur compute node,

Code:
ex:
InputRoot.XML."BusinessObjectName:BusinessObjectName"."BusinessObjectName:FieldName"


choose the option of LongNamespace in the .cfg for consistence...

When u create the .xsd using the ODA bydefault it gives the whole tableName, rename it shortly and so the attributes (fieldNames)


-RR
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » JDBC Adapter Namespace Issue
Jump to:  



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
Protected by Anti-Spam ACP
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.