Entity will not create ---------------------- Key: HHH-3322 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3322 Project: Hibernate3 Issue Type: Bug Affects Versions: 3.2.6 Environment: JBoss4.2.2.GA, MySQL 5.0, Windows XP Reporter: scott duke Priority: Trivial A couple of days ago I was trying to create a new entity called "InFile". I have about 5 other entities which do not have any problem, except for the one called InFile. If I rename the entity to InFile2, the problem doesn't occur. The problem is during the application server startup trying to create the database table in MySQL. When I take the SQL script and run it in the MySQL browser, it gets created. I do not know if this is a hibernate issue or MySQL issue. I found that "infile" is a reserved word in MySQL 5.0, but if it allows me to create the database table from MySQL browser, shouldn't it allow me to create it when I have it defined as an entity? Below you will see what the log file created. 2008-05-31 09:05:57,812 INFO [org.hibernate.tool.hbm2ddl.SchemaExport] Running hbm2ddl schema export 2008-05-31 09:05:57,812 INFO [org.hibernate.tool.hbm2ddl.SchemaExport] exporting generated schema to database 2008-05-31 09:05:57,812 DEBUG [org.hibernate.tool.hbm2ddl.SchemaExport] alter table Address drop foreign key FK1ED033D411ACF83E 2008-05-31 09:05:57,968 DEBUG [org.hibernate.tool.hbm2ddl.SchemaExport] alter table Address drop foreign key FK1ED033D4C11DB190 2008-05-31 09:05:58,125 DEBUG [org.hibernate.tool.hbm2ddl.SchemaExport] alter table UzerRoles drop foreign key FK621DB3AB3DA02DB8 2008-05-31 09:05:58,250 DEBUG [org.hibernate.tool.hbm2ddl.SchemaExport] alter table UzerRoles drop foreign key FK621DB3AB11ACF83E 2008-05-31 09:05:58,437 DEBUG [org.hibernate.tool.hbm2ddl.SchemaExport] drop table if exists Address 2008-05-31 09:05:58,453 DEBUG [org.hibernate.tool.hbm2ddl.SchemaExport] drop table if exists CityStateZip 2008-05-31 09:05:58,468 DEBUG [org.hibernate.tool.hbm2ddl.SchemaExport] drop table if exists ImportFile 2008-05-31 09:05:58,468 DEBUG [org.hibernate.tool.hbm2ddl.SchemaExport] drop table if exists InFile 2008-05-31 09:05:58,484 DEBUG [org.hibernate.tool.hbm2ddl.SchemaExport] Unsuccessful: drop table if exists InFile 2008-05-31 09:05:58,484 DEBUG [org.hibernate.tool.hbm2ddl.SchemaExport] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'InFile' at line 1 2008-05-31 09:05:58,484 DEBUG [org.hibernate.tool.hbm2ddl.SchemaExport] drop table if exists InFile2 2008-05-31 09:05:58,484 DEBUG [org.hibernate.tool.hbm2ddl.SchemaExport] drop table if exists Uzer 2008-05-31 09:05:58,515 DEBUG [org.hibernate.tool.hbm2ddl.SchemaExport] drop table if exists UzerRole 2008-05-31 09:05:58,531 DEBUG [org.hibernate.tool.hbm2ddl.SchemaExport] drop table if exists UzerRoles 2008-05-31 09:05:58,578 DEBUG [org.hibernate.tool.hbm2ddl.SchemaExport] create table Address ( id bigint not null auto_increment, type varchar(255), version integer, addressee1 varchar(255), addressee2 varchar(255), address1 varchar(255), address2 varchar(255), createdOn datetime, LastUsedOn datetime, cityStateZipId bigint not null, uzerId bigint not null, primary key (id) ) 2008-05-31 09:05:58,687 DEBUG [org.hibernate.tool.hbm2ddl.SchemaExport] create table CityStateZip ( id bigint not null auto_increment, country varchar(255), version integer, zipcode varchar(255), latitude float, longitude float, city varchar(255), province varchar(255), county varchar(255), zipclass varchar(255), primary key (id) ) 2008-05-31 09:05:58,734 DEBUG [org.hibernate.tool.hbm2ddl.SchemaExport] create table ImportFile ( id bigint not null auto_increment, name varchar(20), type integer, version integer, status integer, createdOn datetime, primary key (id) ) 2008-05-31 09:05:58,812 DEBUG [org.hibernate.tool.hbm2ddl.SchemaExport] create table InFile ( id bigint not null auto_increment, name varchar(20), version integer, primary key (id) ) 2008-05-31 09:05:58,812 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] Unsuccessful: create table InFile (id bigint not null auto_increment, name varchar(20), version integer, primary key (id)) 2008-05-31 09:05:58,812 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'InFile (id bigint not null auto_increment, name varchar(20), version integer, pr' at line 1 2008-05-31 09:05:58,812 DEBUG [org.hibernate.tool.hbm2ddl.SchemaExport] create table InFile2 ( id bigint not null auto_increment, name varchar(20), version integer, primary key (id) ) 2008-05-31 09:05:58,906 DEBUG [org.hibernate.tool.hbm2ddl.SchemaExport] create table Uzer ( id bigint not null auto_increment, name varchar(40), version integer, uzername varchar(20), hashedPassword varchar(255), company varchar(50), email varchar(255), primaryPhone varchar(20), primaryExt varchar(10), secondaryPhone varchar(20), secondaryExt varchar(10), uzerSince date, primary key (id) ) 2008-05-31 09:05:58,984 DEBUG [org.hibernate.tool.hbm2ddl.SchemaExport] create table UzerRole ( id bigint not null auto_increment, name varchar(20), version integer, primary key (id) ) 2008-05-31 09:05:59,281 DEBUG [org.hibernate.tool.hbm2ddl.SchemaExport] create table UzerRoles ( uzerId bigint not null, roleId bigint not null ) 2008-05-31 09:05:59,343 DEBUG [org.hibernate.tool.hbm2ddl.SchemaExport] alter table Address add index FK1ED033D411ACF83E (uzerId), add constraint FK1ED033D411ACF83E foreign key (uzerId) references Uzer (id) 2008-05-31 09:05:59,468 DEBUG [org.hibernate.tool.hbm2ddl.SchemaExport] alter table Address add index FK1ED033D4C11DB190 (cityStateZipId), add constraint FK1ED033D4C11DB190 foreign key (cityStateZipId) references CityStateZip (id) 2008-05-31 09:05:59,593 DEBUG [org.hibernate.tool.hbm2ddl.SchemaExport] alter table UzerRoles add index FK621DB3AB3DA02DB8 (roleId), add constraint FK621DB3AB3DA02DB8 foreign key (roleId) references UzerRole (id) 2008-05-31 09:05:59,765 DEBUG [org.hibernate.tool.hbm2ddl.SchemaExport] alter table UzerRoles add index FK621DB3AB11ACF83E (uzerId), add constraint FK621DB3AB11ACF83E foreign key (uzerId) references Uzer (id) 2008-05-31 09:05:59,906 INFO [org.hibernate.tool.hbm2ddl.SchemaExport] Executing import script: /import.sql -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira