Wrong SQL Statement... (MySQL)

[karstents]

Hi folks!

I thought I get, those UNKNOWN-PKs running, but now MySQL screams. There's a wrong statement created...

CREATE TABLE EMPLOYEE
 (firstname VARCHAR(250),
 lastname VARCHAR(250),
 employeeid INTEGER(11) NOT NULL IDENTITY,
 CONSTRAINT PK_EMPLOYEE PRIMARY KEY (employeeid))

Does anyone know, what the error may be, or how it can be solved?
I think it's not okay for MySQL to put CONSTRAINT into a 'normal' CREATE Statement, but am not quite sure with that...

Thanks a lot,
Karsten

[aloubyansky]

It is absolutely fine to contraint into the create statement. I guess, you are using

<datasource-mapping>Hypersonic SQL</datasource-mapping>

with MySql datasource.