RFC to JDBC

[Former Member]

I have to Develop a Synchronous RFC to JDBC scenario.

From the RFC I will be sending the Policy Number and need to fetch the other pertinent information for that policy number and need to return to the RFC. I am calling a Stored Procedure on the JDBC Side.

This is a Synchronous Scenario.

Would some one explain me the exact steps for the above scenario and also specially on the JDBC side how should I configure the JDBC adapter to call the Stored Procedure?

Thanks

[moorthy]

HI,

Already many help links are mentioned . Just to add on that,

Make sure that,

1) RFC Req to JDBC Req mapping

2) JDBC Response to RFC response mapping is carried out

Also note that, all document format of Synchronous message response from stored procdeure should be a result set as mentioned in the blogs

Regards,

Moorthy

[Former Member]

Hi Mohini,

For synchronous receiver JDBC have a look into the blog:

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

and for stored procedure ref:/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures

Do let me know if you need further help on this...

Regards,

Jai Shankar.

[Former Member]

Hi,

An example of stored procedure and data structure for JDBC adapter:

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

Regards

Vijaya