Hi!
My problem:

@ElementCollection
@CollectionTable(name = "xxx", joinColumns = @JoinColumn(name = "depends", nullable = false))
@Column(name = "dependent", nullable = false)
public Map<String, String> getDependents() {
return this.dependents;
}

generates the following DDL script:

create table xxx (depends numeric(19,0) not null, dependent varchar(255) not null, dependents_KEY varchar(255) null, primary key (depends, dependents_KEY))
As you can see, I managed to get the "not null" behind every column except the last one: dependents_KEY.
so MS SQL fails to create the table.

"dependents_KEY varchar(255) null" doesn't work as NULL Primary Keys are not allowed in MS SQL. What can I do to force hibernate to generate
dependents_KEY varchar(255) NOT null

Thank you very much!
Java Junky

Ok, got it:

@ElementCollection
@CollectionTable(name = "xxx", joinColumns = @JoinColumn(name = "depends", nullable = false))
@Column(name = "dependent", nullable = false)
@MapKeyColumn(name = "dependent_key", nullable = false)

I missed the MapKeyColumn!