db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Eigen Technology Pty Ltd" <mich...@eigentechnology.com>
Subject RE: Foreign Key
Date Tue, 21 Jan 2003 05:44:28 GMT
Thanks.

michael


> You can add the foreign key definition in the schema. Look at the
> element:reference in
> http://jakarta.apache.org/turbine/torque/schema-reference.html
>
> I think it would work just by creating the join in the criteria but if
> you add the reference
> it will add some methods that would make it easier and it will create
> the foreign key definitions
> in the .sql that creates the tables.
> --
>   Humberto
>
> -----Original Message-----
> From: Eigen Technology Pty Ltd [mailto:michael@eigentechnology.com]
> Sent: Monday, January 20, 2003 1:00 AM
> To: turbine-torque-user@jakarta.apache.org
> Subject: Re: Foreign Key
>
>
> Thanks,
>
>>From what you have suggested, I don't have to add Foreign Keys to these
> fields in my sechma file? All is needed is just a join criterial in my
> .java file.
>
> thanks
> michael
>
>
>
>> Hi Michael,
>>
>> I'm guessing you're trying to get the data from Table 2.  So the
>> following would be all that's required (I think):
>>
>> Criteria criteria = new Criteria();
>> criteria.add(Table1Peer.ID, <your constraint here>);
>> criteria.addJoin(Table1Peer.ID, Table2Peer.Col_C);
>> criteria.addJoin(Table1Peer.ID, Table2Peer.Col_D);
>>
>> List result = Table2Peer.doSelect(criteria);
>>
>> HTH,
>> CP
>>
>>
>> Eigen Technology Pty Ltd wrote:
>>> Hi...
>>>
>>> If a table has two columns which are related to another table, can I
>>> Join them using Foreign Key, if so, how could I do it?
>>>
>>> Table 1
>>> ID
>>> Col_A
>>> Col_B
>>>
>>> Table 2
>>> ID
>>> Col_C   <----  need to link to ID in table_1
>>> Col_D   <----  also need to link to ID in table_1
>>>
>>> thanks
>>> michael
>>>
>>>
>>>
>>> --
>>> To unsubscribe, e-mail:
>>> <mailto:turbine-torque-user-unsubscribe@jakarta.apache.org> For
>>> additional commands, e-mail:
>>> <mailto:turbine-torque-user-help@jakarta.apache.org>
>>>
>>>
>>>
>>
>>
>> --
>> R E D S H E R I F F
>> C.P. Lim - Software Engineer
>> Level 1, 10 Queens Road    +61 3 9864 0733 tel
>> Melbourne VIC              +61 3 9864 0778 fax
>> Australia                  +61 413 781 846 mob
>>
>> This message and any files transmitted with it are confidential and
>> intended solely for the use of the individual or entity to whom they
>> are
>>  addressed. If you are not the intended recipient, you are hereby
>> notified that any use or dissemination of this communication is
>> strictly
>>  prohibited. If you have received this message in error please notify
>> us immediately by return email or telephone +61 (3) 9659 0432, then
>> delete this message. Any views expressed in this message are those of
>> the
>> individual sender and many not necessarily reflect the views of Red
>> Sheriff.
>>
>>
>> --
>> To unsubscribe, e-mail:
>> <mailto:turbine-torque-user-unsubscribe@jakarta.apache.org> For
>> additional commands, e-mail:
>> <mailto:turbine-torque-user-help@jakarta.apache.org>
>
>
>
>
> --
> To unsubscribe, e-mail:
> <mailto:turbine-torque-user-unsubscribe@jakarta.apache.org>
> For additional commands, e-mail:
> <mailto:turbine-torque-user-help@jakarta.apache.org>
>
> --
> To unsubscribe, e-mail:
> <mailto:turbine-torque-user-unsubscribe@jakarta.apache.org> For
> additional commands, e-mail:
> <mailto:turbine-torque-user-help@jakarta.apache.org>




Mime
View raw message