Mailing-List: contact ddlutils-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: ddlutils-user@db.apache.org
Received-SPF: pass (herse.apache.org: domain of tomdzk@gmail.com designates
 66.249.92.172 as permitted sender)
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=WjQdh3b4djgn0bQt2c5Lo3+XeZ5kxOfaF71gOxcF0JYsWNPVBHG0/FEQhbQUHF5KXpzICikiHGEM/ZRoIEqSjlbigTvvfIkeHSi6Zoppd1tTT3bO83IYhGFhkyu+OAqks1oZ85rJbohKQAxE/ZenBClUNPMyD4Y4CSzLNwoHNfo=
Message-ID: <224f32340612132115o55b4c0e0gb946fba7ba9a581@mail.gmail.com>
Date: Wed, 13 Dec 2006 21:15:19 -0800
From: "Thomas Dudziak" <tomdzk@gmail.com>
To: ddlutils-user@db.apache.org
Subject: Re: Booleans and converter(Subelement)
In-Reply-To: <20061213184850.75629.qmail@web34410.mail.mud.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <20061213184850.75629.qmail@web34410.mail.mud.yahoo.com>

On 12/13/06, Laurent ROCHE <laurent_roche@yahoo.com> wrote:

> I am moving a PostgreSQL db into a Derby db, using the Ant tasks.
>
> As I have boolean columns in my PG db (and that there's none in Derby) I have done a search and replace in the generated schema.xml file (from PG), to replace all BOOLEAN by SMALLINT.
> That works fine but reading the doc I realise there's a converter subelement to go from one type to another.
>
> But that's for data. Is there something equivalent for the schema ?
> Or does that do the transformation on the schema too ?

DdlUtils will take care of that, simply leave the schema as it is.
DdlUtils will use the most appropriate native type that the database
has to offer.

Tom