Since no answer from the forums, I'm working at the code in the
SQLBuilder, where i'm trying to modify the approach to handle
ColumnRequiredChange. I'm handling this as a DML change by using
"generateUpdateSQL()" against the column with new default value,updating the
table and applying columnRequiredChange. Hopefully there is a better
solution than this. BTW faced this problem on MSSQL n Oracle.satz wrote: > > :) logically yes....But Even if theres a default value specified, the Code > doesn't apply the same as it categorises this change to be different from > ColumnRequiredChange and handles it differntly. Atlease it doesnt force > the DefaultValueChange to be applied beforehand.. so still lookin for an > answer!!! :( > > > Jun Li-2 wrote: >> >> I think you have to define the default value in that case. Otherwise, you >> will lost your data. >> >> On 10/4/07, callme_sanjay <[EMAIL PROTECTED]> wrote: >>> >>> >>> Hello Team, >>> >>> when the table already has data how is the utility taking >>> care of updating existing columns from NULL to NOT NULL... >>> >>> Please reply >>> On Behalf of Satyam B. >>> >>> -- >>> View this message in context: >>> http://www.nabble.com/DDL-Utils...-tf4566113.html#a13033491 >>> Sent from the Apache DdlUtils - User mailing list archive at Nabble.com. >>> >>> >> >> >> -- >> ------------ >> Cheers, >> Jun >> >> > > -- View this message in context: http://www.nabble.com/DDL-Utils...-tf4566113.html#a13090805 Sent from the Apache DdlUtils - User mailing list archive at Nabble.com.
