cancel
Showing results for 
Search instead for 
Did you mean: 

Select from HTTP client adapter <-> XI <-> to MS SQL server

suresh_krishnamoorthy
Active Contributor
0 Kudos

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.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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

suresh_krishnamoorthy
Active Contributor
0 Kudos

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