Return-Path: 
 <torque-user-return-3214-apmail-db-torque-user-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-torque-user-archive@www.apache.org
Received: (qmail 5156 invoked from network); 14 Oct 2003 19:04:10 -0000
Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12)
  by minotaur-2.apache.org with SMTP; 14 Oct 2003 19:04:10 -0000
Received: (qmail 70339 invoked by uid 500); 14 Oct 2003 19:03:54 -0000
Delivered-To: apmail-db-torque-user-archive@db.apache.org
Received: (qmail 70283 invoked by uid 500); 14 Oct 2003 19:03:54 -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 70121 invoked from network); 14 Oct 2003 19:03:52 -0000
Received: from unknown (HELO web12406.mail.yahoo.com) (216.136.173.133)
  by daedalus.apache.org with SMTP; 14 Oct 2003 19:03:52 -0000
Message-ID: <20031014190357.82548.qmail@web12406.mail.yahoo.com>
Received: from [200.49.91.74] by web12406.mail.yahoo.com via HTTP;
 Tue, 14 Oct 2003 16:03:57 ART
Date: Tue, 14 Oct 2003 16:03:57 -0300 (ART)
From: =?iso-8859-1?q?Tulsi=20Das?= <quixote_arg@yahoo.com>
Subject: two foreign keys
To: torque-user <torque-user@db.apache.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
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

Hello, I need a table with two foreign keys to the same table, i.e:

<table name="usuario">
 <column name="usuario_id" primaryKey="true" required="true"
type="INTEGER"/>
 ...
</table>

now I have another table that has TWO foreign keys to this "usuario"
table, like this:

<table name="agenciamiento">
 <column name="agenciamiento_id" primaryKey="true" required="true"
type="INTEGER"/>
 <column name="usuario_origen" required="true" type="INTEGER"/>
 <column name="usuario_destino" required="true" type="INTEGER"/>
 ...
<foreign-key foreignTable="usuario">
 <reference foreign="usuario_id" local="usuario_origen"/>
</foreign-key>
<foreign-key foreignTable="usuario">
 <reference foreign="usuario_id" local="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�t work?

thank you very much

Tulsi


------------
Internet GRATIS es Yahoo! Conexi�n
4004-1010 desde Buenos Aires. Usuario: yahoo; contrase�a: yahoo
M�s 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