同样查询方法,在测试类中正确,但是在页面运行的时候返回null,请高手看一下!

[yzw19841017]

我用了SSH框架
这是错误信息
.....
----------------110 这里是传递的参数
2008-06-21 13:24:28 [信息] Using transaction object [org.springframework.orm.hibernate3.HibernateTransactionManager$HibernateTransactionObject@d861b7]
2008-06-21 13:24:28 [信息] Creating new transaction with name [groggery.service.IFoodManager.listFood]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT
2008-06-21 13:24:28 [信息] opened session at timestamp: 4972649957888000
2008-06-21 13:24:28 [信息] Opened new Session [org.hibernate.impl.SessionImpl@1f7670d] for Hibernate transaction
2008-06-21 13:24:28 [信息] Preparing JDBC Connection of Hibernate Session [org.hibernate.impl.SessionImpl@1f7670d]
2008-06-21 13:24:28 [信息] begin
2008-06-21 13:24:28 [信息] opening JDBC connection
2008-06-21 13:24:28 [信息] current autocommit status: true
2008-06-21 13:24:28 [信息] disabling autocommit
2008-06-21 13:24:28 [信息] after transaction begin
2008-06-21 13:24:28 [信息] Exposing Hibernate transaction as JDBC transaction [org.apache.commons.dbcp.PoolableConnection@16ba7f9]
2008-06-21 13:24:28 [信息] Bound value [org.springframework.jdbc.datasource.ConnectionHolder@18e95d9] for key [org.apache.commons.dbcp.BasicDataSource@1e74fe9] to thread [http-8080-1]
2008-06-21 13:24:28 [信息] Bound value [org.springframework.orm.hibernate3.SessionHolder@10098b] for key [org.hibernate.impl.SessionFactoryImpl@1ad637e] to thread [http-8080-1]
2008-06-21 13:24:28 [信息] Initializing transaction synchronization
2008-06-21 13:24:28 [信息] Getting transaction for [groggery.service.IFoodManager.listFood]
页面参数:110
页面参数(DAO):110
2008-06-21 13:24:28 [信息] Retrieved value [org.springframework.orm.hibernate3.SessionHolder@10098b] for key [org.hibernate.impl.SessionFactoryImpl@1ad637e] bound to thread [http-8080-1]
2008-06-21 13:24:28 [信息] Retrieved value [org.springframework.orm.hibernate3.SessionHolder@10098b] for key [org.hibernate.impl.SessionFactoryImpl@1ad637e] bound to thread [http-8080-1]
2008-06-21 13:24:28 [信息] Found thread-bound Session for HibernateTemplate
2008-06-21 13:24:28 [信息] unable to locate HQL query plan in cache; generating (FROM Htfood)
2008-06-21 13:24:29 [信息] parse() - HQL: FROM ORM.Htfood
2008-06-21 13:24:29 [信息] --- HQL AST ---
\-[QUERY] 'query'
\-[SELECT_FROM] 'SELECT_FROM'
\-[FROM] 'FROM'
\-[RANGE] 'RANGE'
\-[DOT] '.'
+-[IDENT] 'ORM'
\-[IDENT] 'Htfood'

2008-06-21 13:24:29 [信息] throwQueryException() : no errors
2008-06-21 13:24:29 [信息] select << begin [level=1, statement=select]
2008-06-21 13:24:29 [信息] FromClause{level=1} : ORM.Htfood (no alias) -> htfood0_
2008-06-21 13:24:29 [信息] select : finishing up [level=1, statement=select]
2008-06-21 13:24:29 [信息] processQuery() : ( SELECT ( FromClause{level=1} HTgroggeryDB.dbo.HTfood htfood0_ ) )

[yzw19841017]

接问题:
2008-06-21 13:24:29 [信息] result set row: 0


2008-06-21 13:24:29 [信息] Hydrating entity: [ORM.Htfood#10]
2008-06-21 13:24:29 [信息] returning '12' as column: Food2_9_
2008-06-21 13:24:29 [信息] returning 'BBB' as column: Food3_9_
2008-06-21 13:24:29 [信息] returning '25.56' as column: Food4_9_
2008-06-21 13:24:29 [信息] returning 'BBB' as column: Food5_9_
2008-06-21 13:24:29 [信息] returning '说明说明说明' as column: Food6_9_
2008-06-21 13:24:29 [信息] returning '0.0' as column: Food7_9_
2008-06-21 13:24:29 [信息] result set row: 8
2008-06-21 13:24:29 [信息] returning '13' as column: Food1_9_
2008-06-21 13:24:29 [信息] result row: EntityKey[ORM.Htfood#13]
2008-06-21 13:24:29 [信息] Initializing object from ResultSet: [ORM.Htfood#13]
2008-06-21 13:24:29 [信息] Hydrating entity: [ORM.Htfood#13]
2008-06-21 13:24:29 [信息] returning '12' as column: Food2_9_
2008-06-21 13:24:29 [信息] returning 'BBB' as column: Food3_9_
2008-06-21 13:24:29 [信息] returning '25.4897' as column: Food4_9_
2008-06-21 13:24:29 [信息] returning 'BBB' as column: Food5_9_
2008-06-21 13:24:29 [信息] returning '说明说明说明' as column: Food6_9_
2008-06-21 13:24:29 [信息] returning '0.0' as column: Food7_9_
2008-06-21 13:24:29 [信息] result set row: 9
2008-06-21 13:24:29 [信息] returning '14' as column: Food1_9_
2008-06-21 13:24:29 [信息] result row: EntityKey[ORM.Htfood#14]
2008-06-21 13:24:29 [信息] Initializing object from ResultSet: [ORM.Htfood#14]
2008-06-21 13:24:29 [信息] Hydrating entity: [ORM.Htfood#14]
2008-06-21 13:24:29 [信息] returning '12' as column: Food2_9_
2008-06-21 13:24:29 [信息] returning 'BBB' as column: Food3_9_
2008-06-21 13:24:29 [信息] returning '25.4897' as column: Food4_9_
2008-06-21 13:24:29 [信息] returning 'BBB' as column: Food5_9_
2008-06-21 13:24:29 [信息] returning '说明说明说明' as column: Food6_9_
2008-06-21 13:24:29 [信息] returning '0.0' as column: Food7_9_ 这里值已经查询出来拉
2008-06-21 13:24:29 [信息] done processing result set (10 rows)
2008-06-21 13:24:29 [信息] about to close ResultSet (open ResultSets: 1, globally: 1)
2008-06-21 13:24:29 [信息] about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2008-06-21 13:24:29 [信息] closing statement
2008-06-21 13:24:29 [信息] total objects hydrated: 10
2008-06-21 13:24:29 [信息] resolving associations for [ORM.Htfood#1]这个是类名
2008-06-21 13:24:29 [信息] loading entity: [ORM.HtfoodType#6]这句是什么意思,怎么会有[ORM.HtfoodType#6]?
2008-06-21 13:24:29 [信息] creating new proxy for entity
2008-06-21 13:24:29 [信息] Not closing pre-bound Hibernate Session after HibernateTemplate

[yzw19841017]

再接:
null---错误原因是
java.lang.NullPointerException
at org.hibernate.tuple.AbstractEntityTuplizer.createProxy(AbstractEntityTuplizer.java:372)
at org.hibernate.persister.entity.AbstractEntityPersister.createProxy(AbstractEntityPersister.java:3121)
at org.hibernate.event.def.DefaultLoadEventListener.createProxyIfNecessary(DefaultLoadEventListener.java:232)
at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:173)
at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:87)
at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:862)
at org.hibernate.impl.SessionImpl.internalLoad(SessionImpl.java:830)
at org.hibernate.type.EntityType.resolveIdentifier(EntityType.java:266)
at org.hibernate.type.EntityType.resolve(EntityType.java:303)
at org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:116)
at org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:842)
at org.hibernate.loader.Loader.doQuery(Loader.java:717)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2145)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
at org.hibernate.loader.Loader.list(Loader.java:2024)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:308)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:153)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1106)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at groggery.daoHibernate.BaseDAOhibernate$1.doInHibernate(BaseDAOhibernate.java:31)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:372)
at org.springframework.orm.hibernate3.HibernateTemplate.executeFind(HibernateTemplate.java:342)
at groggery.daoHibernate.BaseDAOhibernate.findByPage(BaseDAOhibernate.java:27)
at groggery.daoHibernate.FoodDAOhibernate.listFood(FoodDAOhibernate.java:26)
at groggery.serviceImpl.FoodManagerImpl.listFood(FoodManagerImpl.java:47)
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:304)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy16.listFood(Unknown Source)
at groggery.web.action.FoodManagerAction.allFood(FoodManagerAction.java:157)
at groggery.web.action.FoodManagerAction.firstPage(FoodManagerAction.java:214)
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.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:269)
at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:170)
at org.springframework.web.struts.DelegatingActionProxy.execute(DelegatingActionProxy.java:110)
at org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)
at org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)
at org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
at org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:304)
at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
at org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at groggery.servlet.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:32)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:228)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:216)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:634)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:445)
at java.lang.Thread.run(Unknown Source)

.....
方法也经过其他SQL语句查询,没有任何问题.请高手帮帮忙!!!!