JDBC graphical lookup for stored procedure

[Former Member]

Hi All,

We have a requirement for JDBC lookup.

At JDBC side we have a stored procedure which taking a request and fetching data from 4 different tables.

Now We want to call this SP in our JDBC lookup at PI mapping.

But I am not sure how to call SP within the graphical lookup tab.

Also we have doubt on which table structure need to be imported in PI.

Need to import all 4 table or we need to create a view at JDBC side and import the structure?

Is there any way we can call SP name at JDBC receiver channel?.

Thanks,

Navneet

[rajasekhar_reddy14]

JDBC lookup tab it is not possible to call SP, because SP one mechanism to perform operation on data base. Lookup functionality bit different so you have to build one more table on data base level,new table will hold the values from 4 taables and perfrom lookup on new table.

If you want to call stored procedure then write a UDF and use callable/prepared statement ann call stored procedure.

[Former Member]

Thanks for the reply..Yes JDBC Graphical Look-Up Doesnt Support Stored Procedure Call and We did individual look-up call to each table as there is no realtion ship between them.