i can set a property to not-null="true" which faithfully generates



has anyone tried to set the default value so the generated ddl would look like



(i know this can be enforced while persisting the object but i need this for pre-existing data and data migration)

thanks
ravi

ps. i'm using xdoclet

You might want to consider doing this in the JavaBean instead. Specifically, initialize the property member with a default value when it is declared and/or set a reasonable default value in the setter method whenever "null" is passed in.

By enforcing this at the bean level, your code is more portable. The behavior will be the same even if you switch from Hibernate to something else in the future.

or even in a constructor...

the java side solution would probably work in most cases but for maintenance purposes you would want the mapping to be exactly same as what's in the database. here's a scenario:

i create a persistent object let's say with one field


over time i would have a table with data populate for field1.

if i change it now to have a new field, here's the migration issue



the update will issue an "alter table" to add the new column intField.

this will cause all the existing records to have the value NULL. the next time you load one of these record it's boom time (unless of course we pre populate the atribute)

i came up with the following solution.

i changed SchemaUpdate and Table classes to generate the DEFAULT keyword. i yet have to integrate with XDoclet so that you could possibly do something like this: