Question

[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 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 数据库
请问怎么解决?
原来是我自己笔误，和映射文件的名字对不上号，加上改用MYSQl，问题才算彻底解决。SQLServer 2000 数据库和Hibernate不是很好的搭挡

Answer 1

add table ..... add index ....,add constraint ....for...........
把add index ....,去掉看看