proxy to jdbc

[former_member217032]

hi,

i have structure like this....

sender Proxy

header

matnr

batch

logrt

item

matnr

makt

igort

i ahve to mapp this structuere to JDBC Receiver

like

Reciever JDBC

header

matnr

batch

logrt

matnr

makt

igort

PLZ help me how to do this scenario?

[Former Member]

Hi Mustaq,

Create Receiver Datatype as standard Dtabase format like

STATEMENT

TEST

action

access

<fields>

create DT,MT,SI for both sender & receiver and MM,OM in IR.

create receiver comm channel,R.A,I.D,R.D in ID.

then logon to SAP system,use TC SPROXY.

expand ur SWC,Name space.here u'll avaialable ur S.I,Right click on SI.then it'll ask prefix name & package name.then internally ABAP Class will be generated.

ABAP Class generated by following syntax : (Prefix)(CO)_SI.

Logon to SE38 Abap editor in SAP System,then write some OOPS ABAP Code using ABAP Class what we generated.then execute the program.then it'll generate target xml

Thnx,

Siva

[former_member196023]

Hi,

Pl have a look at this link also [Proxy to JDBC|http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/e0ac1a33-debf-2c10-45bf-fb19f6e15649?quicklink=index&overridelayout=true].

Thnx,

-Haresh

[Former Member]

Hi

To work with JDBC adapter you have create your Datatypes as mentioned in the below,

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

JDBC receiver Scenarios

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

/people/alessandro.berta/blog/2005/10/04/save-time-with-generalized-jdbc-datatypes

Regards

Ramg

[Shabarish_Nair]

this is a typical Proxy to JDBC scenario;

proxy - /people/ravikumar.allampallam/blog/2005/03/14/abap-proxies-in-xiclient-proxy

jdbc - http://help.sap.com/saphelp_nw04/helpdata/EN/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

please note that there are more than enough reference available on SDN.

So do a search and help yourself !!!