| Author |
Message
|
| sirisha.n |
 Posted: Wed Mar 26, 2008 10:56 pm Post subject: JDBC adapter |
 |
|
Apprentice
Joined: 25 Feb 2008
Posts: 27
|
Hi,
I am getting output in the format of xml from JDBC adapter. I am able to place this xml in a queue. I want to use this xml for further mapping in my flow with the help of Message set.
the issue here is :
I am able to mapp the xml if i place the input through the RFHUtil. I am facing the problem if i place the input directly from JDBC adapter.
JDBC adpter's output xml looks like :
MD ÿÿÿÿ 3 MQHRF2 AMQ JDBC_QM ÍéG ò JDBC_QM developer ÏoüvœŠao Žƒdô 2008032612075460 ÿÿÿÿRFH p ¸MQSTR ¸ @<mcd><Msd>xml</Msd><Type>EMPLOYEE</Type><Fmt>CwXML</Fmt></mcd> H<jms><Dst>queue:///DQ</Dst><Tms>1206533274609</Tms><Dlv>2</Dlv></jms> ¸<usr><WSDLBinding>EMPLOYEEAgentDeliveryBinding</WSDLBinding><WSDLOperation>EMPLOYEERetrieve</WSDLOperation><PrivacyLevel>None</PrivacyLevel><MessageType>EMPLOYEE</MessageType></usr> <?xml version="1.0" encoding="UTF-8"?>
<EMPLOYEE:EMPLOYEE xmlns:EMPLOYEE="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/EMPLOYEE" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/EMPLOYEE file:EMPLOYEE.xsd" version="3.0.0" verb="Retrieve" locale="en_US" delta="false">
<EMPLOYEE:EMPID>55555</EMPLOYEE:EMPID>
<EMPLOYEE:EMPFIRSTNAME>JESUS</EMPLOYEE:EMPFIRSTNAME>
<EMPLOYEE:EMPLASTNAME>CALLS</EMPLOYEE:EMPLASTNAME>
<EMPLOYEE:ObjectEventId>JDBCConnector_85xworlds_events20080326080745.734</EMPLOYEE:ObjectEventId>
</EMPLOYEE:EMPLOYEE>
please do needful.
thanks |
|
| Back to top |
|
 |
| Gaya3 |
| Posted: Wed Mar 26, 2008 11:03 pm Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
Please check the Adapter logs and let us know whats the error you are getting
Mods: Please move this to ICS/Adapter Section
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| sirisha.n |
| Posted: Wed Mar 26, 2008 11:52 pm Post subject: |
|
|
Apprentice
Joined: 25 Feb 2008
Posts: 27
|
Hi Gaya3,
I am not getting any error at JDBC Adapter side. after mapping , in the out queue i am able to get the header part but not the body of the xml. |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Thu Mar 27, 2008 12:52 am Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
How you configured the BO, its not been getting generated from the Data base (JDBC) side
How you are polling the database?
Are any events are getting generated on events table.
as when you place that message as XML directly to the queue its processing, so its clear that the XML producing by Database is not correct.
run Visual Tester and find the output message is getting generated or not
Regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| satya2481 |
| Posted: Thu Mar 27, 2008 1:07 am Post subject: |
|
|
Disciple
Joined: 26 Apr 2007
Posts: 170
Location: Bengaluru
|
Hi Sirisha,
I hope you have created the message set using the Business Object, the one which you added in your adapter configuration file.
You are saying that there are no errors in the adapter logs, that means the adapter able to crete the BO successfully.
Stop your message flow and compare the mesage which you used for flow testing with the one generated from Adapter.
Try to use VTC (Visual Test Connector) before integrating your adapter with the Message Broker.
Bye
Satya
_________________
IBM Certified Solution Developer WebSphere Message Broker V6.0
IBM Certified System Administrator WebSphere MQ V6.0 |
|
| Back to top |
|
|
| sirisha.n |
| Posted: Thu Mar 27, 2008 2:27 am Post subject: |
|
|
Apprentice
Joined: 25 Feb 2008
Posts: 27
|
Hi Gaya3,
I am able to create Bo successfully,and polling also working fine. jdbc adapter keeps polling on event table.when ever, a record is inserted a trigger will trigger and updates event table with data. as jdbc adapter keeps polling on this event table, it picks that data and places it inside the queue in message broker flow.
from here the problem starts,
I read that queue and saved it to a txt file with the help of RFHUtil. the xml looks like below.
MD ÿÿÿÿ 3 MQHRF2 AMQ JDBC_QM ÍéG ò JDBC_QM developer ÏoüvœŠao Žƒdô 2008032612075460 ÿÿÿÿRFH p ¸MQSTR ¸ @<mcd><Msd>xml</Msd><Type>EMPLOYEE</Type><Fmt>CwXML</Fmt></mcd> H<jms><Dst>queue:///DQ</Dst><Tms>1206533274609</Tms><Dlv>2</Dlv></jms> ¸<usr><WSDLBinding>EMPLOYEEAgentDeliveryBinding</WSDLBinding><WSDLOperation>EMPLOYEERetrieve</WSDLOperation><PrivacyLevel>None</PrivacyLevel><MessageType>EMPLOYEE</MessageType></usr> <?xml version="1.0" encoding="UTF-8"?>
<EMPLOYEE:EMPLOYEE xmlns:EMPLOYEE="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/EMPLOYEE" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.ibm.com/websphere/crossworlds/2002/BOSchema/EMPLOYEE file:EMPLOYEE.xsd" version="3.0.0" verb="Retrieve" locale="en_US" delta="false">
<EMPLOYEE:EMPID>55555</EMPLOYEE:EMPID>
<EMPLOYEE:EMPFIRSTNAME>JESUS</EMPLOYEE:EMPFIRSTNAME>
<EMPLOYEE:EMPLASTNAME>CALLS</EMPLOYEE:EMPLASTNAME>
<EMPLOYEE:ObjectEventId>JDBCConnector_85xworlds_events20080326080745.734</EMPLOYEE:ObjectEventId>
</EMPLOYEE:EMPLOYEE>
the junk data before the <?xml version="1.0" encoding="UTF-8"?> looking like some header.
because of that data i am not able to mapp. if i use same xml with out that junk data i am able to map.
I tried with Visual tester too, the same thing happening.
is there any way to suppress that junk data in broker or at JDBC adapter side.
thanks. |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Thu Mar 27, 2008 2:32 am Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
hope you created the message set by importing the BO to MB.
Regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Thu Mar 27, 2008 2:37 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
You are obviously using JMS. If you don't want the header (RFH) just define your queue within JNDI as client MQ or use the URI form
queue://QMGR/QUEUE?targetClient=1
Enjoy 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| sirisha.n |
| Posted: Thu Mar 27, 2008 2:47 am Post subject: |
|
|
Apprentice
Joined: 25 Feb 2008
Posts: 27
|
Hi gaya3,
yes, i created the message set by importing the BO to MB. |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Thu Mar 27, 2008 3:20 am Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
hey you have to extract the data from MB (using ESQL)
Regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu Mar 27, 2008 3:23 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
There are two headers showing up in your output.
One is the MQMD.
One is the MQRFH2.
Broker will "remove" both of those before it gives you the message. That is, they will be parsed, and turned into Root.MQMD and Root.MQRFH2, and your data will be under Root.MRM.
Nothing you have posted should be preventing you from "mapping".
Please describe your Flow. What nodes are you using? What node settings?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| sirisha.n |
| Posted: Thu Mar 27, 2008 3:46 am Post subject: |
|
|
Apprentice
Joined: 25 Feb 2008
Posts: 27
|
Hi jefflowrey,
i have flow like blow :
input node---->mapping node ------> output node
input node properties are:
Input msg pasing : Msg domain : MRM
Msg Set : Sample2_msgset 0H6630002001)
Msg Type : EMPLOYEE
Msg Format : XML1
And validation - - ContentandValue.
thanks. |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Thu Mar 27, 2008 3:49 am Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
there are some difference between mapping node and compute node
The rest is to you, to find the difference, just find out whether mapping node can change the format.
Regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die
Last edited by Gaya3 on Thu Mar 27, 2008 3:49 am; edited 1 time in total |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu Mar 27, 2008 3:49 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Okay.
Now what does "Fail to map" mean?
What error is thrown?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| sirisha.n |
| Posted: Thu Mar 27, 2008 4:15 am Post subject: |
|
|
Apprentice
Joined: 25 Feb 2008
Posts: 27
|
hi jefflowrey,
the input is not parsing. I map the input with the output messagset. But when I assign some tag value of the input to the tag in the output, no value gets mapped and so I get Parser Exception. If we hardcode some value to the output tags, then there is no problem. So, the problem exists becasue the input is not parsing.
thanks |
|
| Back to top |
|
|
|
|
