Hi,

I would like to know whether any known issues with ODMG api in handling multiple tables by mapping to a single class. I need to just retrieve the data only . I have seen some documentation
explaining a mapping of a class to multile tables. But I want to know whether it is going to
work for my scenario or not before starting my coding ....


Requirement:
-----------------

I have three independent tables  .

All three tables have part_num and part_serial as part of composite primary key in addition to other columns.

Question: How do I retrieve qty,cost and size by joining all three tables on part_num and
part_serial columns using OJB ???


How do I define this scenario as a class descriptor in repository.xml file ???



TABLE_PARTA:
-------------------------

part_num(pk)
part_serial(pk)
system(pk)
qty


TABLE_PARTB ---------------------


part_num(pk) part_serial(pk) type(pk) cost

TABLE_PARTC :
-----------------------
part_num(pk)
part_serial(pk)
dimension(pk)
size

Please throw some light on the above mentioned issue ...

Thanks in advance ...



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Reply via email to