JDBC Adapter

[Former Member]

Hi All,

I am having a scenario in which I have to get data from 2 tables c1 and d1 and have to insert into 2 tables.There will be multiple records in d1 corresponding to one record of c1.

Presently I am mapping 'row' of sender message type to 'access' of statement1 in receiver messagetype and level 0 i.e messagetype to 'access' of statement2 in receiver messagetype.That means I am picking only one record from c1 and its corresponding records from d1.

If I want to get multiple records from c1 and their corresponding records from d1 then how should I do the mapping.

Regards,

Radhika.

[Former Member]

Hi Radhika !

Could you explain more clearly what are you mapping ?

You can create a "join" query that retrieves data from two or more tables at once, of course records among all tables should be related. Then you can use multimapping to create multiple "insert/update" actions on the target system. For multimapping, check this thread:

Regards,

Matias

ps: please award points if helpful.