db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Guillaume Barré <Guillaume.Ba...@technomedia.ca>
Subject HyperSonic and primaryKey
Date Mon, 08 Mar 2004 19:52:48 GMT
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

 


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message