JDBC lookup issue

[Former Member]

Hello guys, I am working on JDBC to IDOC scenario.I would like to fetch the milestones and it's corresponding records of an unique project ID to different data segments. The structure of the the JDBC table is as below :

The mapping that we have done is :

The JDBC lookup look like this :

And the output :

The problem is that it is not creating the data segments for all the milestones except for the first record.

Thanks & regards,

Sambaran

[rajasekhar_reddy14 · Accepted solution]

Hi Sambaran,

1)If your input arguments are for multiple records then you receive one mile stoone number ,so you have to repeat this value multiple times at target end ,so you have to build mapping logic using useoneAsMany,splitby value function to repear JDBC lookup out multiple times.

Dont build mapping logic to perform JDBC looks up multiple times for same input parameters, this is bad design.

2)You have to build JDBC lookup logic to perform multiple cals for difference data, use siplit by value combination accordingly.

Thank you,

Raj

[Former Member · Accepted solution]

Hi Amit,  Already tried it,didnt work !  Raja,  1 project ID correspond to n number of Milestone,but when I put the input arguments,it gives only the first milestone id and not generating the other data segments with other milestone ids for the IDOC in the receiver end.  Each and every Milestone is unique, so one Project ID should fetch multiple unique Milestone number,why you think,it's a repeatation? could you please clarify?  2. Could you please send me the correct mapping how I can do it?  Thanks a lot !

[Former Member · Accepted solution]

Hello,  We created an UDF and the problem is solved !  Thanks for you help anyways !

[Former Member]

Hello,

It seems to be a context problem, use split by value (Each value) and then check?

Thanks

Amit Srivastava