Skip to Content
author's profile photo Former Member
0
Former Member

JDBC TO RFC SCENARIO

Posted on Sep 30, 2005 at 06:00 AM 29 Views

Hi,

I am tryiing JDBC TO RFC SCEANRIO.

XI is picking data from MS SEQUEL SERVER but

the same data is not getting mapped into RFC

I am not getting any error as such.

Following are the details.

made a datatype

resultset

row

EmployeeID

LastName

FirstName

message mappping

RFCFORJDBC

resultset outab

row item

EmployeeID----

Empno

FirstName

concatenate--- Empname

Lastname

But for some odd reason

the OUTTAB FOR RFC

is coming like this in message

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

- <p3:ZZTESTXIJDBC xmlns:p3="urn:sap-com:document:sap:rfc:functions">

<OUTAB />

</p3:ZZTESTXIJDBC>

while payload is getting picked correctly

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

- <resultset>

- <row>

<EmployeeID>9</EmployeeID>

<FirstName>Anne</FirstName>

<LastName>Dodsworth</LastName>

</row>

</resultset>

Kindl help with the same

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Sep 30, 2005 at 06:08 AM
    0

    looks like you are missing namespace in the JDBC data, you should mention the docNamespace in the JDBC sender adapter.

    Copy your payload and paste this in your mapping test tab. How ? After copying the payload go to Message mapping, there is Tab for Test right next to the Design. click on that and then click on the SRC button in the source message and paste your XML and do a test. Then you will know whats going wrong.

    One other precaution is, you can fill the fields in the test tab then click on SRC button to look at what the source XML should look like.

    hope you understand, if not post the question again.

    regards

    Shravan

    Add a comment
    10|10000 characters needed characters exceeded

    Comment on This Answer

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.