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

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
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 r

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

2007-04-09 Thread Kevin Williams
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, --Ke

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 nam

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 PRO

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 b

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 : 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 implemente

Re: [DAS Java] created SDO graph doubt

2007-04-07 Thread Adriano Crestani
Last doubt moved to thread: "[DAS Java] created SDO graph doubt 2" Adriano Crestani On 4/7/07, Adriano Crestani <[EMAIL PROTECTED]> wrote: Another doubt: I have the following tables on my database: create table B ( ID INTEGER NOT NULL PRIMARY KEY ); create table A (

[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

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

2007-04-05 Thread Adriano Crestani
Thanks kelvin ; ) Adriano Crestani On 4/4/07, Kevin Williams <[EMAIL PROTECTED]> wrote: The RDB DAS will only populate a graph with data returned from the used query. If you want a graph that contains data from related tables then the query provided must return that data (typically a join).

Re: [DAS Java] created SDO graph doubt

2007-04-04 Thread Kevin Williams
The RDB DAS will only populate a graph with data returned from the used query. If you want a graph that contains data from related tables then the query provided must return that data (typically a join). The relationship tests in the test suite demonstrate this. --Kevin Adriano Crestani wrot

Re: [DAS Java] created SDO graph doubt

2007-04-04 Thread Adriano Crestani
Thanks Amita, I also debugged the code and took this conclusion. And I wasn't sure if it's supposed to work this way. Is there anybody that could confirm that it should work this way? Adriano Crestani On 4/4/07, Amita Vadhavkar <[EMAIL PROTECTED]> wrote: Hi Adriano, Let me show what I got so

Re: [DAS Java] created SDO graph doubt

2007-04-04 Thread Amita Vadhavkar
Hi Adriano, Let me show what I got so far: Below is the debug dump and the relevant portion of the logic will be in ResultSetProcessor and ResultSetRow. Based on it, it is seen that the parent/s attributes and data is not added. Please let me know if you are looking for something more/different.

[DAS Java] created SDO graph doubt

2007-04-03 Thread Adriano Crestani
Let me try to explain my doubt: Lets suppose I create a select command and execute it. The returned ResultSet has an attribute that belongs to the table X and is a FK to the table Y, but no Y attribute is contained in the ResultSet. The question is: does the das create, and also populate, the SDO