I have a class with int property. when I allow the property to be left null, it has problem loading from the database.

How are you suppose to make sure the column value defaults to 0? (I thought the java class should have done that already). there does not seem to be a default-value attribute to set in the hbm. Do you simply make

int instancevariable = 0;

explicit in the Java class?

You can do it in your own DBMS, when you define the table. If you already have a table you can modify the settings.

of course you can do anything you want to going directly to the database. is it definitive that there is nothing in hibernate which addresses this?

A Long property can have a defailt value like this:

Regards,
Jitendra

I have an int type, and in the hbm file
<property name="doctype" >
<column name="DOCTYPE" default="1" />
</property>

but, the default value is still NULL in the data schema.

See anything wrong?

which version of hibernate are you using ?

This is the behaviour of latest hibernate + annotations:

private Integer value;

generates a nullable column

private int value

generates a column with not null constraint

Seems like you want to store ints not nullable Integers. In case of hbm files (instead of annotations) there is a chance you will have to not-null="true" attribute to column definition.

Please rate if that helped.

Well on looking deeper it appears that default is only honored in case of bulk insert.

so here you would have to set the default value in your code while declaring the property. It seems to work in my test case.

*Please do rate if it helps*

Regards,
Jitendra

I am using hibernate 3.2.

there may be a little misunderstanding in my exact situation.

actually I am talking about a object reference not a simple property. Because I use int values for id's, hibernate creates a int(11) data type, which defaults to NULL. So, it is neither Integer nor int in the java class.

How would either of you handle such a case?

aaooww......

This is no case to handle as such :-). It basically depends on your design if you would like it to be null or not. In case you don't want it to be null the you set it to not-null else allow null.

In any case ids should not have a default value. SHOULD NOT.

Regards,
Jitendra