Error in SchemaUpdate using HSQLDialect with non Integer or Long primary keys ----------------------------------------------------------------------------- Key: HHH-3323 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3323 Project: Hibernate3 Issue Type: Bug Affects Versions: 3.2.6 Environment: Hibernate 3.2.6 and Hibernate Annotations 3.3.1 on HSQL DB Reporter: Jan Justesen "Only one identity column is allowed in each table. Identity columns are autoincrement columns. They must be of INTEGER or BIGINT type" When using HSQLDialect, the following code fails during schema creation: @Entity public class Test { @Id @GeneratedValue(strategy = GenerationType.AUTO) private Short id; } Log output: ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate - Unsuccessful: create table Test (id smallint generated by default as identity (start with 1), primary key (id)) ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate - Wrong data type: ID in statement [create table Test (id smallint generated by default as identity (start with 1)] -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira