You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@tuscany.apache.org by Amita Vadhavkar <am...@gmail.com> on 2007/07/26 14:53:27 UTC
[RDB DAS] Reason for empty SingleTableRegistry?
When there are no relationships in config, the single table registry is
used.
And it have no functionality. Take case of below data and query -
Data -
SINGER(ID, NAME)
{1, John}
{2, Jane}
SONG(ID, TITLE, SINGERID)
{10,'Song1' ,1}
{20, 'Song2',1}
{30, 'Song3',2}
Query -
SELECT SINGER.ID, SINGER.NAME, SONG.ID, SONG.TITLE FROM SINGER, SONG WHERE
SINGER.ID = SONG.SINGERID
So,
[1]in no relationship case this data and query results in 3 SINGER
DataObjects
and 3 SONG DataObjects.
[2]Where as when there is relationship defined between
SINGER and SONG, the result is 2 SINGER DataObjects and 3 SONG DataObjects.
<Relationship name="sings" primaryKeyTable="SINGER" foreignKeyTable="SONG"
many="true">
<KeyPair primaryKeyColumn="ID" foreignKeyColumn="SINGERID"/>
</Relationship>
Why are we treating [1] in a way different than [2] and giving
extra/duplicate DataObjects
in case of [1]?
Regards,
Amita