Return-Path: 
 <tuscany-dev-return-16567-apmail-ws-tuscany-dev-archive=ws.apache.org@ws.apache.org>
Delivered-To: apmail-ws-tuscany-dev-archive@locus.apache.org
Received: (qmail 71405 invoked from network); 8 Apr 2007 00:43:51 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 8 Apr 2007 00:43:51 -0000
Received: (qmail 66251 invoked by uid 500); 8 Apr 2007 00:43:56 -0000
Delivered-To: apmail-ws-tuscany-dev-archive@ws.apache.org
Received: (qmail 66224 invoked by uid 500); 8 Apr 2007 00:43:56 -0000
Mailing-List: contact tuscany-dev-help@ws.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:tuscany-dev-help@ws.apache.org>
List-Unsubscribe: <mailto:tuscany-dev-unsubscribe@ws.apache.org>
List-Post: <mailto:tuscany-dev@ws.apache.org>
List-Id: <tuscany-dev.ws.apache.org>
Reply-To: tuscany-dev@ws.apache.org
Delivered-To: mailing list tuscany-dev@ws.apache.org
Received: (qmail 66215 invoked by uid 99); 8 Apr 2007 00:43:56 -0000
Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 07 Apr 2007 17:43:56 -0700
X-ASF-Spam-Status: No, hits=2.0 required=10.0
	tests=HTML_MESSAGE,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (herse.apache.org: domain of luckbr1975@gmail.com
 designates 66.249.82.226 as permitted sender)
Received: from [66.249.82.226] (HELO wx-out-0506.google.com) (66.249.82.226)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 07 Apr 2007 17:43:48 -0700
Received: by wx-out-0506.google.com with SMTP id h28so1138616wxd
        for <tuscany-dev@ws.apache.org>; Sat, 07 Apr 2007 17:43:27 -0700 (PDT)
DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed;
        d=gmail.com; s=beta;
        h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;
        b=l2BnB2DoJdAWHpdIZGDcKU/Ecz0Yeu9czxClPbbKnkDoRY45TBQKxQhTTaqXxZ/hTT1rizO9OnFwHAW4+JO8O4lrKUynuTqS6z4beawNxgc0wcAZXao9wD8bH8aVVPvualBQyMT56kapBnnSoIZl1caOqHij+xGB4mABMR+mxdk=
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;
        b=BR9BI34IYWS0TRI1bB/54YN/Ww0JpK81d7Nxl/AI7J9ziZ2kgXemIFuSNuPltk1bADaTszI1ztx8teGevKtTmWWWRNjwOSqSnSA46uVll7hhR/3f5YOJMAEwKbYvH090vl9IwOHsQU6RaobjTgBcYiF0mfiLhm1GzBG+FQG1J04=
Received: by 10.114.201.1 with SMTP id y1mr1765258waf.1175993006876;
        Sat, 07 Apr 2007 17:43:26 -0700 (PDT)
Received: by 10.114.173.20 with HTTP; Sat, 7 Apr 2007 17:43:26 -0700 (PDT)
Message-ID: <5a75db780704071743h72fd6938lf0493b91c13d6e55@mail.gmail.com>
Date: Sat, 7 Apr 2007 17:43:26 -0700
From: "Luciano Resende" <luckbr1975@gmail.com>
To: tuscany-dev@ws.apache.org
Subject: Re: [DAS Java] created SDO graph doubt 2
In-Reply-To: <55e2bf7e0704071359h134785f1k88f61baad5c72b70@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_22704_23167479.1175993006792"
References: <55e2bf7e0704071359h134785f1k88f61baad5c72b70@mail.gmail.com>
X-Virus-Checked: Checked by ClamAV on apache.org

------=_Part_22704_23167479.1175993006792
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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

------=_Part_22704_23167479.1175993006792--