Is it possible to generate a default value for a certain database column using hbm2ddl

Question

Env: JPA 1, Hibernate 3.3.x, MySQL 5.x

We auto generate database schema using hbm2ddl export operation. Would it be possible to generate a default value for a certain @Entity member during SQL generation. (e.g. archive field in mytable entity class.

create table mytable (
...
'archive‘ tinyint(1) default ’0 ’,
...
)

@donroby - thanks for the link, adding the default value in columnDefinition is not portable and hence wouldn't want to use that mechanism. Alternatively I could use a default value in the Entity model. Is there a different way to specify this? — Sam
– Sam, Commented Jul 11, 2010 at 16:16
I don't think there's a portable way to specify a default in the mapping. It might be best to set a default value either in the field declaration or in your constructor. — Don Roby
– Don Roby, Commented Jul 11, 2010 at 17:23

Pascal Thivent · Accepted Answer · 2010-07-11 22:42:06Z

2

There is no portable way to do that and the columnDefinition "trick" is definitely not a good solution. Actually, setting defaults in the generated DDL is just not a good idea, this would require the provider to go back to the database to see the result after an insert¹. Better default in your Java code.

¹ Just in case, note that you can tell Hibernate to do that using the @Generated annotation.

edited Jul 11, 2010 at 22:42

answered Jul 11, 2010 at 22:06

Pascal Thivent

572k140 gold badges1.1k silver badges1.1k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Is it possible to generate a default value for a certain database column using hbm2ddl

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related