db-ddlutils-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Nils Tesdal" <nils.tes...@kantega.no>
Subject SV: DdlUtils insists on altering unchanged columns when using MySql
Date Thu, 15 Mar 2007 08:56:26 GMT
I am not quite sure what you mean by platform but I have used versions
5.0.22 and 5.0.27 of the server and versions 3.1.13 and 5.0.5 of the
connector, all with the same result.

Nils

-----Opprinnelig melding-----
Fra: Thomas Dudziak [mailto:tomdzk@gmail.com] 
Sendt: 14. mars 2007 18:01
Til: ddlutils-user@db.apache.org
Emne: Re: DdlUtils insists on altering unchanged columns when using
MySql

On 3/14/07, Nils Tesdal <nils.tesdal@kantega.no> wrote:

> I am writing program that uses DdlUtils to create and access a
database.
> With Derby it works ok, but when I switched to MySql I got a problem.
> When I ask for the alterTablesSql, DdlUtils insists on altering
columns
> that are defined as 'required' without a default value. This seems to
be
> caused by MySql interpreting 'no default value' differently from
> DdlUtils. The default value in the model read from the database
contains
> an empty string, while the default value in the model read from the
xml
> file has a null-value.
>
> An example column definition:
>
> <column name="DOMAIN"
>     type="VARCHAR"
>     size="64"
>     primaryKey="true"
>     required="true"/>
>
> I have temporarily fixed the problem by inserting the following code
in
> the postprocessModelFromDatabase method on line 1957 in
> PlatformImplBase.java:
>
> if(column.isRequired() && defaultValue != null &&
> defaultValue.equals("")) {
>     defaultValue = null;
>     column.setDefaultValue(defaultValue);
> }
>

What MySql version do you use ? And what version of the MySql platform ?

Tom

Mime
View raw message