Skip to Content
author's profile photo
Former Member

JDBC TO RFC SCENARIO

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 comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

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

    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 comment
    10|10000 characters needed characters exceeded

    • Hi deepak,

      <i>

      >>it be the type of interface i am using 1 .... unbounded.

      and RFC 0....unbounded. </i>

      Yes it can be, provided your sender JDBC returns atleast one result. One is mandatory. :).

      Regards

      Suraj