Return-Path: 
 <torque-user-return-8028-apmail-db-torque-user-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-torque-user-archive@www.apache.org
Received: (qmail 78404 invoked from network); 19 Nov 2008 16:15:58 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 19 Nov 2008 16:15:58 -0000
Received: (qmail 4555 invoked by uid 500); 19 Nov 2008 16:16:06 -0000
Delivered-To: apmail-db-torque-user-archive@db.apache.org
Received: (qmail 4536 invoked by uid 500); 19 Nov 2008 16:16:06 -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-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 4525 invoked by uid 99); 19 Nov 2008 16:16:06 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 19 Nov 2008 08:16:06 -0800
X-ASF-Spam-Status: No, hits=2.2 required=10.0
	tests=HTML_MESSAGE,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: local policy)
Received: from [217.24.207.26] (HELO mail.seitenbau.net) (217.24.207.26)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 19 Nov 2008 16:14:44 +0000
Received: from [192.168.15.18] (helo=www.seitenbau.net)
	by router.seitenbau.net with esmtp (Exim 4.43)
	id 1L2piA-0001Qy-GZ
	for torque-user@db.apache.org; Wed, 19 Nov 2008 17:15:27 +0100
In-Reply-To: <ef7311160811190600jd3dbfaelf361f783f643d534@mail.gmail.com>
References: <ef7311160811190600jd3dbfaelf361f783f643d534@mail.gmail.com>
To: "Apache Torque Users List" <torque-user@db.apache.org>
MIME-Version: 1.0
Subject: RE: Foreign Key
X-KeepSent: 2BB40299:FFB92D12-C1257506:0058CC21;
 type=4; name=$KeepSent
X-Mailer: Lotus Notes Release 8.0.2 August 07, 2008
Message-ID: 
 <OF2BB40299.FFB92D12-ONC1257506.0058CC21-C1257506.00594E4B@seitenbau.net>
From: Thomas Fischer <fischer@seitenbau.net>
Date: Wed, 19 Nov 2008 17:15:26 +0100
X-MIMETrack: Serialize by Router on www/seitenbau(Release 8.0.1|February 07,
 2008) at
 19.11.2008 17:15:25,
	Serialize complete at 19.11.2008 17:15:25
Content-Type: multipart/alternative;
 boundary="=_alternative 00594E49C1257506_="
X-Spam-Score: -1.4 (-)
X-Spam-Report: -1.4 ALL_TRUSTED            Passed through trusted hosts only
 via SMTP
	 0.1 TW_RQ                  BODY: Odd Letter Triples with RQ
X-Virus-Checked: Checked by ClamAV on apache.org

--=_alternative 00594E49C1257506_=
Content-Type: text/plain; charset="US-ASCII"

>     <table name="novos_jogadores" javaName="NovoJogador">
>         <column name="id" javaName="id" primaryKey="true" 
required="true"
> type="INTEGER" />
>         <foreign-key foreignTable="jogadores" name="id">
>             <reference local="id" foreign="novo_jogador_id" />
>         </foreign-key>
>     </table>
> 
>     <table name="jogadores" javaName="Jogador">
>         <column name="id" javaName="id" primaryKey="true" 
required="true"
> type="INTEGER" />
>         <column name="novo_jogador_id" javaName="novoJogadorId"
> type="INTEGER" />
>         <foreign-key foreignTable="novos_jogadores" 
name="novo_jogador_id">
>             <reference local="novo_jogador_id" foreign="id" />
>         </foreign-key>
>     </table>
> 
> on the table 'novos_jogadores' i mapped 'id' as foreign key referencing 
a
> foreign key on 'jogadores', this forces the generator to build a
> NovoJogadorPeer.getJogador(NovoJogador x), is any problem with this kind 
of
> mapping with updates, deletions and insertions?

Looks strange to me. I usually model a 1:1 relation like a 1:n relation 
(of which the 1:1 relation is a special case)
Torqe treats this as a circular relationship rather than a 1:1 
relationship so things can happen that you'd not expect.

But if it works for you, nobody prevents you from modeling the 
relationship like you did.

  Thomas
--=_alternative 00594E49C1257506_=--