Hi

I'm get the following error from schemaexport (2.1.6) when running it against mysql 4.0.21. When I copy and paste the statement into a mysql console, it parses ok thou.

Cas
--

create table job (job_id bigint not null auto_increment, title varchar(255), des
cription varchar(255), location varchar(255), country varchar(255), starting var
char(255), duration varchar(255), rate varchar(255), reference varchar(255), pos
ted datetime, user_id bigint, category_id bigint, primary key (job_id))
Sep 29, 2004 10:19:32 PM net.sf.hibernate.tool.hbm2ddl.SchemaExport execute
SEVERE: Unsuccessful: create table job (job_id bigint not null auto_increment, t
itle varchar(255), description varchar(255), location varchar(255), country varc
har(255), starting varchar(255), duration varchar(255), rate varchar(255), refer
ence varchar(255), posted datetime, user_id bigint, category_id bigint, primary
key (job_id))
Sep 29, 2004 10:19:32 PM net.sf.hibernate.tool.hbm2ddl.SchemaExport execute
SEVERE: Syntax error or access violation, message from server: "You have an err
or in your SQL syntax. Check the manual that corresponds to your MySQL server v
ersion for the right syntax to use near 'starting varchar(255), duration varchar
(255), rate varchar(255)"

Hibernate version: 2.1.6