Return-Path: 
 <torque-user-return-7834-apmail-db-torque-user-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-torque-user-archive@www.apache.org
Received: (qmail 8016 invoked from network); 13 Mar 2008 12:50:54 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 13 Mar 2008 12:50:54 -0000
Received: (qmail 4324 invoked by uid 500); 13 Mar 2008 12:50:51 -0000
Delivered-To: apmail-db-torque-user-archive@db.apache.org
Received: (qmail 4075 invoked by uid 500); 13 Mar 2008 12:50:51 -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 4061 invoked by uid 99); 13 Mar 2008 12:50:51 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 13 Mar 2008 05:50:51 -0700
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: local policy)
Received: from [68.142.206.32] (HELO web32802.mail.mud.yahoo.com)
 (68.142.206.32)
    by apache.org (qpsmtpd/0.29) with SMTP; Thu, 13 Mar 2008 12:50:13 +0000
Received: (qmail 4103 invoked by uid 60001); 13 Mar 2008 12:50:21 -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=FsUdmSZcLNi6v/SCnC2Or30P3d0quIrsKnq/GS2n3BSNve5lEesKX3mUlaQUbFCOGcypXGZR+mqaDPtPH9VmsiOfRPSBbemRKVHl2bPxWwqel3cmYRLaGO0uh9zlqHUpU9b50H1/eyo+b+KfV79nVVRxUWcS5OraRjuTulS5h0A=;
X-YMail-OSG: 
 5X1B8SgVM1n6Aodr09wz30tKt4ppI4Pfwhu_YMr4Spn2NTllypYLoeQ8xbd0PZPChg--
Received: from [164.44.67.4] by web32802.mail.mud.yahoo.com via HTTP;
 Thu, 13 Mar 2008 05:50:21 PDT
Date: Thu, 13 Mar 2008 05:50:21 -0700 (PDT)
From: Jim <smoothie_jc@yahoo.com>
Subject: RE: Duplicate references in the foreign-key
To: Apache Torque Users List <torque-user@db.apache.org>
In-Reply-To: 
 <OFB6061B5C.5D49B5D0-ONC125740B.004354DC-C125740B.00438AC0@seitenbau.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Message-ID: <562600.2796.qm@web32802.mail.mud.yahoo.com>
X-Virus-Checked: Checked by ClamAV on apache.org

Thanks Thomas,

It's odd but the following code is also being
generated with a default value that does not exist.
(CURRENT DATE). I'm guessing that has something to do
with the way the column is setup in DB2. 
Thanks!
Jim
        <column default="CURRENT DATE"
name="POL_EFF_D" required="true" type="DATE"/>
        <column default="CURRENT DATE"
name="POL_EXP_D" required="true" type="DATE"/>







--- Thomas Fischer <fischer@seitenbau.net> wrote:

> If Martin's advice does not work out, it could also
> be a different jdbc
> driver. Torque uses only information that the jdbc
> driver gives; it does
> not do any post-processing.
> 
>     Thomas
> 
> Jim <smoothie_jc@yahoo.com> schrieb am 13.03.2008
> 11:30:34:
> 
> > Thomas,
> >
> > The standard process except we are still using Ant
> to
> > generate the schema file using the ant command ant
> -f
> > build-torque.xml jdbc.
> > That's it. The file generated has the dup
> references.
> > The source is mainframe DB2.
> > We have not changed anything rcently except moving
> to
> > the 3.2 rc2 version of Torque when it became
> > available. But that is not the issue.
> >
> > I suspect something is different on the DB2 side
> but
> > the dba's say no. And that's probably where the
> issue
> > is and I'm hoping someone ran into the same issue
> and
> > can give me a clue as to what I can look for to
> find
> > the issue.
> >
> > Jim
> >
> >
> > --- Thomas Fischer <fischer@seitenbau.net> wrote:
> >
> > > Could you please give a short description of
> what
> > > you do ? I don't have a
> > > clue.
> > >
> > >     Thomas
> > >
> > > Jim <smoothie_jc@yahoo.com> schrieb am
> 06.03.2008
> > > 19:22:32:
> > >
> > > > 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
> > >
> > >
> > >
> >
>
---------------------------------------------------------------------
> > > To unsubscribe, e-mail:
> > > torque-user-unsubscribe@db.apache.org
> > > For additional commands, e-mail:
> > > torque-user-help@db.apache.org
> > >
> > >
> >
> >
> >
> >
> >
>
____________________________________________________________________________________
> 
> > 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
> >
> 
> 
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail:
> torque-user-help@db.apache.org
> 
> 



      ____________________________________________________________________________________
Never miss a thing.  Make Yahoo your home page. 
http://www.yahoo.com/r/hs

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