Hibernate version: 3.x

Name and version of the database you are using: Oracle 9i

I have a non-id property value stored in my Java object as int. I want to instruct Hibernate to insert null into the mapped database column when the value of the property is 0. Is there an easy way?

Thanks much,
Ted

Hi
u can probably define in the .hbm.xml file the property not-null ="false"
for ex.
<property name="rawLocation" length="128" not-null="false"/>
and then manage the insersion from the java code by not entering anything when the value is zero.
is this help u.

Dont forget to rate it.

Try to define the property with type="integer" and don't set this property when the value is 0.

I'm sorry, maybe I wasn't clear. Since the property is stored as an int, it is 0 by default. I want to continue to store the value as an int, but I want Hibernate to recognize that the value of 0 means that the property hasn't been set (to a non 0 value). Thanks.

use a usertype. there are lots of examples on the hibernate website.

Yes, thank you, I know I could use a User Type. I just wondered if there was an easier way. It seems like it would be a common enough occurrence that there would be a 'null-for-zero' attribute that I was missing.

not that i'm aware of, but i could be wrong. usertypes are simple enough anyway... maybe there's already a 0 -> null one on the wiki. if not, you should post yours.