日期:2014-05-18  浏览次数:20675 次

求助:Hibernate 影射 SQL2000 数据库表 的问题
下面是异常,但是同样的影射,自动生成的DAO方法,   连接mysql   就没有问题,sql200   就出现下面的问题,还请大虾们指点指点。(sql2000,所需的驱动都意见加入了。)

Exception   in   thread   "main "   org.hibernate.exception.GenericJDBCException:   could   not   execute   query
at   org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:82)
at   org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:70)
at   org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at   org.hibernate.loader.Loader.doList(Loader.java:1596)
at   org.hibernate.loader.Loader.list(Loader.java:1577)
at   org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:395)
at   org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:271)
at   org.hibernate.impl.SessionImpl.list(SessionImpl.java:844)
at   org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
at   com.hibernate.DAO.UserDAO.findAll(UserDAO.java:89)
at   com.hibernate.DAO.UserDAO.main(UserDAO.java:131)
Caused   by:   java.sql.SQLException:   [Microsoft][SQLServer   JDBC   Driver][SQLServer]在关键字   'user '   附近有语法错误。
at   com.microsoft.jdbc.base.BaseExceptions.createException(Unknown   Source)
at   com.microsoft.jdbc.base.BaseExceptions.getException(Unknown   Source)
at   com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown   Source)
at   com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown   Source)
at   com.microsoft.jdbc.sqlserver.tds.TDSExecuteRequest.processReplyToken(Unknown   Source)
at   com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown   Source)
at   com.microsoft.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown   Source)
at   com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown   Source)
at   com.microsoft.jdbc.base.BaseStatement.executeQueryInternal(Unknown   Source)
at   com.microsoft.jdbc.base.BasePreparedStatement.executeQuery(Unknown   Source)
at   org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:120)
at   org.hibernate.loader.Loader.getResultSet(Loader.java:1272)
at   org.hibernate.loader.Loader.doQuery(Loader.java:391)
at   org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:218)
at   org.hibernate.loader.Loader.doList(Loader.java:1593)
...   7   more


------解决方案--------------------
Caused by: java.sql.SQLException: [Microsoft][SQLServer JDBC Driver][SQLServer]在关键字 'user ' 附近有语法错误。
你的sql语句好像有问题吧 拿到查询分析器里面执行一下看看是不是有错!!!