HyperSonic and primaryKey

[Guillaume Barr�]

HI

 

A sql problem with hypersonic.

 

My schema file looks like : 

 

<table javaName="CourseSupplier" name="CMS_COURSE_SUPPLIERS" idMethod="native">

<column javaName="Id" name="ID" primaryKey="true" required="true"  
autoIncrement="true"  type="INTEGER"/>

            <column javaName="ContactFirtName" name="CONTACT_FIRST_NAME" size="50" 
type="VARCHAR"  />

            <column javaName="ContactLastName" name="CONTACT_LAST_NAME" size="50" 
type="VARCHAR" />

            <column javaName="ContactEmail" name="CONTACT_EMAIL" size="50" 
type="VARCHAR" />

</table>

 

And the gemerated SQL code is : 

 

CREATE TABLE TEST_COURSE_SUPPLIERS
(
    ID integer IDENTITY,
    CONTACT_FIRST_NAME VARCHAR (50),
    CONTACT_LAST_NAME VARCHAR (50),
    CONTACT_EMAIL VARCHAR (50),
    PRIMARY KEY(ID)
);

 

 

My problem is that when I create the table on HyperSonic I have the following error  

 

Erreur Attempt to define a second primary key in statement ... Error code 24 / State 
S0011

 

Any idea ?

 

Thanks in advance

Guillaume