tuscany-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Luciano Resende" <luckbr1...@gmail.com>
Subject Re: [DAS Java] created SDO graph doubt 2
Date Mon, 09 Apr 2007 05:00:54 GMT
Interesting, I have a same scenario on a shoppingcart application I am
working on, and it does not work if I don't have the relationship defined on
my das config.

On 4/8/07, Brent Daniel <brenthdaniel@gmail.com> wrote:
>
> This is implemented. A column named {x}_ID where {x} is the primary
> key table name is assumed to be a foreign key to a column named ID in
> the PK table. Examples are in ImpliedRelationshipTests. I'm not sure
> why it isn't working for you here, though.
>
> Brent
>
>
> On 4/7/07, Adriano Crestani <adrianocrestani@gmail.com> wrote:
> > 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
> > >
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tuscany-dev-unsubscribe@ws.apache.org
> For additional commands, e-mail: tuscany-dev-help@ws.apache.org
>
>


-- 
Luciano Resende
http://people.apache.org/~lresende

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