JDBC Receiver

[Former Member]

Hi Frnds,

I am New 2 XI.

We are developing a scenario (Abap-Proxy to JDBC Receiver), the thing is based on the data captured from SAP

v need 2 update 2 or 3 tables in Oracle (Legacy Sysytem).

My Question is whether it is possible to update 2 or 3 tables

in a Single JDBC receiver or v need to have 2 or 3 JDBC Receiver for updating Tables.

Can u guys plz give an Example?

Any Sort of help wld b appreciated...

Thanks,

Nilakantan.S

[Former Member]

Hi,

It is possible to Insert/Update the data into multiple tables using Single JDBC Receiver..

you have try something like this (Refer this document).

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

Note : The DB name is same for all tables. It is possible. Otherwise best u go for Stored procedure and do all ur logic.

Regards

Vijaykumar

[dharamveer_gaur2]

u can can use multiple statement to update multiple table,every statement corresponding a single table.

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

[Former Member]

Hi nilakantan subramanian,

you can do this using only one JDBC Receiver

by specifing Table Names in MessageMapping

in the Target structue Dublicate the STATEMENT Node, and Specify different Table name

then you can atchive this..

by

Boopalanm

[Former Member]

hi

you can write the STORED PROCEDURES for this purpose,

try repeating the statement in the JDBC xml format.

check the below blogs for reference

JDBC Stored Procedures

XI : Recent Enhancements to JDBC Adapter

calling stored proc s in MAXDB

regards

kummari

[Former Member]

In a single jdbc receiver we can update two or three tables in oracle database. we must include as many statements in the receiver jdbc structure

[former_member203631]

Hi Nilakantan,

Yes it is possible to update 2 or more tables at a time. Each table structure is included as a single statement depending on the available number of tables in the target structure.