[hibernate-issues] [Hibernate-JIRA] Updated: (HHH-2715) DB2390Dialect does not support unique index generation for primary key

DB2390Dialect does not support unique index generation for primary key ---------------------------------------------------------------------- Key: HHH-2715 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2715 Project: Hibernate3 Issue Type: Patch Components: core Affects Versions: 3.2.4.sp1 Environment: hibernate 2.1.4 - database: DB2 for 0S390 v7.1 - OS390 Reporter: Eric Georges Attachments: DB2OS390.rar Original Estimate: 10 minutes Remaining Estimate: 10 minutes supportsUniqueConstraintInCreateAlterTable return true. For IBM DB2 on OS 390 it must return false. hbm file : <?xml version="1.0"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> <hibernate-mapping> <class name="events.Event" table="EVENTS"> <id name="id"> <column name="ID" unique-key="ID_IDX" sql-type="int"> </column> <generator class="increment"></generator> </id> <property name="date" type="timestamp" column="DATE"></property> <property name="title" type="string" column="TITLE"> </property> </class> </hibernate-mapping> Actually it generate this : create table EVENTS (ID int not null, DATE timestamp, TITLE varchar(255), primary key (ID), unique (ID)) if supportsUniqueConstraintInCreateAlterTable return false it does : create table EVENTS (ID int not null, DATE timestamp, TITLE varchar(255), primary key (ID)) create unique index ID_IDX on EVENTS (ID) the right SQL code for DB2 v7 on OS390