JDBC Adaptor

[Former Member]

Hi All,

I am doing the scenario in which I have to call stored procedure from JDBC Receiver. I had created stored procedure in MS-ACCESS. How should I call this stored procedure from JDBC receiver adaptor.

Thanks in advance.

Sugeet.

[nikhil_bose]

hi sugeet,

1). Reciever Configuration

Transport Protocol: JDBC 2.0

Message Protocol: XML SQL Format

Adapter Engine: Integration Server

JDBC Driver: jdbc.odbc.JdbcOdbcDriver

Connection: jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=//xiserver/xitemp/db/TestDB.mdb

2) Calling stored procedure

after creation the stored procedure

follow from the 3rd step of link below

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

get me your status

thanks

nikhil

[Shabarish_Nair]

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

Stored Procedures-

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

Ref. them.

[Former Member]

In addition to that use http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm to understand the basic and standard structure of the JDBC receiver(it also tells about to call Stored Procedure)

Thanks

Farooq.

[Former Member]

See this to call stored procedure.

<StatementName5>

<storedProcedureName action=” EXECUTE”>

<table>realStoredProcedureeName</table>

<param1 [isInput=”true”] [isOutput=true] type=SQLDatatype>val1</param1>

</storedProcedureName >

</StatementName5>

[Former Member]

Hi Farooq,

Thanks a lot.

Best regards,

Sugeet.

[Former Member]

No problem, but let us know if you are able to complete your scenraio or not:)

Thanks

Farooq.

[Former Member]

Thanks a lot Shabarish.