ABOUT MAPPING IN FILE TO JDBC?

[Former Member]

can any one give me how the mapping takes place between file structure and jdbc structure ,

from where we will get receiver side structure(JDBC SIDE) and

How the data in file is mapped and

Where we store stored procedure and data.

How stored procedure is executed. and data is transfered to the database.

I am expecting answer in full detail.

[prabhu_s2]

<b>can any one give me how the mapping takes place between file structure and jdbc structure ,

from where we will get receiver side structure(JDBC SIDE)</b>

mappin takes place during the interface determination phase (pipleline service). the strucutre will be defined in message type which is attached to the interface definition.

<b>How the data in file is mapped</b>

the data is file is mapped to either graphical or abab or java or xslt mapping. it is based on ur req u select the mapping type.

<b>Where we store stored procedure and data</b>

the stored procedures are first checked in the DB sasy if ur using opracle u create a stored procedure andd check if it is working fine. then u use the stored procedure name in the JDBC adapter under the section query. this is executed and fetches the data at AE(adapter engine)

PS: award potins to all helpful replies

[Former Member]

Hi;

Refer to following ling link for detailed description of your all JDBC related Queries.

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/frameset.htm

Mudit

[Former Member]

Hi RamMohan,

from where we will get receiver side structure(JDBC SIDE) and

we get this from table which are updating instering or deleting.

[Former Member]

Hi,

Please see below links

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

/people/siva.maranani/blog/2005/09/16/xi-how-to-on-jdbc-receiver-response

How to check JDBC SQL Query Syntax and verify the query results inside a User Defined Function of the Lookup API -

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

/people/prasad.illapani/blog/2006/10/25/how-to-check-jdbc-sql-query-syntax-and-verify-the-query-results-inside-a-user-defined-function-of-the-lookup-api

http://help.sap.com/saphelp_nw2004s/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

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

/people/swaroopa.vishwanath/blog/2006/12/28/send-rfc-to-sap-xi-150-asynchronous

Regards

Chilla..