From torque-user-return-3216-apmail-db-torque-user-archive=db.apache.org@db.apache.org Tue Oct 14 21:32:25 2003
Return-Path: <torque-user-return-3216-apmail-db-torque-user-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-torque-user-archive@www.apache.org
Received: (qmail 93944 invoked from network); 14 Oct 2003 21:32:25 -0000
Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12)
  by minotaur-2.apache.org with SMTP; 14 Oct 2003 21:32:25 -0000
Received: (qmail 81980 invoked by uid 500); 14 Oct 2003 21:32:09 -0000
Delivered-To: apmail-db-torque-user-archive@db.apache.org
Received: (qmail 81968 invoked by uid 500); 14 Oct 2003 21:32:09 -0000
Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:torque-user-unsubscribe@db.apache.org>
List-Subscribe: <mailto:torque-user-subscribe@db.apache.org>
List-Help: <mailto:torque-user-help@db.apache.org>
List-Post: <mailto:torque-user@db.apache.org>
List-Id: "Apache Torque Users List" <torque-user.db.apache.org>
Reply-To: "Apache Torque Users List" <torque-user@db.apache.org>
Delivered-To: mailing list torque-user@db.apache.org
Received: (qmail 81954 invoked from network); 14 Oct 2003 21:32:08 -0000
Received: from unknown (HELO ssbntbne2.shadebirdair.com) (210.18.193.227)
  by daedalus.apache.org with SMTP; 14 Oct 2003 21:32:08 -0000
Received: from ssb091-b.shadebirdair.com ([10.10.1.147]) by ssbntbne2.shadebirdair.com with Microsoft SMTPSVC(5.0.2195.5329);
	 Wed, 15 Oct 2003 07:32:11 +1000
Message-Id: <5.2.1.1.0.20031015072038.00bccf68@ssbntbne2.shadebirdair.com>
X-Sender: MarissaS@ssbntbne2.shadebirdair.com
X-Mailer: QUALCOMM Windows Eudora Version 5.2.1
Date: Wed, 15 Oct 2003 07:32:11 +1000
To: "Apache Torque Users List" <torque-user@db.apache.org>
From: Marissa Smith <marissas@shadebirdair.com>
Subject: Re: two foreign keys
In-Reply-To: <20031014190357.82548.qmail@web12406.mail.yahoo.com>
Mime-Version: 1.0
Content-Type: multipart/alternative;
	boundary="=====================_168915609==.ALT"
X-OriginalArrivalTime: 14 Oct 2003 21:32:11.0231 (UTC) FILETIME=[A086BEF0:01C3929A]
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N
X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N

--=====================_168915609==.ALT
Content-Type: text/plain; charset="iso-8859-1"; format=flowed
Content-Transfer-Encoding: quoted-printable

Tulsi,

Check to see if Torque is generating the following methods in the=20
Agenciamiento class:

Usuario getUsuarioRelatedByUsuarioOrigen()

and

Usuario getUsuarioRelatedByUsuarioDestino()


I have similar table relationships in some of my tables and torque produces=
=20
these "RelatedBy" methods for them.
I am using Torque 3.1-alpha

Hope this helps!

Regards,

Marissa Smith.



At 04:03 PM 10/14/2003 -0300, you wrote:
>Hello, I need a table with two foreign keys to the same table, i.e:
>
><table name=3D"usuario">
>  <column name=3D"usuario_id" primaryKey=3D"true" required=3D"true"
>type=3D"INTEGER"/>
>  ...
></table>
>
>now I have another table that has TWO foreign keys to this "usuario"
>table, like this:
>
><table name=3D"agenciamiento">
>  <column name=3D"agenciamiento_id" primaryKey=3D"true" required=3D"true"
>type=3D"INTEGER"/>
>  <column name=3D"usuario_origen" required=3D"true" type=3D"INTEGER"/>
>  <column name=3D"usuario_destino" required=3D"true" type=3D"INTEGER"/>
>  ...
><foreign-key foreignTable=3D"usuario">
>  <reference foreign=3D"usuario_id" local=3D"usuario_origen"/>
></foreign-key>
><foreign-key foreignTable=3D"usuario">
>  <reference foreign=3D"usuario_id" local=3D"usuario_origen"/>
></foreign-key>
></table>
>
>
>It generates the classes ok, but the Agenciamiento class should have:
>
>Usuario getUsuarioDestino()
>Usuario getUsuarioOrigen()
>
>as expected
>
>instead, I got:
>
>int getUsuarioDestino()
>int getUsuarioOrigen()
>
>any ideas why it doesn=B4t work?
>
>thank you very much
>
>Tulsi
>
>
>------------
>Internet GRATIS es Yahoo! Conexi=F3n
>4004-1010 desde Buenos Aires. Usuario: yahoo; contrase=F1a: yahoo
>M=E1s ciudades: http://conexion.yahoo.com.ar
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>For additional commands, e-mail: torque-user-help@db.apache.org

--=====================_168915609==.ALT--