本帖最后由 shary 于 2011-12-21 09:35 编辑
sql执行正常
报错信息如下:
21:30:32,859 INFO AbstractDocStaticTblDAO:2305 - Oracle :select * from ( select row_.*, rownum rownum_ from ( SELECT * FROM (SELECT DISTINCT * FROM (select distinct doc.id DOCID,doc.formid FORMID,fs.flowid FLOWID,pen.flowname FLOWNAME,doc.statelabel STATELABEL,to_char(substr(pen.summary,1,1000)) as SUBJECT,to_char(substr(doc.AUDITORNAMES,1,2000)) as AUDITORNAMES,to_char(substr(doc.AUDITORLIST,1,2000)) as AUDITORLIST,doc.APPLICATIONID,doc.DOMAINID from APPUSER.T_DOCUMENT doc,APPUSER.T_FLOW_INTERVENTION pen,APPUSER.T_FLOWSTATERT fs,APPUSER.T_NODERT node,APPUSER.T_ACTORRT actor where doc.id = pen.id and doc.id =fs.docid and fs.id =node.flowstatert_id and node.id = actor.nodert_id and doc.issubdoc is null and doc.parent is null and doc.state is not null and doc.statelabel is not null and actor.actorid in ('11e1-2955-f11fd715-a7a3-3b92b95d5939') UNION select distinct doc.id DOCID,doc.formid FORMID,fs.flowid FLOWID,rhis.flowname FLOWNAME,doc.statelabel STATELABEL,to_char(substr(pen.summary,1,1000)) as SUBJECT,to_char(substr(doc.AUDITORNAMES,1,2000)) as AUDITORNAMES,to_char(substr(doc.AUDITORLIST,1,2000)) as AUDITORLIST,doc.APPLICATIONID,doc.DOMAINID from APPUSER.T_DOCUMENT doc,APPUSER.T_ACTORHIS ahis,APPUSER.T_RELATIONHIS rhis,APPUSER.T_FLOW_INTERVENTION pen,APPUSER.T_FLOWSTATERT fs where doc.id=rhis.docid and rhis.id = ahis.nodehis_id and doc.id = pen.id and doc.id =fs.docid and doc.issubdoc is null and doc.parent is null and doc.state is not null and doc.statelabel is not null and ahis.actorid in ('11e1-2955-f11fd715-a7a3-3b92b95d5939')) tab order by tab.formid,tab.flowid) table_0 WHERE table_0.DOMAINID ='11e1-2955-4c7c5114-a7a3-3b92b95d5939' ) row_ where rownum <= 10) where rownum_ > 0
java.lang.NullPointerException
at cn.myapps.core.dynaform.work.ejb.WorkVO.setSubject(WorkVO.java:118)
at cn.myapps.core.dynaform.document.dao.AbstractDocStaticTblDAO.setWorkProperties(AbstractDocStaticTblDAO.java:2367)
at cn.myapps.core.dynaform.document.dao.AbstractDocStaticTblDAO.queryWorkBySQL(AbstractDocStaticTblDAO.java:2312)
at cn.myapps.core.dynaform.document.dao.AbstractDocStaticTblDAO.queryWorkBySQLPage(AbstractDocStaticTblDAO.java:2278)
at cn.myapps.core.dynaform.document.dao.AbstractDocStaticTblDAO.queryWorkBySQLPage(AbstractDocStaticTblDAO.java:2189)
at cn.myapps.core.dynaform.document.ejb.DocumentProcessBean.queryWorks(DocumentProcessBean.java:1558)
at cn.myapps.core.dynaform.work.action.WorkAction.doWorkList(WorkAction.java:150)
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 com.opensymphony.xwork.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:365)
at com.opensymphony.xwork.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:217)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:191)
at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189)
at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:113)
at com.opensymphony.webwork.dispatcher.DispatcherUtils.serviceAction(DispatcherUtils.java:233)
at com.opensymphony.webwork.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:198)
at cn.myapps.base.web.filter.OBPMFilterDispatcher.doFilter(OBPMFilterDispatcher.java:43)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.opensymphony.webwork.dispatcher.ActionContextCleanUp.doFilter(ActionContextCleanUp.java:78)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at cn.myapps.base.web.filter.AjaxMultiLanguageFilter.doFilter(AjaxMultiLanguageFilter.java:42)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at cn.myapps.base.web.filter.PersistenceFilter.doFilter(PersistenceFilter.java:30)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at cn.myapps.base.web.filter.SecurityFilter.doFilter(SecurityFilter.java:109)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jasig.cas.client.util.AssertionThreadLocalFilter.doFilter(AssertionThreadLocalFilter.java:54)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jasig.cas.client.util.HttpServletRequestWrapperFilter.doFilter(HttpServletRequestWrapperFilter.java:75)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jasig.cas.client.validation.AbstractTicketValidationFilter.doFilter(AbstractTicketValidationFilter.java:197)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at cn.myapps.core.sso.cas.filter.OBPMAuthenticationFilter.doFilter(OBPMAuthenticationFilter.java:84)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jasig.cas.client.session.SingleSignOutFilter.doFilter(SingleSignOutFilter.java:76)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at cn.myapps.base.web.filter.EncodingFilter.doFilter(EncodingFilter.java:27)
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:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:291)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:619) |