Hibernate: select top 50 viewjqmedi0_.ID as ID355_, viewjqmedi0_.idcard as idcard355_, viewjqmedi0_.juweihui as juweihui355_, viewjqmedi0_.createjwh as createjwh355_, viewjqmedi0_.name as name355_, viewjqmedi0_.Sex as Sex355_, viewjqmedi0_.address as address355_, viewjqmedi0_.workplace as workplace355_, viewjqmedi0_.phonenumber as phonenum9_355_, viewjqmedi0_.monthincome as monthin10_355_, viewjqmedi0_.objecttype as objecttype355_, viewjqmedi0_.diseasetype as disease12_355_, viewjqmedi0_.helpproportion as helppro13_355_, viewjqmedi0_.medicalexpenses as medical14_355_, viewjqmedi0_.submitexpenses as submite15_355_, viewjqmedi0_.allhelp as allhelp355_, viewjqmedi0_.selfexpenses as selfexp17_355_, viewjqmedi0_.helpmoney as helpmoney355_, viewjqmedi0_.helptime as helptime355_, viewjqmedi0_.applytime as applytime355_, viewjqmedi0_.jwhopinion as jwhopinion355_, viewjqmedi0_.jwhsignature as jwhsign22_355_, viewjqmedi0_.jwhapprovaltime as jwhappr23_355_, viewjqmedi0_.townopinion as townopi24_355_, viewjqmedi0_.townsignature as townsig25_355_, viewjqmedi0_.townapprovaltime as townapp26_355_, viewjqmedi0_.communitysignature as communi27_355_, viewjqmedi0_.communityopinion as communi28_355_, viewjqmedi0_.communityapprovaltime as communi29_355_, viewjqmedi0_.leaderopinion as leadero30_355_, viewjqmedi0_.leadersignature as leaders31_355_, viewjqmedi0_.leaderapprovaltime as leadera32_355_, viewjqmedi0_.step as step355_, viewjqmedi0_.filename as filename355_, viewjqmedi0_.remark as remark355_, viewjqmedi0_.disabled as disabled355_, viewjqmedi0_.createtime as createtime355_, viewjqmedi0_.createby as createby355_, viewjqmedi0_.modifyby as modifyby355_, viewjqmedi0_.modifytime as modifytime355_, viewjqmedi0_.medicaltype as medical41_355_ from syrknew.dbo.View_JQMedicalHelp viewjqmedi0_ where 1=1 order by viewjqmedi0_.ID desc
15:14:50,096 WARN RequestProcessor:516 – Unhandled Exception thrown: class org.springframework.orm.hibernate3.HibernateSystemException
2013-6-1 15:14:50 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet action threw exception
java.lang.NullPointerException
at com.charityhelp.model.ViewJqmedicalHelp$$BulkBeanByCGLIB$$c4b53df8.setPropertyValues()
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.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 com.charityhelp.dao.daoImpl.FundsDaoImpl$5.doInHibernate(FundsDaoImpl.java:506)
at com.charityhelp.dao.daoImpl.FundsDaoImpl$5.doInHibernate(FundsDaoImpl.java:1)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:372)
at org.springframework.orm.hibernate3.HibernateTemplate.executeFind(HibernateTemplate.java:342)
at com.charityhelp.dao.daoImpl.FundsDaoImpl.findmedicalHelpByCom(FundsDaoImpl.java:498)
at com.charityhelp.agent.agentImpl.FundsAgentImpl.findmedicalHelpByCom(FundsAgentImpl.java:168)
at com.charityhelp.action.FundsAction.findmedicalHelpByCom(FundsAction.java:633)
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:597)
at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:274)
at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:194)
at org.springframework.web.struts.DelegatingActionProxy.execute(DelegatingActionProxy.java:110)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
at com.common.MyActionServlet.process(MyActionServlet.java:14)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.filter.Powerfilter.doFilter(Powerfilter.java:53)
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:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:619)
********
前台显示数据库信息，报如上错误。
查询结果中包含null的项
解决办法：对数字类型的字段都赋默认值

改下数据库表，选一行，全部填完整，ok