Help on RFC to JDBC and JDBC to RFC

[Former Member]

Help on RFC to JDBC and JDBC to RFC

Hi Gurus

I have the scenario where an RFC will be triggered in SAP , to write to a DB2 database and insert new records in a table

and vice versa the JDBC has to read som data from a table based on a primary key, mark them as read for not be read next time and send the data to an RFC where a table in SAP will be updated.

I have never worked with JDBC before , pls advice.

is there any new issue to consider in PI 7.0 regarding JDBC

Thanks.

[former_member204873 · Accepted solution]

You may create an SP doing Insert and then your select to read som data from a table based on a primary key.

Look at the structures to be created in PI for same:

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

[Former Member]

Thank you all

closing

[rajasekhar_reddy14]

The requirement looks standard,

SEARCH IN SDN FOR JDBC scenarios,you will find many docs for sender as well as Receiver.

>

> is there any new issue to consider in PI 7.0 regarding JDBC

>

no issue with PI7.0.

Regards,

Raj

[Former Member]

Hi

Thanks for the answers , it is not a synchr. scenario

it is 2 different scenarios.

regards.

[Former Member]

Hi,

Do u mean,you have to configure a synchronous scenario RFC to JDBC.Please find below links for the same.

http://wiki.sdn.sap.com/wiki/display/XI/stepbystepRFCtoJDBCscenario

/people/peng.shen2/blog/2010/06/07/rfc-to-jdbc-synchronous-scenario-guide-part-i

Thanks

nidhi