hibernate won't create table

Question

*I got the following in an entity.

@Entity("User") public class User implements java.io.Serializable { @ElementCollection(fetch=FetchType.EAGER) @CollectionTable(name="FrameworkUser_Properties") public Map<String, String> getProperties() { return properties; } public void setProperties(Map<String, String> properties) { this.properties = properties; } }

i get the following error

Unsuccessful: create table FrameworkUser_Properties (User_id int not null, properties varchar(255) null, properties_KEY varchar(255) null, primary key (User_id, properties_KEY))

Anyone got any idea how i should do so is properties_KEY is not null instead? I use Hibernate Hibernate 3.6.5.Final, MSSQL

//Trind

Is the question how to define properties_KEY so it is declared in create table statement as null or is the question why table cannot be created? — padis
– padis, Commented Jul 11, 2011 at 8:03
I wanted it to be possible to create the table. Ken Chan soloved it for me. — Trind
– Trind, Commented Jul 11, 2011 at 8:17

Ken Chan · Accepted Answer · 2011-07-11 08:08:05Z

It seems that you are mapping the collection of the value type using the hashmap . You have to specify the key column of the hashmap using @MapKeyColumn

For example , you can try it to see if the problem can be solved:

@ElementCollection(fetch=FetchType.EAGER) @CollectionTable(name="FrameworkUser_Properties") @MapKeyColumn public Map<String, String> getProperties() { return properties; }

padis · Accepted Answer · 2011-07-11 08:05:10Z

I belive you can do something like this:

 @CollectionTable( name="FrameworkUser_Properties", joinColumns=@JoinColumn(name="OWNER_ID", nullable = false) )

Collectives™ on Stack Overflow

hibernate won't create table

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related