tuscany-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Adriano Crestani" <adrianocrest...@gmail.com>
Subject Re: [DAS Java] created SDO graph doubt 2
Date Sun, 08 Apr 2007 00:49:13 GMT
Yes, you got the point Luciano...so the reason is that it's not yet
implemented on Convetion Over Configuration ; ).

Thanks

Adriano Crestani

On 4/7/07, Luciano Resende <luckbr1975@gmail.com> wrote:
>
> Have you setup the relationship on your DAS config file ? Should look
> something like the example below :
>
> <Relationship name="BDATA" primaryKeyTable="A" foreignKeyTable="B"
> many="true">
>        <KeyPair primaryKeyColumn="ID" foreignKeyColumn="B_ID"/>
>     </Relationship>
>
> See more info around relationships on [1] and [2].
>
> Now, if what you want is to have the relationship done via Convention over
> Configuration, I don't think we have that implemented, our set of
> implemented conventions are limited at the moment.
>
> [1] - http://wiki.apache.org/ws/ForeignKeyRepresentationAndManagement
> [2] - http://wiki.apache.org/ws/WorkingWithRelationships
>
>
> On 4/7/07, Adriano Crestani <adrianocrestani@gmail.com> wrote:
> >
> > Another doubt:
> >
> > I have the following tables on my database:
> >
> > create table B (
> >     ID INTEGER NOT NULL PRIMARY KEY
> > );
> >
> > create table A (
> >     ID INTEGER NOT NULL PRIMARY KEY,
> >     B_ID INTEGER,
> >     FOREIGN KEY (B_ID) REFERENCES B(ID)
> > );
> >
> > OK, then I was analyzing the generated sdo graph when I execute the
> query
> > "select * from A, B;", I got something like this:
> >
> > Graph1:
> >
> >
> http://cwiki.apache.org/confluence/download/attachments/45093/das_graph.JPG
> >
> > I understand the column B_ID would be considered only an integer column
> > when
> > of table A when there is no B table returned on the query. However, the
> B
> > table is also returned on the query and as the B_ID column is a FK to
> the
> > table B, shouldn't the graph be like this?:
> >
> > Graph2:
> http://cwiki.apache.org/confluence/download/attachments/45093/das+
> > graph+as+I+suppose+it+shoud+be.JPG
> > <
> >
> http://cwiki.apache.org/confluence/download/attachments/45093/das+graph+as+I+suppose+it+shoud+be.JPG
> > >
> >
> > This way I think the data returned by the query would be better
> > represented
> > on the graph. Maybe there is a reason for the graph to be generated as
> > Graph1 instead of Graph2.
> > What do you say guys?
> >
> > Adriano Crestani
> >
>
>
>
> --
> Luciano Resende
> http://people.apache.org/~lresende
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message