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