create table A_B (A_id int not null, b_id int not null, mapkey varchar(255) null, primary key (A_id, mapkey), unique (b_id));

create table A_B (A_id int4 not null, b_id int4 not null, mapkey varchar(255), primary key (A_id, mapkey), unique (b_id));

Hibernate produces invalid "create table" SQL for Maps on SQL Server 2000 ------------------------------------------------------------------------- Key: HHH-1935 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1935 Project: Hibernate3 Issue Type: Bug Affects Versions: 3.2.0.cr2 Environment: Hibernate 3.2.0.cr2 Microsoft SQL Server 2000 Reporter: Bill Johnson I have two cases where Hibernate3 produces invalid SQL for MS SQL Server 2000: Case 1: @CollectionOfElements @org.hibernate.annotations.MapKey protected Map<String, String> properties; Case 2: @ManyToMany @MapKeyManyToMany private Map<A, B> b; In Case 2, A and B are entities creating a ternary relationship between the parent class, A and B, and I get the following log output: ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] - <Unsuccessful: create table A_B (A_id numeric(19,0) not null, b_id numeric(19,0) not null, key_id numeric(19,0) null, primary key (A_id, key_id), unique (key_id))> ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] - <Cannot define PRIMARY KEY constraint on nullable column in table 'A_B'.> Hibernate should not attempt to create a nullable primary key column by default on MS SQL Server.