Version hibernate 2.1.4

Problem:

The use of a primary key with DB2 (os390 or z / os) require
to create an index on the primary key. The shape exact is the following one:
CREATE UNIQUE(ONLY) INDEX <nameIndex>

The UNIQUE keyword is mandatory.

Mapping:

I use following mapping:

<hibernate-mapping schema="QXBAPXX">
<class name="Flight" table="COMOR_FLIGHT">
<id name="id" type="integer" unsaved-value="-1">
<column name="id" unique="true" index="ixid"/>
<generator class="native"/>
</id>
....

I use the element column to introduce 'index' and the 'unique' keyword.
In the generation, I obtain the following ddl:

create table QXBAPXX.COMOR_FLIGHT (
id INTEGER not null generated by default as identity unique,
..);

and

create index ixid on QXBAPXX.COMOR_FLIGHT (id);

The good syntax should be:

CREATE UNIQUE INDEX ixid on QXBAPXX.COMOR_FLIGHT (id);


The UNIQUE keyword is missing


Thanks.

I'd suggest you add a patch for it against DB2390Dialect to JIRA - should be trivial

Effectively, the modification is very simple. Posted, JIRA issue #HB-1028.

http://opensource.atlassian.com/projects/hibernate/browse/HB-1028

thanks

It is not simple. It is about a new function because you should not modify the creation of index for the not key attributes. The modification that I proposed modifies all index generation. It is not good !!