JDBC adapter

[Former Member]

Hi Experts

Please explain a business scenario for JBDC to any system…like R/3 is sending some data to Oracle wherein the data need to b updated in multiple tables.…..mostly wht kind of Statement is execute at DB side like SELECT, INSERT etc… ???

Cheers

Faisal

[former_member189441]

hi,

Refer this link related with JDBC receiver..

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e

869e10000000a155106/content.htm

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

Regards

Murali

[Jitendra_Jeswan]

Got to the Following link for more details :

http://help.sap.com/saphelp_nw04/helpdata/en/0d/5ab43b274a960de10000000a114084/frameset.htm

Mostly used statements:

INSERT : When you want to insert rows

UPDATE_INSERT : When you want to check if the fields already exist and depending on this you want to insert or Update.

EXECUTE: When you want to run stored procedure

UPDATE: When you want to perform an Update only.

To insert Idoc data to multiple tables

I would use INSERT with following Cannonical form:

<MT_Sample>

<StatementName1>

<dbTableName1 action=”INSERT”>

<access>

<col1>val1</col1>

<col2>val2</col2>

.....

</access>

</dbTableName1>

</StatementName1>

<StatementName2>

<dbTableName2 action=”INSERT”>

<access>

<col1>val1</col1>

<col2>val2</col2>

.....

</access>

</dbTableName2>

</StatementName2>

/MT_Sample>

Regards.

Jeet.

[Former Member]

Faisel,

Its depends up the DB what you are using. you have to use insert or update statements which DB is receiver.

Also if you use multiple tables you can use JOINS. Goto google and search for that you can easily find out.

Regards

Shankar.