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