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:[EMAIL PROTECTED] Sendt: 14. mars 2007 18:01 Til: [email protected] Emne: Re: DdlUtils insists on altering unchanged columns when using MySql On 3/14/07, Nils Tesdal <[EMAIL PROTECTED]> 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
