Hibernate异常org.hibernate.PropertyAccessException

sgelove 2010-03-25 11:51:08



Hibernate: select c.posjsid,c.jsoperator,y.* from (select w.id,y.posid,y.poser,y.posjsdate,w.updatetime ,w.endtime,w.begin ,w.logout ,w.cash,w.bank ,w.bank1,w.membercard ,w.citybank from yw_checkin w left join yw_salesmain y on w.poserid = y.ygid and w.updatetime<y.updatetime and w.endtime >y.updatetime group by w.id) y left join cw_jssalemain c on y.posjsdate = c.lastdate group by y.id

1817266 WARN  [http-8080-Processor20] org.apache.struts.action.RequestProcessor     - Unhandled Exception thrown: class org.hibernate.PropertyAccessException

1817266 ERROR [http-8080-Processor20] org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/rmbcs].[action]     - Servlet.service() for servlet action threw exception

java.lang.NullPointerException

	at cn.rmsd.rmbcs.command.RijieCommand$$BulkBeanByCGLIB$$7078c5cd.setPropertyValues(<generated>)

	at org.hibernate.tuple.PojoEntityTuplizer.setPropertyValuesWithOptimizer(PojoEntityTuplizer.java:212)

	at org.hibernate.tuple.PojoEntityTuplizer.setPropertyValues(PojoEntityTuplizer.java:185)

	at org.hibernate.persister.entity.AbstractEntityPersister.setPropertyValues(AbstractEntityPersister.java:3232)

	at org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:129)

	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.custom.CustomLoader.list(CustomLoader.java:111)

	at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1655)

	at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:142)

	at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:164)

	at cn.rmsd.rmbcs.hibernate.dao.RijieDao.resultCount(RijieDao.java:31)

	at cn.rmsd.rmbcs.service.imp.RijieServiceImpl.query(RijieServiceImpl.java:24)

	at cn.rmsd.rmbcs.struts.action.RijieAction.query(RijieAction.java:60)

	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

	at java.lang.reflect.Method.invoke(Method.java:585)

	at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:270)

	at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:187)

	at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)

	at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)

	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)

	at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)

	at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)

	at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)

	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)

	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)

	at cn.rmsd.rmbcs.util.LoginFilter.doFilter(LoginFilter.java:34)

	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)

	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)

	at cn.rmsd.rmbcs.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:43)

	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)

	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)

	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)

	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)

	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)

	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)

	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)

	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:875)

	at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)

	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)

	at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)

	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)

	at java.lang.Thread.run(Thread.java:595)

==========================================================================
SQL语句

select c.posjsid,c.jsoperator,y.* from (select w.id,y.posid,y.poser,y.posjsdate,w.updatetime ,w.endtime,w.begin ,w.logout ,w.cash,w.bank ,w.bank1,w.membercard ,w.citybank from yw_checkin w left join yw_salesmain y on w.poserid = y.ygid and w.updatetime<y.updatetime and w.endtime >y.updatetime group by w.id) y left join cw_jssalemain c on y.posjsdate = c.lastdate group by y.id

...全文