Re: [DAS Java] created SDO graph doubt 2

2007-04-09 Thread Kevin Williams
I responded before this was moved to ... graph doubt 2. See my answer there. Adriano Crestani 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,

Re: [DAS Java] created SDO graph doubt 2

2007-04-09 Thread Kevin Williams
Hi Guys, The foreign key convention is supported and is demonstrated in this test:ImpliedRelationshipTests.testAddNewOrder() The convention is lightly documented here: http://wiki.apache.org/ws/ConventionOverConfiguration Thanks, --Kevin Luciano Resende wrote: Have you setup the

Re: [DAS Java] created SDO graph doubt 2

2007-04-09 Thread Adriano Crestani
Hello Adriano, To return a graph of related elements, the RDB DAS depends on the user providing a Query that expresses the relationship between the elements. This is most often done by providing a query that includes a join. See the relationship examples in the DAS test suite. Thanks, --Kevin

Re: [DAS Java] created SDO graph doubt 2

2007-04-09 Thread Kevin Williams
It would be possible to support what you are asking but then the DAS runtime would have to process and relate all the returned rows. I think this work is better suited to the Database which is optimized for to do this as part of a join. --Kevin Adriano Crestani wrote: Hello Adriano, To

Re: [DAS Java] created SDO graph doubt 2

2007-04-08 Thread Brent Daniel
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 [EMAIL

Re: [DAS Java] created SDO graph doubt 2

2007-04-08 Thread Luciano Resende
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 [EMAIL PROTECTED] wrote: This is implemented. A column named {x}_ID where {x} is the primary key table name

[DAS Java] created SDO graph doubt 2

2007-04-07 Thread Adriano Crestani
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

Re: [DAS Java] created SDO graph doubt 2

2007-04-07 Thread Luciano Resende
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

Re: [DAS Java] created SDO graph doubt 2

2007-04-07 Thread Adriano Crestani
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 [EMAIL PROTECTED] wrote: Have you setup the relationship on your DAS config file ? Should look something like the example