How does the "default" column attribute work in Hibernate 3.1? I have set the default column value and hbm2dll shows the column default, but when I persist the object the default value is not saved.
Here is the mapping document:

<class entity-name="TestPerson" table="TEST_PERSON"
name="com.sitepen.jsonpersistence.test.TestPerson">
<id name="Id" column="testPersonId">
<generator class="native"/>
</id>
<dynamic-component name="Members">
<property name="firstName" type="string"/>
<property name="lastName" type="string"/>
<property name="testProperty" type="string">
<column name="testProperty" default="'default string'" not-null="true"/>
</property>
</dynamic-component>
</class>

Here is the output from hbm2dll (for HSQLDialect):

create table TEST_PERSON (
testPersonId bigint generated by default as identity (start with 1),
firstName varchar(255),
lastName varchar(255),
testProperty varchar(255) default 'default string' not null,
primary key (testPersonId)
);

But this blows up with a null value in the not-null column instead of inserting the default. Why is that?

You forgot the part:

By SQL standard a column having a default value defined will have that default value take effect as long as the column is not referenced in the insert statement...

Thanks - Not sure I understand. The defintion of the "insert" attribute sounds like it is for derived columns that you NEVER want to insert. The usual SQL use of DEFAULT is allow inserts to that column and only use the default if the column value is not set in the insert. I'll test it.

Then you want the dynamic-insert attribute of the <class/> mapping (which has performance implications). See http://www.hibernate.org/hib_docs/v3/reference/en/html/mapping.html#mapping-declaration-class

Hi,

My question is: why this is not working on hibernate 3.0.5 ?

I was using:

<class name="Name" table="Table" dynamic-insert="true">

<property name="defaultProperty" type="java.lang.String">
<column name="defaultProperty" default="'default string'"/>
</property>

Thanks in advance.