Skip to Content
0
Former Member
Mar 04, 2009 at 01:16 PM

Problem in JDBC lookup in PI 7.1

42 Views

Hello,

I am working on PI 7.1 which has "JDBC Lookup" function available. We just need to configure them. I have done all configuration correctly (as explained in many blogs and docs on SDN) like:

1. Importing the table structure in External Defination using JDBC Receiver CC

2. Configuring JDBC Lookup function by creating a Parameter in Messaging Mapping, selecting the parameter in the Lookup, selecting the Table from the external defination, create a query by selecting fields from tbale on teh left and right column of JDBC adapter.

3. I then assign the same JDBC Receiver CC of step 1 to the mapping Parameter (in the test tab to test the lookup). I use teh same CC as the table is the same.

When i test my mapping, i dont get any data back. It doesnt give me any error either. The table has the record which i want but mapping doesnt return anything. Its blank.

Can anyone suggest where i am going wrong please?

Regards,

Yash