Values are not getting populated when using JDBC lookup s

[Former Member]

Hi All,

In my scenario i'm trying to populate the control records using jdbc lookups .

i did the all mapping part and when i'm trying to execute the mapping its getting failed,

i e the fields where i used the JDBC lookup are not generating

Plz help me out .

[baskar_gopalakrishnan2 · Accepted solution]

>>> i e the fields where i used the JDBC lookup are not generating

Please elaborate error and go through this link

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/8661. [original link is broken] [original link is broken] [original link is broken]

Are u handlng parameter using signature tab? The above link might be helpful. Also check whether your receiver communication channel is properly configured and no issues.

[Former Member · Accepted solution]

Thanks for ur concern ,

i really forgot to save the paramater in test table ,

Now its working fine , thnks again

[Former Member · Accepted solution]

>

> Thanks for ur concern ,
> i really forgot to save the paramater in test table , 
> 
> 
> Now its working fine , thnks again

For JDBC lookup, i've wrote this little example:

http://simonlesflex.wordpress.com/2010/12/07/pi-oracle-dblookup/

[Former Member]

Hi,

Are you getting any error atleast?

Try to run the scenario from end to end and check the log and payload in Message monitoring -->your JDBC scenario.

Or Monitor your JDBC Receiver channel and check if the data is coiming properly from the JDBC.

Babu