Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

RFC to JDBC for select

Hi,

I have an RFC to JDBC scenario. I need to make RFC call to DB and using select need to get the DataBase Table Data.

I am little bit confused here, Can you please tell me how many data types, Message Types, Msg Mappings, Msg Inetrfaces for that??.

I know like this: 2 DTs for DB table. One when I make the RFC call, another when I return my data from DB to RFC. So, how to do the Msg Map??. I am liitle bit confusing.

Thanks-a-lot in advance for your help.

Regards,

Sunita.

replied

Hi,

As you will be using the JDBC adapter as your Reciver that will select data from the database, the Adapter will be SYNCHRONOUS and the format of the Datatype has to be,

<DT>

<StatementName4>

<dbTableName action=”SELECT”>

<table>realDbTableName</table>

<access>

<col1/>

<col2/>

<col3/>

</access>

<key1>

<col2>val2old</col2>

<col4>val4</col4>

</key1>

<key2>

<col2>val2old2</col2>

</key2>

</dbTableName>

</StatementName4>

</Dt>

The COL between ACESSS will contain the column names that have to be selected from the database.

The values between KEY will contain the conditional values.

The response will be of this format,

<DT_response>

<row>

<column1>value11</column1>

<column2>value12</column2>

...

</row>

...

<row>

<column1>valueN1</column1>

<column2>valueN2</column2>

...

</row>

<DT_Response>

Just create the Datatypes of this formats for the request and response JDBC and it will work fine.

Do let us know if u need any further help.

All info will be available on this link,

http://help.sap.com/saphelp_nw2004s/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Regards,

Bhavesh

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question