Hi,

I have searched a way to make schema export tool generating this kind of sql command : create table foo (bar integer unique not null
default nextval('foo_bar_seq'), xx VARCHAR(255)); using this declaration :
<class name="foo">
<id name="bar" column="bar" unsaved-value="null">
<generator class="sequence">
<param name="sequence">foo_bar_seq</param>
</generator>
</id>
<property name="xx"/>
</class>

Actually, it doesn't generate the default value.

Thanks.

Ludo.

sequence generator reads its next value directly from the sequence, so there is no need to declare such a default. You actually can't have hbm2ddl create that.

[quote="michael"]... so there is no need to declare such a default. You actually can't have hbm2ddl create that.[/quote]

Yes there is no need for hibernate, but for other purpose it could.

Thanks.

Ludo.

Sorry there is also no other need. A Sequence is a sequence so there is no need at all to set a default value to a "SERIAL" column because it always has as default value the next number it get from the sequence table. At a look at them and it will point out why there is no need for that.

regards

Olaf