Return-Path: 
 <ddlutils-user-return-560-apmail-db-ddlutils-user-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-ddlutils-user-archive@www.apache.org
Received: (qmail 45039 invoked from network); 9 Jan 2007 10:05:22 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 9 Jan 2007 10:05:22 -0000
Received: (qmail 52743 invoked by uid 500); 9 Jan 2007 10:05:28 -0000
Delivered-To: apmail-db-ddlutils-user-archive@db.apache.org
Received: (qmail 52724 invoked by uid 500); 9 Jan 2007 10:05:28 -0000
Mailing-List: contact ddlutils-user-help@db.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:ddlutils-user-help@db.apache.org>
List-Unsubscribe: <mailto:ddlutils-user-unsubscribe@db.apache.org>
List-Post: <mailto:ddlutils-user@db.apache.org>
List-Id: <ddlutils-user.db.apache.org>
Reply-To: ddlutils-user@db.apache.org
Delivered-To: mailing list ddlutils-user@db.apache.org
Received: (qmail 52713 invoked by uid 99); 9 Jan 2007 10:05:28 -0000
Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 09 Jan 2007 02:05:28 -0800
X-ASF-Spam-Status: No, hits=2.8 required=10.0
	tests=DNS_FROM_RFC_ABUSE,DNS_FROM_RFC_POST,DNS_FROM_RFC_WHOIS
X-Spam-Check-By: apache.org
Received-SPF: pass (herse.apache.org: local policy)
Received: from [66.163.178.151] (HELO web34402.mail.mud.yahoo.com)
 (66.163.178.151)
    by apache.org (qpsmtpd/0.29) with SMTP; Tue, 09 Jan 2007 02:05:18 -0800
Received: (qmail 69631 invoked by uid 60001); 9 Jan 2007 10:04:57 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding;
  b=CH1huEH3nGcYMWFJJRiOVyRXHahtSOSrJD2Qk1qCBNbhZ2WlF5y/4yP8mJcGtTbqPX+V7JvFT6HT/RwRdeqhJ4Y3R8TWOWWxIItdfCV/bioWnRamDwB7V2Vortl1HNANXb0jWbQm2YVc5tU/oHDyeHOxXgluqboI5vDm+lJOl1g=
  ;
Message-ID: <20070109100457.69629.qmail@web34402.mail.mud.yahoo.com>
Received: from [86.202.102.160] by web34402.mail.mud.yahoo.com via HTTP;
 Tue, 09 Jan 2007 02:04:57 PST
Date: Tue, 9 Jan 2007 02:04:57 -0800 (PST)
From: Laurent ROCHE <laurent_roche@yahoo.com>
Subject: Re : FK troubles Identity
To: ddlutils-user@db.apache.org
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
X-Virus-Checked: Checked by ClamAV on apache.org

Hi,=0A=0AIt is still not working properly i.e. not using ID from the data.=
=0AHere is the related extract of my bouild.xml file:=0A<target name=3D"imp=
ort-derby" description=3D"Creates db and Loads data">=0A      <taskdef name=
=3D"ddlToDatabase"=0A              classname=3D"org.apache.ddlutils.task.Dd=
lToDatabaseTask">=0A         <classpath refid=3D"classpath"/>=0A      </tas=
kdef>=0A=0A      <ddlToDatabase schemaFile=3D"schema-pg.xml" sortforeignkey=
s=3D"false" verbosity=3D"DEBUG" shutdowndatabase=3D"true" >=0A=0A         <=
database url=3D"jdbc:derby:pip_dev"=0A                 driverClassName=3D"o=
rg.apache.derby.jdbc.EmbeddedDriver"=0A                 username=3D""=0A   =
              password=3D""/>=0A=0A         <createDatabase failonerror=3D"=
true"/>=0A         <writeSchemaToDatabase/>=0A        <writeDataToDatabase =
datafile=3D"data.xml" failonerror=3D"true" ensureforeignkeyorder=3D"true" u=
seexplicitidentityvalues =3D"true"/>=0A=0A      </ddlToDatabase>=0A=0A</tar=
get> =0A=0A=0AWhat do I do wrong ?=0A=0A =0AHave fun,=0AL@u=0AThe Computing=
 Froggy=0A=0A----- Message d'origine ----=0ADe : Thomas Dudziak <tomdzk@gma=
il.com>=0A=C0 : ddlutils-user@db.apache.org=0AEnvoy=E9 le : Mardi, 9 Janvie=
r 2007, 6h33mn 01s=0AObjet : Re: FK troubles [Was: Not much info with: "Cou=
ld not parse or write data file"] aka "The Saga continues II "=0A=0AOn 1/8/=
07, Laurent ROCHE <laurent_roche@yahoo.com> wrote:=0A=0A=0A> PB2 : do not i=
nsert generated IDs for IDENTITY=0A> I have some tables with GENERATED BY D=
EFAULT AS IDENTITY for the Primary Key (most of my tables refered by FK).=
=0A> I would then expect to get the PK from the given value and not a gener=
ated value. This is not the case hence the rows from other tables referenci=
ng the PK on the first table will not insert as the values are identical.=
=0A=0AThis should work fine. It is controlled via the=0AuseExplicitIdentity=
Values parameter=0A(http://db.apache.org/ddlutils/ant/org.apache.ddlutils.t=
ask.WriteDataToDatabaseCommand.html#parameter-useexplicitidentityvalues)=0A=
whose default value is false (i.e. use the value defined by the=0Adatabase =
(identity column) not the one in the data xml file).=0A=0A=0A=0ATom=0A=0A=
=0A=0A=0A__________________________________________________=0ADo You Yahoo!=
?=0AEn finir avec le spam? Yahoo! Mail vous offre la meilleure protection p=
ossible contre les messages non sollicit=E9s =0Ahttp://mail.yahoo.fr Yahoo!=
 Mail