Receiver JDBC Adapter not getting trig0gered

[Former Member]

Hi All

I need help in the following scenario :

A RFC call is used to trigger XI,which in turn is supposed to query the database through a stored procedure

and fetch three values(SELECT Statement) to be passed back to SAP tables,in a synchronous inbound interface

The problem is that the Receiver JDBC Adapter is not getting triggered because of mapping error(unknown)

also ,initial RFC is not passing any parameters to XI and is just a blank call to trigger the interface

The required input values are mapped as constants in the mapping

<b>DATA TYPE

Select Statement

Stored Procedure

action

table

param1

type

isOutput

param2

type

isOutput

param3

type

isOutput

param4

type

isInput </b>

here param4 is populated with 0 as value to query the database(as a key)

Kindly suggest the reason for it to fail in mapping and ways to invoke the JDBC adapter

thanks

SD

[Former Member]

Hi sd,

Just check up with this documentation in detail, regarding the way, the data types for the request and response from the database need to be structured. Since it is a mapping error, you might have missed something while defining the structures...including the stored procedure. Here are the links:-

1. http://help.sap.com/saphelp_nw04/helpdata/en/14/80243b4a66ae0ce10000000a11402f/frameset.htm

2. http://help.sap.com/saphelp_nw04/helpdata/en/14/80243b4a66ae0ce10000000a11402f/frameset.htm

Also, go through these two blogs to help you regarding JDBC stored procedures and JDBC generalised datatypes:-

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

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

Regards,

Sushumna