2009-04-06 08:59:39,187 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] - Unsuccessful: alter table ES.dbo.bid add index FK17CFD9060DF48 (user_id), add constraint FK17CFD9060DF48 foreign key (user_id) references ES.dbo.auction_user (user_id)
2009-04-06 08:59:39,187 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] - [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]在关键字 'index' 附近有语法错误。
2009-04-06 08:59:39,187 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] - Unsuccessful: alter table ES.dbo.bid add index FK17CFD8FAEDEAF (item_id), add constraint FK17CFD8FAEDEAF foreign key (item_id) references ES.dbo.item (item_id)
2009-04-06 08:59:39,187 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] - [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]在关键字 'index' 附近有语法错误。
2009-04-06 08:59:39,203 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] - Unsuccessful: alter table ES.dbo.item add index FK317B13FC478F60 (owner_id), add constraint FK317B13FC478F60 foreign key (owner_id) references ES.dbo.auction_user (user_id)
2009-04-06 08:59:39,203 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] - [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]在关键字 'index' 附近有语法错误。
2009-04-06 08:59:39,203 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] - Unsuccessful: alter table ES.dbo.item add index FK317B13E731830F (kind_id), add constraint FK317B13E731830F foreign key (kind_id) references ES.dbo.kind (kind_id)
2009-04-06 08:59:39,203 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] - [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]在关键字 'index' 附近有语法错误。
2009-04-06 08:59:39,203 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] - Unsuccessful: alter table ES.dbo.item add index FK317B133EB76DDE (state_id), add constraint FK317B133EB76DDE foreign key (state_id) references ES.dbo.state1 (state_id)
2009-04-06 08:59:39,203 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] - [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]在关键字 'index' 附近有语法错误。
2009-04-06 08:59:39,203 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] - Unsuccessful: alter table ES.dbo.item add index FK317B1356B9B8CA (winer_id), add constraint FK317B1356B9B8CA foreign key (winer_id) references ES.dbo.auction_user (user_id)
2009-04-06 08:59:39,203 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] - [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]在关键字 'index' 附近有语法错误。
我用了SSH整合,SQLServer 2000 数据库
报错的原因是hibernate配置文件里使用了错误的方言,我之前使用的是mysql的方言,应该改成sql server的方言就可以了