Return-Path: 
 <ddlutils-user-return-563-apmail-db-ddlutils-user-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-ddlutils-user-archive@www.apache.org
Received: (qmail 13954 invoked from network); 10 Jan 2007 23:06:14 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 10 Jan 2007 23:06:14 -0000
Received: (qmail 39181 invoked by uid 500); 10 Jan 2007 23:06:20 -0000
Delivered-To: apmail-db-ddlutils-user-archive@db.apache.org
Received: (qmail 39068 invoked by uid 500); 10 Jan 2007 23:06:20 -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 39046 invoked by uid 99); 10 Jan 2007 23:06:19 -0000
Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 10 Jan 2007 15:06:19 -0800
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (herse.apache.org: domain of philip.donaghy@gmail.com
 designates 64.233.184.238 as permitted sender)
Received: from [64.233.184.238] (HELO wr-out-0506.google.com) (64.233.184.238)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 10 Jan 2007 15:06:10 -0800
Received: by wr-out-0506.google.com with SMTP id i22so189703wra
        for <ddlutils-user@db.apache.org>;
 Wed, 10 Jan 2007 15:05:49 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=I7qWcuMu66bRG235iXB/4Abe4Z8y0+cLJ2BFK8z6NhNbwS3iZzSJ4YJQmZFHlhXaR4dC9W3k2/EEWaap+7wd362dqB+cg9jIXW05b5TNNE4pmPtEOJcxdcV7m8w0nCBoSHqlifhYiF9HHz7yKPJo+jgXWDHWr2emUKbkjlSGGN4=
Received: by 10.78.185.7 with SMTP id i7mr282701huf.1168470349144;
        Wed, 10 Jan 2007 15:05:49 -0800 (PST)
Received: by 10.78.131.12 with HTTP; Wed, 10 Jan 2007 15:05:49 -0800 (PST)
Message-ID: <e275257f0701101505r2ccab28ew455e076d385127da@mail.gmail.com>
Date: Thu, 11 Jan 2007 00:05:49 +0100
From: "Philip Mark Donaghy" <philip.donaghy@gmail.com>
To: ddlutils-user@db.apache.org
Subject: Re: Could not read data file data.xml
In-Reply-To: <224f32340701051526o674aea26ued6a4d6e9367bc98@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <e275257f0701050556qa95650ek4b0230d8b24cb41@mail.gmail.com>
	 <224f32340701051526o674aea26ued6a4d6e9367bc98@mail.gmail.com>
X-Virus-Checked: Checked by ClamAV on apache.org

Hi Tom, per your request for further details...

On 1/6/07, Thomas Dudziak <tomdzk@gmail.com> wrote:
> On 1/5/07, Philip Mark Donaghy <philip.donaghy@gmail.com> wrote:
> > I get this error often and I would like to report my findings. This
> > happens when a data element contains a reference to a foreign key not
> > present in the document.
>
> This is because by default, the ensureForeignKeyOrder parameter for
> the writeDataToDatabase subtask is set to true. This will cause
> DdlUtils to defer the insertion of rows until all rows that this row
> references, are already written to the database.
> If you update DdlUtils and set the new verbosity flag to debug, then
> DdlUtils will write out which rows are held back and why.

Cool I'll check this out.

>
> > Aside from this I experienced a problem where I have a table with many
> > foreign keys none of which are required. When I dump the data using
> > ddlutils I get an element that looks like this.
> >
> > <DOCUMENTS ID="1998858" LABEL="Google Earth image of site.jpg"
> > FILE_NAME="Google Earth image of site.jpg" CUSTOMER_PROPOSAL_FK="0"
> > EQUIPMENT_FK="0" CIRCUIT_PROVIDER_FK="0" CUSTOMER_FK="2031623"
> > LOCATION_FK="0" CIRCUIT_FK="0"/>
> >
> > I havn't investigated too much but those foreign keys with a value of
> > "0" are actually null and should not appear.
>
> Could you post more info (which db, the relevant schema, etc.) ?
> DdlUtils in general does not modify the data so this might be
> something that the JDBC driver returns.
>

The database is Derby 10.1.2.1 and I'm using the Client driver. Derby
is running the NetworkServer framework on a single machine with Java
1.5.0_06

The relevant part of the schema is,

    <table name="DOCUMENTS">
      <column name="ID" primaryKey="true" required="true"
type="BIGINT" size="19" autoIncrement="false"/>
      <column name="LABEL" primaryKey="false" required="true"
type="VARCHAR" size="256" autoIncrement="false"/>
      <column name="FILE_NAME" primaryKey="false" required="false"
type="VARCHAR" size="256" autoIncrement="false"/>
      <column name="REMARKS" primaryKey="false" required="false"
type="VARCHAR" size="4096" autoIncrement="false"/>
      <column name="CUSTOMER_PROPOSAL_FK" primaryKey="false"
required="false" type="BIGINT" size="19" autoIncrement="false"/>
      <column name="EQUIPMENT_FK" primaryKey="false" required="false"
type="BIGINT" size="19" autoIncrement="false"/>
      <column name="CIRCUIT_PROVIDER_FK" primaryKey="false"
required="false" type="BIGINT" size="19" autoIncrement="false"/>
      <column name="CUSTOMER_FK" primaryKey="false" required="false"
type="BIGINT" size="19" autoIncrement="false"/>
      <column name="LOCATION_FK" primaryKey="false" required="false"
type="BIGINT" size="19" autoIncrement="false"/>
      <column name="CIRCUIT_FK" primaryKey="false" required="false"
type="BIGINT" size="19" autoIncrement="false"/>
      <foreign-key foreignTable="CIRCUIT" name="DOCUMENTS_CIRCUIT_FKC">
        <reference local="CIRCUIT_FK" foreign="ID"/>
      </foreign-key>
      <foreign-key foreignTable="CIRCUIT_PROVIDER"
name="DOCUMENTS_CIRCUIT_PROVIDER_FKC">
        <reference local="CIRCUIT_PROVIDER_FK" foreign="ID"/>
      </foreign-key>
      <foreign-key foreignTable="CUSTOMER" name="DOCUMENTS_CUSTOMER_FKC">
        <reference local="CUSTOMER_FK" foreign="ID"/>
      </foreign-key>
      <foreign-key foreignTable="CUSTOMER_PROPOSAL"
name="DOCUMENTS_CUSTOMER_PROPOSAL_FC">
        <reference local="CUSTOMER_PROPOSAL_FK" foreign="ID"/>
      </foreign-key>
      <foreign-key foreignTable="EQUIPMENT" name="DOCUMENTS_EQUIPMENT_FKC">
        <reference local="EQUIPMENT_FK" foreign="ID"/>
      </foreign-key>
      <foreign-key foreignTable="LOCATION" name="DOCUMENTS_LOCATION_FKC">
        <reference local="LOCATION_FK" foreign="ID"/>
      </foreign-key>
    </table>

I haven't checked if my framework is setting these columns to 0. I
shouldn't exclude the possiblility.

I would also like to move from Hibernate to OJB. Is there any quick
way to get started with OJB from ddltutils?

Thanks for your time,

Phil
> Tom
>


-- 
Philip Donaghy
donaghy.blogspot.com del.icio.us/donaghy/philip
Skype: philipmarkdonaghy
Office: +33 5 56 60 88 02
Mobile: +33 6 20 83 22 62