| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| JMSStream accessing from ESQL |
« View previous topic :: View next topic » |
| Author |
Message
|
| nas |
 Posted: Wed Apr 26, 2006 8:43 am Post subject: JMSStream accessing from ESQL |
 |
|
Newbie
Joined: 08 Apr 2006
Posts: 7
|
I am using WMB v6.0 and I have an application putting a JMS XML message on a queue. The application is running in WAS 6.0 using the embedded JMS provider. The message type is a JMS_Stream.
Message is:
<FMMessage>
<FMHeader>
<Source> JMS App </Source>
</FMHeader>
</FMMessage>
I have tried setting the Message Domain on the MQInput Node to JMSStream, XMLNS and XML. In a compute node, the ESQL I have tried to reference the message using the following..
InputRoot.JMSStream.FMMessage.FMHeader.Source
InputRoot.XMLNS.FMMessage.FMHeader.Source
InputRoot.XML.FMMessage.FMHeader.Source
None of the statments above retieve the value.
Has anyone gone down this road? |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Wed Apr 26, 2006 8:46 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
So your WAS application is sending a JMSStream message through the bridge onto MQ, and you have a broker flow receiving the message.
Set the MQInput default to "JMSStream". Add a trace node right after the input, and examine the results.
Or use usertrace.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| nas |
| Posted: Wed Apr 26, 2006 10:00 am Post subject: |
|
|
Newbie
Joined: 08 Apr 2006
Posts: 7
|
That is correct.
I thought that a message in the JMSStream domain would be parsed as XML. If this is the case I would have thought I could access the elements as InputRoot.XML....
Here is the trace:
Root: (
(0x01000000):Properties = (
(0x03000000):MessageSet = ''
(0x03000000):MessageType = ''
(0x03000000):MessageFormat = ''
(0x03000000):Encoding = 273
(0x03000000):CodedCharSetId = 1208
(0x03000000):Transactional = TRUE
(0x03000000):Persistence = TRUE
(0x03000000):CreationTime = GMTTIMESTAMP '2006-04-26 17:43:32.050'
(0x03000000):ExpirationTime = -1
(0x03000000):Priority = 4
(0x03000000):ReplyIdentifier = X'000000000000000000000000000000000000000000000000'
(0x03000000):ReplyProtocol = 'MQ'
(0x03000000):Topic = NULL
(0x03000000):ContentType = ''
)
(0x01000000):MQMD = (
(0x03000000):SourceQueue = 'CLS.OUTBOUNDCERTXML.Q'
(0x03000000):Transactional = TRUE
(0x03000000):Encoding = 273
(0x03000000):CodedCharSetId = 437
(0x03000000):Format = 'MQHRF2 '
(0x03000000):Version = 2
(0x03000000):Report = 0
(0x03000000):MsgType = 8
(0x03000000):Expiry = -1
(0x03000000):Feedback = 0
(0x03000000):Priority = 4
(0x03000000):Persistence = 1
(0x03000000):MsgId = X'414d51205742524b5f514d2020202020edd04e4420006021'
(0x03000000):CorrelId = X'000000000000000000000000000000000000000000000000'
(0x03000000):BackoutCount = 0
(0x03000000):ReplyToQ = ' '
(0x03000000):ReplyToQMgr = 'WBRK_QM '
(0x03000000):UserIdentifier = 'devwmqadmin '
(0x03000000):AccountingToken = X'160105150000004a341f2e227f9e42764fd7707f18000000000000000000000b'
(0x03000000):ApplIdentityData = ' '
(0x03000000):PutApplType = 28
(0x03000000):PutApplName = 'WebSphere MQ Client for Java'
(0x03000000):PutDate = DATE '2006-04-26'
(0x03000000):PutTime = GMTTIME '17:43:32.050'
(0x03000000):ApplOriginData = ' '
(0x03000000):GroupId = X'000000000000000000000000000000000000000000000000'
(0x03000000):MsgSeqNumber = 1
(0x03000000):Offset = 0
(0x03000000):MsgFlags = 0
(0x03000000):OriginalLength = -1
)
(0x01000000):MQRFH2 = (
(0x03000000):Version = 2
(0x03000000):Format = 'MQSTR '
(0x03000000):Encoding = 273
(0x03000000):CodedCharSetId = 1208
(0x03000000):Flags = 0
(0x03000000):NameValueCCSID = 1208
(0x01000000):mcd = (
(0x01000000):Msd = (
(0x02000000): = 'jms_stream'
)
)
(0x01000000):jms = (
(0x01000000):Dst = (
(0x02000000): = 'queue:///CLS.OUTBOUNDCERTXML.Q'
)
(0x01000000):Tms = (
(0x02000000): = '1146073413224'
)
(0x01000000):Dlv = (
(0x02000000): = '2'
)
)
)
(0x01000010):JMSStream = (
(0x01000000):stream = (
(0x01000000):elt = (
(0x02000000): = '<?xml version="1.0" encoding="ISO-8859-1"?>
<FMMessage>
<FMHeader>
<SourceComponent>Commonline Cert Request Setvice</SourceComponent>
<TargetComponent>Commonline Outbound Message Broker</TargetComponent>
<Timestamp>2006-04-26T13:43:33.194-04:00</Timestamp>
</FMHeader>
<FMBody>
<FMRecord>
<BusinessID Type="LoanID">91001297</BusinessID>
<GuarantyFlag>N</GuarantyFlag>
<CommonLineConduit>S</CommonLineConduit>
<CommonLineChangeTx>Y</CommonLineChangeTx>
<LoanStatus>D</LoanStatus>
<LoanUpdateDate>20060420</LoanUpdateDate>
<LoanStatusUpdateDate></LoanStatusUpdateDate>
<BorrLastName>DAMODARAN999 </BorrLastName>
<BorrFirstName>VINOD1</BorrFirstName>
<BorrSSN>123456789</BorrSSN>
<PermBorrAddress1>34 Main St </PermBorrAddress1>
<PermBorrAddress2/>
<PermBorrCity>BOSTON </PermBorrCity>
<PermBorrState>MA</PermBorrState>
<PermBorrZip>01726 </PermBorrZip>
<BorrTelPhone>54748568 </BorrTelPhone>
<BorrDOB>19781031</BorrDOB>
<RequestedLoanAmt>5000.0</RequestedLoanAmt>
<BorrSigCode>N</BorrSigCode>
<BorrCitizenCode>false</BorrCitizenCode>
<ParticipantID>191</ParticipantID>
<PartBranchID>0</PartBranchID>
<CLUID>191000000014PV1A0 </CLUID>
<LoanSeqNum>01</LoanSeqNum>
<SchoolDOE>006641 </SchoolDOE>
<SchoolName>ABRAHAM LINCOLN SCHOOL </SchoolName>
<LoanBeginDate>20051031</LoanBeginDate>
<LoanEndDate>20051031</LoanEndDate>
<EnrollStatusCode> </EnrollStatusCode>
<GradeLevel>GLES </GradeLevel>
<AnticipatedCompleteDate>20051031</AnticipatedCompleteDate>
<CostOfAttendance>0.0</CostOfAttendance>
<FinAidAmount>0.0</FinAidAmount>
<SchoolCertDate></SchoolCertDate>
<AltLoanCertAmt>0.0</AltLoanCertAmt>
<LenderDOE>003842</LenderDOE>
<AltLoanApproveAmt>0.0</AltLoanApproveAmt>
<GuarantorID>191</GuarantorID>
<GuaranteeDate></GuaranteeDate>
<GuaranteeAmt>0.0</GuaranteeAmt>
<SchoolUseOnly> </SchoolUseOnly>
<PNoteDeliveryCode> </PNoteDeliveryCode>
<AltLoanProgCode> </AltLoanProgCode>
<ServiceTypeCode>01</ServiceTypeCode>
<ResponseDisbInfo>
<DisbNumber>1</DisbNumber>
<DisbDate></DisbDate>
<DisbAmt>0.0</DisbAmt>
<OriginationFee>0.0</OriginationFee>
<GuaranteeFee>0.0</GuaranteeFee>
<FeesPaid>0.0</FeesPaid>
<NetDisbAmt>0.0</NetDisbAmt>
<StatusCode>F</StatusCode>
</ResponseDisbInfo>
<ResponseDisbInfo>
<DisbNumber>2</DisbNumber>
<DisbDate></DisbDate>
<DisbAmt>0.0</DisbAmt>
<OriginationFee>0.0</OriginationFee>
<GuaranteeFee>0.0</GuaranteeFee>
<FeesPaid>0.0</FeesPaid>
<NetDisbAmt>0.0</NetDisbAmt>
<StatusCode> </StatusCode>
</ResponseDisbInfo>
<ResponseDisbInfo>
<DisbNumber>3</DisbNumber>
<DisbDate></DisbDate>
<DisbAmt>0.0</DisbAmt>
<OriginationFee>0.0</OriginationFee>
<GuaranteeFee>0.0</GuaranteeFee>
<FeesPaid>0.0</FeesPaid>
<NetDisbAmt>0.0</NetDisbAmt>
<StatusCode> </StatusCode>
</ResponseDisbInfo>
<ResponseDisbInfo>
<DisbNumber>4</DisbNumber>
<DisbDate></DisbDate>
<DisbAmt>0.0</DisbAmt>
<OriginationFee>0.0</OriginationFee>
<GuaranteeFee>0.0</GuaranteeFee>
<FeesPaid>0.0</FeesPaid>
<NetDisbAmt>0.0</NetDisbAmt>
<StatusCode> </StatusCode>
</ResponseDisbInfo>
</FMRecord>
</FMBody>
</FMMessage>
'
)
)
)
)
Environment:
LocalEnvironment:
ExceptionList: |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Apr 26, 2006 10:06 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
JMSStream isn't completely XML.
But as you can see, the JMSStream is being processed correctly.
It's just that there's only one member of the stream, "elt", and it contains a full XML file.
So you can use "InputRoot.JMSStream.stream.elt" to extract the contents and then convert this to an XML message body.
_________________
I am *not* the model of the modern major general. |
|
| 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
|
|
|
|
