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 Interchange Server + Adapters » Message not being converted to BO /jdbc connector

Post new topic  Reply to topic
 Message not being converted to BO /jdbc connector « View previous topic :: View next topic » 
Author Message
brokerics
PostPosted: Tue Dec 20, 2005 1:06 am    Post subject: Message not being converted to BO /jdbc connector Reply with quote

Apprentice

Joined: 30 Oct 2005
Posts: 45
hey guys

im tryin to send a msg to a database using a jdbc connector- outbound . but the message is not able to convert to BO.
this is the trace content

[Time: 2005/12/20 14:30:19.937] [System: ConnectorAgent] [SS: JDBC_X] [Thread: appPolling (#690375665)] [Type: Trace] [Mesg: :checkStatus]
[Time: 2005/12/20 14:30:20.047] [System: ConnectorAgent] [SS: JDBC_X] [Thread: JDBC_X/REQUESTQUEUEJmsThreadPool.thread9 (#700451825)] [Type: Trace] [Mesg: :Receiver.processMsg(msg) received message:
JMS Message class: jms_text
JMSType: mcd://xml//EMPL?format=CwXML
JMSDeliveryMode: 2
JMSExpiration: 0
JMSPriority: 4
JMSMessageID: ID:414d512054524942202020202020202047b0a74320001502
JMSTimestamp: 1135069218169
JMSCorrelationID:ID:414d51580000000000000000000000000000000000000000
JMSDestination: queue:///JDBC_X/DELIVERYQUEUE
JMSReplyTo: null
JMSRedelivered: false
JMSXDeliveryCount:1
JMS_IBM_MsgType:8
JMSXAppID:tripubb
JMS_IBM_Format:MQSTR
PrivacyLevel:None
JMS_IBM_PutApplType:26
WSDLBinding:EMPLAgentDeliveryBinding
JMSXUserID:EAIUSER
WSDLOperation:EMPLCreate
MessageType:EMPL
JMS_IBM_PutTime:09001932
JMS_IBM_PutDate:20051220
<Q2:EXEC><NAME>walmart</NAME><EID>85A</EID></Q2:EXEC>]
[Time: 2005/12/20 14:30:21.396] [System: ConnectorAgent] [SS: JDBC_X] [Thread: JDBC_X/REQUESTQUEUEJmsThreadPool.thread9 (#700451825)] [Type: Trace] [Mesg: :Converting the Bomo to String -- <Q2:EXEC><NAME>walmart</NAME><EID>85A</EID></Q2:EXEC>]
[Time: 2005/12/20 14:30:22.065] [System: ConnectorAgent] [SS: JDBC_X] [Thread: JDBC_X/REQUESTQUEUEJmsThreadPool.thread9 (#700451825)] [Type: Trace] [Mesg: :Sending fault message:
JMS Message class: jms_text
JMSType: mcd://xml//EMPL?format=CwXML
JMSDeliveryMode: 2
JMSExpiration: 0
JMSPriority: 4
JMSMessageID: ID:414d512054524942202020202020202047b0a74320001502
JMSTimestamp: 1135069218169
JMSCorrelationID:ID:414d51580000000000000000000000000000000000000000
JMSDestination: queue:///JDBC_X/DELIVERYQUEUE
JMSReplyTo: null
JMSRedelivered: false
status:-1
PrivacyLevel:None
WSDLBinding:EMPLAgentDeliveryBinding
resubmitTo:null
description:The received message cannot be converted to BO. The message is not valid.
WSDLOperation:EMPLCreate
keys:null
MessageType:EMPL
<null>]

the code ive written for the message outbound includes

DECLARE Q1 NAMESPACE 'http://www.ibm.com/websphere/crossworlds/2002/BOSchema/EMPL';
DECLARE Q2 NAMESPACE 'http://www.ibm.com/websphere/crossworlds/2002/BOSchema/EXEC';

SET OutputRoot.XML."Q2:EXEC".NAME =InputRoot.XML."Q1:EMPL"."Q1:NAME";
SET OutputRoot.XML."Q2:EXEC".EID =InputRoot.XML."Q1:EMPL"."Q1:EID";


why is it not gettin converted into BO ?
cud sum1 help??
Back to top
View user's profile Send private message
brokerics
PostPosted: Tue Dec 20, 2005 1:07 am    Post subject: Reply with quote

Apprentice

Joined: 30 Oct 2005
Posts: 45
also tried

SET OutputRoot.XML."Q2:EXEC"."Q2:NAME" =InputRoot.XML."Q1:EMPL"."Q1:NAME";
SET OutputRoot.XML."Q2:EXEC"."Q2:EID" =InputRoot.XML."Q1:EMPL"."Q1:EID";
Back to top
View user's profile Send private message
recallsunny
PostPosted: Thu Dec 22, 2005 11:14 am    Post subject: Reply with quote

Disciple

Joined: 15 Jun 2005
Posts: 163
Location: Massachusetts
Make sure that you've populated the RFH2 headers of the output message as per the Integration broker requirements. Also the output msg is an MRM by default, unless you have explicitly changed the "RHF2MessageDomain" property in the connector configuration to accept XML.
Back to top
View user's profile Send private message
alexey
PostPosted: Mon Dec 26, 2005 9:25 am    Post subject: Reply with quote

Acolyte

Joined: 18 Dec 2003
Posts: 62
Location: Israel
It doesn't because the XML is wrong - it has no namespaces, and it should.

For a start:
1. Input message domain should be XMLNS.
2. Output message domain should be XMLNS too.
3. Try:

DECLARE Q1 NAMESPACE 'http://www.ibm.com/websphere/crossworlds/2002/BOSchema/EMPL';
DECLARE Q2 NAMESPACE 'http://www.ibm.com/websphere/crossworlds/2002/BOSchema/EXEC';

SET OutputRoot.XMLNS.Q2:EXEC.Q2:NAME =InputRoot.XMLNS.Q1:EMPL.Q1:NAME;
SET OutputRoot.XMLNS.Q2:EXEC.Q2:EID =InputRoot.XMLNS.Q1:EMPL.Q1:EID;

and don't put all those double quotes everywhere - it can't work that way.

4. Add XML declaration to your message, from my experience you need it. If you don't know how - look for (XML.Decl) in the help.
5. Don't forget to fill RFH2 header and set mcd.Type = "your BO name".
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 Interchange Server + Adapters » Message not being converted to BO /jdbc connector
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.