How to use Stored Procedures in JDBC sender side and receiver side

[Former Member]

Hello,

Can anyone explain how to use stored procedures in configuring the scenario using JDBC adapter at bothe sides sender nad receiver..

Thanks,

Soorya

[Former Member]

Hi,

Refer the below link:

JDBC:

Receiver JDBC scenario MS access - /people/sameer.shadab/blog/2005/10/24/connecting-to-ms-access-using-receiver-jdbc-adapter-without-dsn

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30 --> for jdbc receiver: file -JDBC

Stored Procedures-

/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures

http://www.ics.com/support/docs/dx/1.5/tut6.html

/people/sriram.vasudevan3/blog/2005/02/14/calling-stored-procs-in-maxdb-using-sap-xi

http://www.ics.com/support/docs/dx/1.5/tut6.html

http://java.sun.com/docs/books/tutorial/jdbc/basics/sql.html

http://www.sqlteam.com/article/stored-procedures-an-overview

Chirag

[Former Member]

Hi,

Refer the below link:

JDBC:

Receiver JDBC scenario MS access - /people/sameer.shadab/blog/2005/10/24/connecting-to-ms-access-using-receiver-jdbc-adapter-without-dsn

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30 --> for jdbc receiver: file -JDBC

Stored Procedures-

/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures

http://www.ics.com/support/docs/dx/1.5/tut6.html

/people/sriram.vasudevan3/blog/2005/02/14/calling-stored-procs-in-maxdb-using-sap-xi

http://www.ics.com/support/docs/dx/1.5/tut6.html

http://java.sun.com/docs/books/tutorial/jdbc/basics/sql.html

http://www.sqlteam.com/article/stored-procedures-an-overview

HI in the message mapping structure u need to specify the different action and also u need to specify the procedure name.

refer the below link which has all the associated action

http://help.sap.com/saphelp_nw04s/helpdata/en/22/b4d13b633f7748b4d34f3191529946/frameset.htm

Chirag