接上
06-06-13 06:09:03,078 WARN  JDBCExceptionReporter( 49 ) - [Microsoft][SQLServer 2000 Driver for JDBC]Database changed to myData
06-06-13 06:09:03,078 WARN  JDBCExceptionReporter( 48 ) - SQL Warning: 5701, SQLState: 01000
06-06-13 06:09:03,078 WARN  JDBCExceptionReporter( 49 ) - [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]已将数据库上下文改为 'myData'。
06-06-13 06:09:03,093 WARN  JDBCExceptionReporter( 48 ) - SQL Warning: 0, SQLState: 
06-06-13 06:09:03,109 WARN  JDBCExceptionReporter( 49 ) - [Microsoft][SQLServer 2000 Driver for JDBC]Language changed to 简体中文
06-06-13 06:09:03,109 WARN  JDBCExceptionReporter( 48 ) - SQL Warning: 5703, SQLState: 01000
06-06-13 06:09:03,109 WARN  JDBCExceptionReporter( 49 ) - [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]已将语言设置改为 简体中文。
06-06-13 06:09:03,109 DEBUG JDBCContext( 199 ) - after transaction completion
06-06-13 06:09:03,109 DEBUG ConnectionManager( 296 ) - transaction completed on session with on_close connection release mode; be sure to close the session to release JDBC resources!
06-06-13 06:09:03,125 DEBUG SessionImpl( 417 ) - after transaction completion
06-06-13 06:09:03,125 DEBUG PropertyMessageResources( 134 ) - getMessage(zh_CN,unhandledException)
06-06-13 06:09:03,125 DEBUG PropertyMessageResources( 226 ) - loadLocale(zh_CN)
06-06-13 06:09:03,125 DEBUG PropertyMessageResources( 248 ) -   Loading resource 'org/apache/struts/action/ActionResources_zh_CN.properties'
06-06-13 06:09:03,125 DEBUG PropertyMessageResources( 273 ) -   Loading resource completed
06-06-13 06:09:03,125 DEBUG PropertyMessageResources( 226 ) - loadLocale(zh)
06-06-13 06:09:03,125 DEBUG PropertyMessageResources( 248 ) -   Loading resource 'org/apache/struts/action/ActionResources_zh.properties'
06-06-13 06:09:03,140 DEBUG PropertyMessageResources( 273 ) -   Loading resource completed
06-06-13 06:09:03,140 DEBUG PropertyMessageResources( 226 ) - loadLocale()
06-06-13 06:09:03,140 DEBUG PropertyMessageResources( 248 ) -   Loading resource 'org/apache/struts/action/ActionResources.properties'
06-06-13 06:09:03,140 DEBUG PropertyMessageResources( 273 ) -   Loading resource completed
.......
06-06-13 06:09:03,203 DEBUG PropertyMessageResources( 286 ) -   Saving message key '.verifyMessageResourcesConfigs.invalid
06-06-13 06:09:03,203 WARN  RequestProcessor( 509 ) - Unhandled Exception thrown: class org.springframework.orm.hibernate3.HibernateQueryException
06-06-13 06:09:03,218 ERROR [action]( 253 ) - Servlet.service() for servlet action threw exception
org.springframework.orm.hibernate3.HibernateQueryException: users is not mapped. [ from users  as users ]; nested exception is org.hibernate.hql.ast.QuerySyntaxException: users is not mapped. [ from users  as users ]
org.hibernate.hql.ast.QuerySyntaxException: users is not mapped. [ from users  as users ]
at org.hibernate.hql.ast.util.SessionFactoryHelper.requireClassPersister(SessionFactoryHelper.java:157)
at org.hibernate.hql.ast.tree.FromElementFactory.addFromElement(FromElementFactory.java:87)
at org.hibernate.hql.ast.tree.FromClause.addFromElement(FromClause.java:70)
at org.hibernate.hql.ast.HqlSqlWalker.createFromElement(HqlSqlWalker.java:265)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElement(HqlSqlBaseWalker.java:3049)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:2938)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:688)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:544)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:281)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:229)
at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:218)
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:158)
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:109)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:75)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:54)
at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:71)
at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:133)
at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:112)
at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1583)
at org.springframework.orm.hibernate3.HibernateTemplate$31.doInHibernate(HibernateTemplate.java:846)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:366)
at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:844)
at org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:836)
at sonic.DAO.impl.UsersDAOImpl.findAllUsers(UsersDAOImpl.java:53)
at sonic.service.impl.UsersManagerImpl.findAllUsers(UsersManagerImpl.java:24)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176)

解决方案 »

  1.   

    问题2 当我用user 表的时候,同样的代码出现的错误是:
    ---更加郁闷。 两个问题同样的代码错误现象不同,
    ------------------到底是什么问题呀?javax.servlet.ServletException: unexpected token: [ near line 1, column 7 [ from [user]  as u ]; nested exception is org.hibernate.hql.ast.QuerySyntaxException: unexpected token: [ near line 1, column 7 [ from [user]  as u ]
    org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:516)
    org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:423)
    org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
    org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
    org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
    root cause org.springframework.orm.hibernate3.HibernateQueryException: unexpected token: [ near line 1, column 7 [ from [user]  as u ]; nested exception is org.hibernate.hql.ast.QuerySyntaxException: unexpected token: [ near line 1, column 7 [ from [user]  as u ]
    org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:652)
    org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:413)
    org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:371)
    org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:844)
    org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:836)
    sonic.DAO.impl.UserDAOImpl.findAllUser(UserDAOImpl.java:53)
    sonic.service.impl.UserManagerImpl.findAllUser(UserManagerImpl.java:24)
    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    java.lang.reflect.Method.invoke(Unknown Source)
    org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287)
    org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181)
    org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148)
    org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
    org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
    org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176)
    $Proxy5.findAllUser(Unknown Source)
    sonic.LoginAction.execute(LoginAction.java:40)
    org.springframework.web.struts.DelegatingActionProxy.execute(DelegatingActionProxy.java:106)
    org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
    org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
    org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
    org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      

  2.   

    你的hql有问题:from users as users改成-->from com.hibernate.Users as usersform后面跟的是个完整的类名,包括package.