Hibernate version:
1.2.1.4000

Name and version of the database you are using:
Microsoft SQL Server 9.00.1406.00

I have two classes:



In my DDL the column for Date2 must be nullable, however in my class it's not a nullable type. Is there a way to do null value substitution for this?

Also, is there way to substitue null for any date less than sql servers min date of 1/1/1753?

Basically, we dont allow nulls in our objects and that seems to be causing some problems here. We use DateTime.MinValue or DateTime.MaxValue as the default value for date fields.

Hi Mike,

I suspect that you really want your database to reflect the business logic (if the business doesn't allow nulls, the database shouldn't).

However, you could have a completely protected (nullable) field for the mapping, then a public accessor for your business use:



Regards,
Richard

Excellent idea, sometimes the simple solutions escape us. I was looking for something a little more complex. Thanks.