Default values

[Edward Kenworthy]

I setup my database to insert some default values for rows.

However (and I think this is correct behaviour) if the value is null in my object then it get's written as a null to the database and not the default.

Is there anyway in my object I can tag a property to be "not defined" so the default gets inserted? Generally this would be for "not null" columns so a solution that said "treat nulls as undefined and insert the default" would work.

Edward

[robh]

What data access API are you using (Hibernate, JDBC, JDO etc.)?

Rob

[Edward Kenworthy]

What data access API are you using (Hibernate, JDBC, JDO etc.)?

Rob

Hibernate.

[robh]

Edward,

Sorry to say, but I am not sure how you would go about doing that in Hibernate. I can find no reference to it whatsoever in the manual. I'm sure you are aware already, but Hibernate has a damn good forum - I suggest that you post this query there.

Regards,

Rob

[irbouho]

Hibernate does not support default values, you should either manager this using database triggers or assign default values in your domain.
how can I set default value of one column in x.hbm.xml file?

[Edward Kenworthy]

OK thanks very much both of you.