MQSeries.net :: View topic

mrgate · Posted: Mon Oct 08, 2007 12:05 pm Post subject:

Hello All,
I am working on message broker 6.0 with windows 2000 as platform.

I am working on a scenario where my flow includes:

mqinput node---->compute node------->mqoutput node.

now I am getting input from jtext adapter and it gives soap request message as input for my message flow. The compute node is used to insert data into database and the same input message was sent as output
to mqoutput node.

For the input I have used one Jtext connector and for the output I have used another Jtext connector. but for both connectors, I have used the same data handler which is nothing but passthrough data handler(custom data handler) so that file content can be given as string input. Here , as I am sending the same input as output, but in the target connector, I am getting different output.

Here you can see the input data,code for compute node and output data.

The soap request message input was:

<?xml version="1.0" encoding="utf-8" ?>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<SOAP-ENV:Body>
<create xmlns="urn:MySoapServices">
<PurchaseOrder>
<BuyerDetails>
<Organization>University of Washington</Organization>
<Authorized_Person>Cease Wayne</Authorized_Person>
<Street>Savery Hall</Street>
<City>Seattle</City>
<State>Wa</State>
<Zip>98195</Zip>
<Phone>206-111-2345</Phone>
<Fax>206-111-2346</Fax>
<Email>hideki@u.washington.edu</Email>
</BuyerDetails>
<SupplierDetails>
<Organization>Thomas Industrial Network</Organization>
<Authorized_Person>Lowry Phillip</Authorized_Person>
<Street>5 Penn Plaza, 10th Floor</Street>
<City>New York</City>
<State>NY</State>
<Zip>10001</Zip>
<Phone>888-846-6638</Phone>
<Fax>212-629-1158</Fax>
</SupplierDetails>
<PurchaseOrderInformation>
<Order_Number>4556</Order_Number>
<Order_Delivery_Date>10-10-2006</Order_Delivery_Date>
<PO_Type>Finished</PO_Type>
<status>PO sent</status>
</PurchaseOrderInformation>
<Address>
<Shipping_Address>
<Organisation>University of Washington</Organisation>
<Authorized_Person>Cease Wayne</Authorized_Person>
<Street>Savery Hall</Street>
<City>Seattle</City>
<State>Wa</State>
<Zip>98195</Zip>
<Phone>206-111-2345</Phone>
<Fax>206-111-2346</Fax>
<Email>hideki@u.washington.edu</Email>
</Shipping_Address>
<Billing_Address>
<Organisation>University of Washington</Organisation>
<Authorized_Person>Cease Wayne</Authorized_Person>
<Street>Savery Hall</Street>
<City>Seattle</City>
<State>Wa</State>
<Zip>98195</Zip>
<Phone>206-111-2345</Phone>
<Fax>206-111-2346</Fax>
<Email>hideki@u.washington.edu</Email>
</Billing_Address>
</Address>
<Payment_Terms>
<Purchase_Order>
<PO_Number>456</PO_Number>
<Payment_Type>Bank</Payment_Type>
<Payment_Type_PO>
<Bank>
<BankName>Citibank</BankName>
<AccountNumber>654987456</AccountNumber>
<BranchCode>564</BranchCode>
</Bank>
<Credit_Card>
<Payment_Type_CC>VISA</Payment_Type_CC>
<CC_Number>1234 4567 7890 0123</CC_Number>
<CC_Expire_Date>10-12-2012</CC_Expire_Date>
</Credit_Card>
</Payment_Type_PO>
</Purchase_Order>
<Amount>1000 USD</Amount>
</Payment_Terms>
<Purchase_Items>
<Item>
<Part_Name>6 foot wide 5 foot high cabinet</Part_Name>
<Quantity>9</Quantity>
<Description>Cabinets of systems</Description>
</Item>
<Item>
<Part_Name>6 foot wide shelves</Part_Name>
<Quantity>6</Quantity>
<Description>Shelves for books</Description>
</Item>
</Purchase_Items>
</PurchaseOrder>
</create>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>

code for compute node in main function is:

CALL CopyEntireMessage();
SET OutputRoot.MRM."version"='3.0.0';
SET OutputRoot.MRM."delta"=false;
SET OutputRoot.MRM."verb"='Create';

DECLARE sFileContent CHARACTER;
DECLARE Src NAMESPACE 'http://www.ibm.com/websphere/crossworlds/2002/BOSchema/Source';
DECLARE Tgt NAMESPACE 'http://www.ibm.com/websphere/crossworlds/2002/BOSchema/Target';
SET sFileContent = InputRoot.MRM.Src:FileContent;
INSERT INTO Database.ADMIN.AUDIT_MESSAGE (MESSAGE) VALUES (sFileContent);

Output Data:
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envel
ope/" SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding
/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xs
d="http://www.w3.org/2001/XMLSchema">
<SOAP-ENV:Body>
<create xmlns="urn:MySoapServices">
<PurchaseOrder>
<BuyerDetails>
<Organization>University of Washington<
/Organization>
<Authorized_Person>Cease Wayne</Authori
zed_Person>
<Street>Savery Hall</Street>
<City>Seattle</City>
<State>Wa</State>
<Zip>98195</Zip>
<Phone>206-111-2345</Phone>
<Fax>206-111-2346</Fax>
<Email>hideki@u.washington.edu</Email&g
t;
</BuyerDetails>
<SupplierDetails>
<Organization>Thomas Industrial Network&lt
;/Organization>
<Authorized_Person>Lowry Phillip</Autho
rized_Person>
<Street>5 Penn Plaza, 10th Floor</Stree
t>
<City>New York</City>
<State>NY</State>
<Zip> 10001</Zip>
<Phone>888-846-6638</Phone>
<Fax>212-629-1158</Fax>
</SupplierDetails>
<PurchaseOrderInformation>
<Order_Number>4556</Order_Number>
<Order_Delivery_Date>10-10-2006</Order_
Delivery_Date>
<PO_Type>Finished</PO_Type>
<status>PO sent</status>
</PurchaseOrderInformation>
<Address>
<Shipping_Address>
<Organisation>University of Washin
gton</Organisation>
<Authorized_Person>Cease Wayne<
/Authorized_Person>
<Street>Savery Hall</Street>

<City>Seattle</City>
<State>Wa</State>
<Zip>98195</Zip>
<Phone>206-111-2345</Phone>
<Fax>206-111-2346</Fax>
<Email>hideki@u.washington.edu<
/Email>
</Shipping_Address>
<Billing_Address>
<Organisation>University of Washin
gton</Organisation>
<Authorized_Person>Cease Wayne<
/Authorized_Person>
<Street>Savery Hall</Street>

<City>Seattle</City>
<State>Wa</State>
<Zip>98195</Zip>
<Phone>206-111-2345</Phone>
<Fax>206-111-2346</Fax>
<Email>hideki@u.washington.edu<
/Email>
</Billing_Address>
</Address>
<Payment_Terms>
<Purchase_Order>
<PO_Number>456</PO_Number>
<Payment_Type>Bank</Payment_Typ
e>
<Payment_Type_PO>
<Bank>
<BankName>Citibank
</BankName>
<AccountNumber>654
987456</AccountNumber>
<BranchCode>564&lt
;/BranchCode>
</Bank>
<Credit_Card>
<Payment_Type_CC>V
ISA</Payment_Type_CC>
<CC_Number>1234 45
67 7890 0123</CC_Number>
<CC_Expire_Date>10
-12-2012</CC_Expire_Date>
</Credit_Card>
</Payment_Type_PO>
</Purchase_Order>
<Amount>1000 USD</Amount>
</Payment_Terms>
<Purchase_Items>
<Item>
<Part_Name>6 foot wide 5 foot high
cabinet</Part_Name>
<Quantity>9</Quantity>
<Description>Cabinets of systems&l
t;/Description>
</Item>
<Item>
<Part_Name>6 foot wide shelves<
/Part_Name>
<Quantity>6</Quantity>
<Description>Shelves for books<
/Description>
</Item>

</Purchase_Items>
</PurchaseOrder>
</create>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>

can anyone give me the solution for this problem.