Sender JDBC Problem

[Former Member]

Hi

can any one hlp me..

My scenrio is JDBC is sender and file is Receiver.

problem is JDBC adapter is hitting the SQL server and retrived the data and Inbound message and Receivng Grouping Payload ..like this..

<?xml version="1.0" encoding="utf-8" ?>

- <resultset>

- <row>

<TransactionNumber>118</TransactionNumber>

<CompanyCode>1004</CompanyCode>

<CustomerNumber>1368986</CustomerNumber>

</row>

Response payload is showig only name space..of frist two lines..

<?xml version="1.0" encoding="UTF-8" ?>

<ns0:resultset_mt xmlns:ns0="urn:Poll_Database_File" />

even MessageData and Audit logs showing successfully delivered ..

Other than soap content in Message Content showing only name space of xml...first two lines..

So please let me know , where i did mistake?

Regards..Rambarki

[Former Member · Accepted solution]

First check whether your SQL statement returning any rows at all.

regards

Shravan

[Former Member · Accepted solution]

Sharavan..the SQL statement is working fine..

otherwise i wont get this payload in Inbound Message

<?xml version="1.0" encoding="utf-8" ?>

- <resultset>

- <row>

<TransactionNumber>118</TransactionNumber>

<CompanyCode>1004</CompanyCode>

<CustomerNumber>1368986</CustomerNumber>

</row>

- <row>

<TransactionNumber>254</TransactionNumber>

<CompanyCode>1004</CompanyCode>

<CustomerNumber>2755685</CustomerNumber>

</row>

see u can find the data in payload..but thing is repsonse payload showing like this..

<?xml version="1.0" encoding="UTF-8" ?>

<ns0:resultset_mt xmlns:ns0="urn:Poll_Database_File" />

only..

i didn;t understand..what is this error/

regards

sankar

[Former Member · Accepted solution]

Hello

First put your Inbound payload message in the Test tab of message mapping and check whether the data is populated to the target side.

If it does not work then check your mapping and I think since you retrieve multiple rows the occurance of <rows> should be 0...unbound. and also see that this is mapped to the field on your target side with same occurance.

Hope this works for you....

[Former Member · Accepted solution]

Hi

I have cross checked every thing..the Inbound payload copied and tested in mapping ..its populating properly in target side..and mapped <rows> in source and target side with occarance 0..unbound.

Interface determiniation showing proper inbound interface and mapping program ..my update query working fine..even i tested using <test> instead of update query..that is also working fine..

even i have taken the same structure source and target..and tested ..the same response i'm getting ..without payload..!

i didn't understand where i did mistake?

if you have any chance to look @ my screen shots..please let me know and send ur mail id to urambarki@newegg.com

Thank you for ur great support..

Regards..Rambarki!

[Former Member · Accepted solution]

Hi Raju,

Its working fine..thank you verymuch..!

the small mistake made me big trouble..for last 1week..I thought document namespace is optional..thats the reason I left..because its not in " * "..

Thanks once again to all ..

regards...rambarki!

[Former Member]

Hi,

Just check your message mapping .Refer to this weblog

https://www.sdn.sap.com/irj/sdn/weblogs?

blog=/pub/wlg/2374 (Ensure that your target structure

is correct one since your source message is correct)

If you get correct result then check your mapping

program name in Integration Directory(Interface

Determination --> Inbound message type and mapping

program name ) .

Also ensure that your cache is refreshed.(SXI_CACHE)

Shikha

[Former Member]

Check your Message Mapping using test cases. check whether it succeeds.

Regards

Venkataramanan

[Former Member]

Hi,

I just want to know what you gave in the <b>update</b> statement

field in sender JDBC configuration parameter. If you are

not updating anything just give <test> in that field.

Just check it out.

Regards

Sudharshan