on 07-19-2005 3:39 PM
Hi Everybody,
I am trying to do a SELECT from MS SQL server DB.
My DT MT and everythigs fine...Only that i dont get back my resultset in the result section of the HTTP client adapter.
In sxmb_moni both the request and the response message show chekkered flag.
In the Response Message i can see the row returned in the <b>XML Message -> Call Adapter -> Payloads -> Main Document(application/xml)</b>
But am not able see the same row in <b>XML Message -> Request Message Mapping -> Payloads -> Main Document(application/xml)</b>
Please help me out.
Regards,
Suresh.
Hi suresh,
hope you hav made both of ur message interfaces sync....Please check ur mapping as well..the occurances of data items.
theres no need for a sender jdbc adapter.
and you dont need a sender agreement as weel for http adapter.
Regards,
Priyanka
Message was edited by: Priyanka Balagangadharan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sudhir,
Yeah i have all my datatypes etc defined as per the thread you mentioned...
As described the response message in sxmb_moni contains the row selected in the <b>XML Message -> Call Adapter -> Payloads -> Main Document(application/xml)</b>
but not in <b>XML Message -> Request Message Mapping -> Payloads -> Main Document(application/xml)</b>
Only the fetched row is not seen in the result field of client http adapter.
Do i need a sender JDBC adapter to send the fetched row from DB to XI to HTTP adapter...i dont think thats needed...
what else can be possible reason for the problem am facing.
Many thanks,
Suresh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.