| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Retrieving multiple records using JDBC adapter |
« View previous topic :: View next topic » |
| Author |
Message
|
| Yuvaraj |
 Posted: Sun Nov 12, 2006 8:39 am Post subject: Retrieving multiple records using JDBC adapter |
 |
|
Apprentice
Joined: 28 Oct 2003
Posts: 30
|
Hi
Need help regarding retrieving multiple records from database using JDBC adapter.
I have created a BO corresponding to the table structure and I need to create a Wrapper BO to support multiple cardinality.
I am sending the Wrapper BO with multiple child BO, with each BO having different Key field value. JDBC adapter needs to retrieve records corresponding to each of the key value and send it back to collaboration.
How do I proceed to achive this? How should my Wrapper BO look like?
Appreciate your help
Thanks
Yuvaraj |
|
| Back to top |
|
 |
| vk |
| Posted: Mon Nov 13, 2006 10:37 am Post subject: |
|
|
Partisan
Joined: 20 Sep 2005
Posts: 302
Location: Houston
|
Yuvaraj,
I have implemented this with WMQI broker. In the Business Object level Application Specific Information, set WRAPPER=true. Also in the child BO, application specific Information, set FK=<ParentBOName>:<AttributeName>
In the event table for the JDBC adapter, we need to make only 1 entry for the wrapper BO having the key field value which will tie the parent and child BOs. The JDBC adapter will pick up the wrapper BO first from the parent table and then all the child BOs from the child table and send them in a single XML message to the delivery queue.
I am not sure if the operation is different with ICS broker.
Regards,
VK. |
|
| Back to top |
|
|
| Yuvaraj |
| Posted: Mon Nov 13, 2006 11:00 am Post subject: Retrieving multiple records using JDBC adapter |
|
|
Apprentice
Joined: 28 Oct 2003
Posts: 30
|
Thanks VK.
But I think I haven't clearly explained the scenario. JDBC adapter is configured on the destination side and am making a service call from my collaboration to retrieve records from db tables based on the key values populated in the BO sent to JDBC adapter.
Say for example if am populating the Wrapper BO with 2 Child BO containing the EmpNo populated with say 123 and 345 respectively, then I should retrieve from the DB table - the employee records corresponding to EmpNo 123 and 345.
Please let me know how to do this in ICS using Wrapper BO.
Thanks |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
