Return-Path: 
 <ddlutils-user-return-140-apmail-db-ddlutils-user-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-ddlutils-user-archive@www.apache.org
Received: (qmail 62934 invoked from network); 7 Feb 2006 19:59:42 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 7 Feb 2006 19:59:42 -0000
Received: (qmail 78232 invoked by uid 500); 7 Feb 2006 19:59:40 -0000
Delivered-To: apmail-db-ddlutils-user-archive@db.apache.org
Received: (qmail 78206 invoked by uid 500); 7 Feb 2006 19:59:40 -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 78194 invoked by uid 99); 7 Feb 2006 19:59:40 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 07 Feb 2006 11:59:40 -0800
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: domain of tomdzk@gmail.com designates
 66.249.92.193 as permitted sender)
Received: from [66.249.92.193] (HELO uproxy.gmail.com) (66.249.92.193)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 07 Feb 2006 11:59:39 -0800
Received: by uproxy.gmail.com with SMTP id m3so69902ugc
        for <ddlutils-user@db.apache.org>;
 Tue, 07 Feb 2006 11:59:18 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=Hud1rcLKhdQgDLz+Zy4U2XSySVfEMG3Q6JrCfwWdLXZJrPTWnVSUAm5TIEfajKpnWQjvfZfdxM0ki0qG2nzrTokOMZgd5mbtMTsVxYSBdCPRRPfKPqtdG7FfLjpscv1AqeIX6wohgJP5bnX7jzEZttNnM8HgW4/U3JD955v0zHw=
Received: by 10.66.221.11 with SMTP id t11mr3061824ugg;
        Tue, 07 Feb 2006 11:59:17 -0800 (PST)
Received: by 10.67.30.2 with HTTP; Tue, 7 Feb 2006 11:59:17 -0800 (PST)
Message-ID: <224f32340602071159h3364865cq90f2f450d6cef078@mail.gmail.com>
Date: Tue, 7 Feb 2006 20:59:17 +0100
From: Thomas Dudziak <tomdzk@gmail.com>
To: ddlutils-user@db.apache.org
Subject: Re: DDL to Database task: no model name?
In-Reply-To: <43E8F6C8.10406@guydavis.ca>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <43E8B83D.6050907@guydavis.ca>
	 <224f32340602070810v34a35e04nf5df182c35afc652@mail.gmail.com>
	 <43E8E1C3.6090006@guydavis.ca>
	 <224f32340602071059m18844898ua5d0d6a0657d946a@mail.gmail.com>
	 <43E8F6C8.10406@guydavis.ca>
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

On 2/7/06, Guy Davis <davis@guydavis.ca> wrote:

> Sorry to be a pain, but I need more clarification.  I reverted my
> build.xml and now here is the top of my schema.xml file:
>
>   <!DOCTYPE database PUBLIC "//APACHE/DDLUITLS/"
> "http://db.apache.org/torque/dtd/database.dtd">
>    <database>

Yep, that should be fine, though you can probably simply use the
SYSTEM identifier:

<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database.dtd">

Btw, it is possible that you do not need this, but XML parsers
sometimes complain about its absence.

> Running my DdlToDatabaseTask gives me:
>
> BUILD FAILED
> C:\Development\trunk\build.xml:451: Could not read schema file
> C:\Development\trunk\schema.xml: The database model has no name

Well, DdlUtils requires you to specify the name attribute for the root
database element. Its not required in the DTD (yet), but that only
because Torque does not need it.

> Secondly, would it make sense for the writeSchemaToFile command
> to include this header automatically?  I trying for roundtrip movement
> of data and schema between development databases using DDLUtils.  As
> such, I need to automate all steps.

Nope, because for XML that includes it, this will lead to problems.

Tom