Return-Path: 
 <torque-user-return-7805-apmail-db-torque-user-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-torque-user-archive@www.apache.org
Received: (qmail 77118 invoked from network); 6 Mar 2008 18:23:10 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 6 Mar 2008 18:23:10 -0000
Received: (qmail 53610 invoked by uid 500); 6 Mar 2008 18:22:59 -0000
Delivered-To: apmail-db-torque-user-archive@db.apache.org
Received: (qmail 53588 invoked by uid 500); 6 Mar 2008 18:22:59 -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 53575 invoked by uid 99); 6 Mar 2008 18:22:59 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 06 Mar 2008 10:22:59 -0800
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: local policy)
Received: from [68.142.206.31] (HELO web32801.mail.mud.yahoo.com)
 (68.142.206.31)
    by apache.org (qpsmtpd/0.29) with SMTP; Thu, 06 Mar 2008 18:22:12 +0000
Received: (qmail 11677 invoked by uid 60001); 6 Mar 2008 18:22:32 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=X-YMail-OSG:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID;
  b=J+nECSSfaC8BQiN44OLIKOrgwYXc6SKqrEtxyxEtlOLL9I+5UBNBYLWaBnmNAMRX3ZtmlfbRQqsy8Z9drcwgjzk9CsQtHPOl5KM5uhRP8P2PF7eKP5cm3sAxgjQpkaQlZMf5RNTdLxaqTOzPHjXaSU/5sbVAV7GXd2sUv9Yj9Ds=;
X-YMail-OSG: 
 dPAi.FUVM1nD48YvYQlrZ64kOXS.AjQSO_RpCllPXIstgCIGspvROHPXD2uFpZpRcE.oZDn1zbWMUVdigzh8NjT_KMM5J0bEOuCfb2O80wfNpxvGs1o-
Received: from [164.44.67.4] by web32801.mail.mud.yahoo.com via HTTP;
 Thu, 06 Mar 2008 10:22:32 PST
Date: Thu, 6 Mar 2008 10:22:32 -0800 (PST)
From: Jim <smoothie_jc@yahoo.com>
Subject: Duplicate references in the foreign-key 
To: Apache Torque Users List <torque-user@db.apache.org>
In-Reply-To: <937C75B544E7E8428436C67056A3A17306019C02@NYWEXMB83.msad.ms.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Message-ID: <235811.10852.qm@web32801.mail.mud.yahoo.com>
X-Virus-Checked: Checked by ClamAV on apache.org

Hi,
I started running into a duplicate reference in the
foreign-key issue several months ago in the ant
generated schema.xml file. 
We are still using the 3.2 rc2 version of Torque and
the tables are DB2.

Here is an example of the dup reference..
<foreign-key foreignTable="TABLE2">
   <reference foreign="OFFRG_N" local="OFFRG_N"/>
   <reference foreign="OFFRG_N" local="OFFRG_N"/>
</foreign-key>

Here is a portion the table that has the forigh-key..
<table name="TABLE2">
        <column name="OFFRG_N" primaryKey="true"
required="true" size="12" type="CHAR"/>

The dba's swear there have been no changes to the DB2
tables. 

Thanks for any suggestions!
Jim


      ____________________________________________________________________________________
Be a better friend, newshound, and 
know-it-all with Yahoo! Mobile.  Try it now.  http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ 


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org