db-ddlutils-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Dudziak" <tom...@gmail.com>
Subject Re: DdlUtils insists on altering unchanged columns when using MySql
Date Wed, 14 Mar 2007 17:00:50 GMT
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