Null value single row functions

dmilks · **Posted:** Tue Mar 30, 2004 4:37 pm

Oracle has an NVL function to convert a null field to whatever you want. In the Hibernate Mapping XML file, is there a way to do the same sort of thing?

How would I specify that I wanted the bean value to be populated with 0 if the column field was null, based on the following definition?

<property column="QTY_BO" length="8" name="qtyBo" not-null="false" type="long"/>

Can I do it in the XML file, or does it have to be done in the SQL?

Thanks

drj · **Posted:** Wed Mar 31, 2004 1:06 am

The question is: when you retrieve a null value from an object and it is converted to a non-null value (in your case null --> 0), do you want this to be persisted in the database?

i.e.
1) db value of x.qtyBo = null
2) load x (value is 0)
3) x.qtoBo saved as 0

If you don't then I would say put this is the method accessor, but don't modify the actual property i.e.

Code:

getQtyBo() {
   if (qtyBo == null) return 0;
   return qtyBo;
}