通过sql语句查询出来的视图点开表单报空指针错误

青岛融贯汇众 · 发表于 2014-5-29 15:59:42

本帖最后由 Jarod 于 2014-7-2 09:52 编辑

您好，我的视图是通过sql语句查出来的，通过视图列打开表单的时候tomcat报空指针的错误，找半天找不到原因。请帮忙处理谢谢！

15:56:17,990 INFO AbstractDocStaticTblDAO:1667 - MS SQL Server: SELECT d.* FROM
DBO.TLK_NOTICE d WHERE d.ID=?
15:56:18,006 INFO AbstractFlowStateRTDAO:116 - MS SQL SERVER: SELECT * FROM DBO
.T_FLOWSTATERT WHERE ID=?
15:56:18,006 INFO AbstractActorRTDAO:136 - MS SQL SERVER: SELECT * FROM DBO.T_A
CTORRT WHERE FLOWSTATERT_ID=? ORDER BY ID
15:56:18,022 INFO AbstractCirculatorDAO:434 - MS SQL SERVER: SELECT * FROM DBO.
T_CIRCULATOR c WHERE c.DOC_ID =? AND c.FLOWSTATERT_ID =? AND c.USERID =? AND c.I
SREAD =?
15:56:18,037 INFO AbstractFlowStateRTDAO:441 - MS SQL SERVER: SELECT COUNT(0) F
ROM DBO.T_FLOWSTATERT vo WHERE vo.DOCID='11e3-e6fd-55304d8d-88d3-b1c236c9b970'
15:56:18,069 INFO AbstractNodeRTDAO:294 - MS SQL SERVER: SELECT * FROM DBO.T_NO
DERT WHERE FLOWSTATERT_ID=?
15:56:18,084 INFO AbstractActorRTDAO:136 - MS SQL SERVER: SELECT * FROM DBO.T_A
CTORRT WHERE NODERT_ID=? ORDER BY ID
java.lang.NullPointerException
at org.apache.jsp.portal.default_.dynaform.document.content_jsp._jspServ
ice(content_jsp.java:990)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
.java:388)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:3
13)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp
atcher.java:646)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(Applica
tionDispatcher.java:436)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationD
ispatcher.java:374)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDis
patcher.java:302)
at com.opensymphony.webwork.dispatcher.ServletDispatcherResult.doExecute
(ServletDispatcherResult.java:114)
at cn.myapps.base.web.ServletResult.OBPMServletDispatcherResult.doExecut
e(OBPMServletDispatcherResult.java:32)
at com.opensymphony.webwork.dispatcher.WebWorkResultSupport.execute(WebW
orkResultSupport.java:101)
at com.opensymphony.xwork.DefaultActionInvocation.executeResult(DefaultA
ctionInvocation.java:312)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionIn
vocation.java:207)
at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(Around
Interceptor.java:31)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionIn
vocation.java:189)
at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.
java:113)
at com.opensymphony.webwork.dispatcher.DispatcherUtils.serviceAction(Dis
patcherUtils.java:233)
at com.opensymphony.webwork.dispatcher.FilterDispatcher.doFilter(FilterD
ispatcher.java:198)
at cn.myapps.base.web.filter.OBPMFilterDispatcher.doFilter(OBPMFilterDis
patcher.java:43)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at com.opensymphony.webwork.dispatcher.ActionContextCleanUp.doFilter(Act
ionContextCleanUp.java:78)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at cn.myapps.base.web.filter.AjaxMultiLanguageFilter.doFilter(AjaxMultiL
anguageFilter.java:43)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at cn.myapps.base.web.filter.PersistenceFilter.doFilter(PersistenceFilte
r.java:33)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at cn.myapps.base.web.filter.SecurityFilter.doFilter(SecurityFilter.java
:127)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at org.jasig.cas.client.util.AssertionThreadLocalFilter.doFilter(Asserti
onThreadLocalFilter.java:54)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at org.jasig.cas.client.util.HttpServletRequestWrapperFilter.doFilter(Ht
tpServletRequestWrapperFilter.java:75)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at org.jasig.cas.client.validation.AbstractTicketValidationFilter.doFilt
er(AbstractTicketValidationFilter.java:197)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at cn.myapps.core.sso.cas.filter.OBPMAuthenticationFilter.doFilter(OBPMA
uthenticationFilter.java:87)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at org.jasig.cas.client.session.SingleSignOutFilter.doFilter(SingleSignO
utFilter.java:76)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at cn.myapps.base.web.filter.EncodingFilter.doFilter(EncodingFilter.java
:28)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:861)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
ss(Http11Protocol.java:606)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:48
9)
at java.lang.Thread.run(Thread.java:662)
15:57:12,335 INFO Task:569 - ************ Execute Start *************
15:57:14,679 INFO Task:617 - ************ Execute End *************

复制代码

punk · 发表于 2014-5-30 10:17:30

您好~把你的视图的sql贴上来看看，还有你的表单里的字段有什么脚本之类的嘛？

青岛融贯汇众 · 发表于 2014-5-30 10:28:06

var userid=getWebUser().getId();
var sql="SELECT FORMID ,APPLICATIONID ,DOMAINID ,ITEM_通知类型 ITEM_N_TYPE ,ITEM_N_TIME ITEM_N_TIME,ITEM_S_SCOPE ITEM_S_SCOPE ,ITEM_N_TITLE ITEM_N_TITLE, ID FROM [dbo].[TLK_NOTICE] where convert(nvarchar(255),ITEM_S_SCOPE) like '%"+userid+"%' or convert(nvarchar(255),ITEM_S_SCOPE) ='' or author ='"+userid+"'";
println("sql===="+sql);
sql;

复制代码

字段有脚本的，但是之前也有脚本，之前是好用的！脚本就是获取当前日期的。

punk · 发表于 2014-5-30 10:32:02

之前是可以的？那是什么时候就出现这个错呐，或者是说改动了什么就出现了这个呢？

青岛融贯汇众 · 发表于 2014-5-30 10:33:56

我能说我也不知道么，不知道改啥了突然就这样了！

punk · 发表于 2014-5-30 10:36:56

本帖最后由 punk 于 2014-5-30 10:43 编辑

那我远程给你看看吧~你貌似有我qq吧 2023469350

青岛融贯汇众 · 发表于 2014-6-30 13:50:00

已解决！可结帖！

		自动登录	找回密码
密码			注册成为天翎用户

[已解决] 通过sql语句查询出来的视图点开表单报空指针错误

相关帖子

浏览过的版块