起步软件技术论坛
搜索
 找回密码
 注册

QQ登录

只需一步，快速开始

起步软件技术论坛»论坛 › 开发者论坛 › BeX5开发者论坛 › JUSTEP150039报错
返回列表 发新帖
查看: 3692|回复: 1

[结贴] JUSTEP150039报错

[复制链接]

27

主题

65

帖子

221

积分

中级会员

Rank: 3Rank: 3

积分
221
QQ
发表于 2017-8-10 14:42:51 | 显示全部楼层 |阅读模式
版本: 小版本号:
数据库: 服务器操作系统: 应用服务器:
客户端操作系统: 浏览器:
做了一个保存事件，在保存的时候记录修改人修改时间及修改具体内容
保存的时候报错：
执行sql: insert into PR_History(fID,version,fFuncCode,fFuncName,fSystemName,fBillOrderno,fMID,fDID,fEditWay,fEditContext,fEditUser,fEditDate,fRemark) values(newid(),0,'HTTCLDD03008','派车单据修改','车辆调度系统','170731073','undefined','NULL','修改','字段名：fkilometreStart原始值：33新值：33','system','2017-08-10 14:36:48.705','NULL'), binds: []出错
编码：JUSTEP150039

然后数据库可以查到插入记录，控制台显示的语句也可以运行插入到数据，就是会报错；一下是详细信息
[url=]隐藏详细[/url]
java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) at com.justep.system.action.Engine.invokeActions(Native Method) at com.justep.system.action.Engine.invokeActions(Unknown Source) at com.justep.business.server.BusinessServer.doAction(Unknown Source) at com.justep.business.server.BusinessServer.doExcute(Unknown Source) at com.justep.business.server.BusinessServer.excute(Unknown Source) at com.justep.business.server.BusinessServer.excute(Unknown Source) at com.justep.business.server.BusinessServerServlet.execService(Unknown Source) at com.justep.business.server.BusinessServerServlet.service(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:723) at com.justep.x.bs.BusinessServerServlet.service(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:723) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) 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:745) Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: insert into PR_History(fID,version,fFuncCode,fFuncName,fSystemName,fBillOrderno,fMID,fDID,fEditWay,fEditContext,fEditUser,fEditDate,fRemark) values(newid(),0,'HTTCLDD03008','派车单据修改','车辆调度系统','170731073','undefined','NULL','修改','字段名：fkilometreStart原始值：33新值：33','system','2017-08-10 14:36:48.705','NULL'), binds: []出错 at com.justep.exception.BusinessException.create(Unknown Source) at com.justep.system.data.SQL.select(Unknown Source) at com.justep.system.data.SQL.select(Unknown Source) at CLDDOA.GetHistory(CLDDOA.java:613) ... 27 more Caused by: java.sql.SQLException: The executeQuery method must return a result set. at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:429) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:693) at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) ... 30 more

控制台信息：
2017-08-10 14:36:35 开始-WINDOW生成中间文件: /UI2/SA/task/taskCenter/mainActivity.w
2017-08-10 14:36:36 加载模块：/UI2/system/components/justep/bizFilter/server ...
2017-08-10 14:36:36 加载模块：/UI2/system/components/justep/bizFilter/server
2017-08-10 14:36:36 加载模块：/UI2/system/components/justep/dateFilter/server ...
2017-08-10 14:36:36 加载模块：/UI2/system/components/justep/dateFilter/server
2017-08-10 14:36:36 加载模块：/UI2/system/components/justep/gridSelect/server ...
2017-08-10 14:36:36 加载模块：/UI2/system/components/justep/gridSelect/server
2017-08-10 14:36:36 加载模块：/UI2/system/components/justep/orgFilter/server ...
2017-08-10 14:36:36 加载模块：/UI2/system/components/justep/orgFilter/server
2017-08-10 14:36:36 加载模块：/UI2/system/components/justep/org/server ...
2017-08-10 14:36:36 加载模块：/UI2/system/components/justep/list/server ...
2017-08-10 14:36:36 加载模块：/UI2/system/components/justep/list/server
2017-08-10 14:36:36 加载模块：/UI2/system/components/justep/org/server
2017-08-10 14:36:36 加载模块：/UI2/system/components/justep/dataTables/server ...
2017-08-10 14:36:36 加载模块：/UI2/system/components/justep/dataTables/server
2017-08-10 14:36:36 加载模块：/UI2/system/components/justep/pagerBar/server ...
2017-08-10 14:36:36 加载模块：/UI2/system/components/justep/pagerBar/server
2017-08-10 14:36:36 结束-WINDOW生成中间文件: /UI2/SA/task/taskCenter/mainActivity.w
2017-08-10 14:36:36 开始-中间文件生成缓存文件: /UI2/SA/task/taskCenter/mainActivity.w
2017-08-10 14:36:37 结束-中间文件生成缓存文件: /UI2/SA/task/taskCenter/mainActivity.w
2017-08-10 14:36:37 加载模块：/SA/task/taskCenter ...
2017-08-10 14:36:37 system runtime:2017-08-10 08:36
2017-08-10 14:36:37 system runtime:2017-08-10 08:36
2017-08-10 14:36:37 system runtime:2017-08-10 08:36
2017-08-10 14:36:42 开始-WINDOW生成中间文件: /UI2/CLDD_NEW/CLDDOA/process/CLDDOrderCorrec_m/mainActivity.w
2017-08-10 14:36:43 加载模块：/UI2/system/components/justep/panel/server ...
2017-08-10 14:36:43 加载模块：/UI2/system/components/justep/panel/server
2017-08-10 14:36:43 加载模块：/UI2/system/components/justep/titleBar/server ...
2017-08-10 14:36:43 加载模块：/UI2/system/components/justep/titleBar/server
2017-08-10 14:36:43 结束-WINDOW生成中间文件: /UI2/CLDD_NEW/CLDDOA/process/CLDDOrderCorrec_m/mainActivity.w
2017-08-10 14:36:43 开始-中间文件生成缓存文件: /UI2/CLDD_NEW/CLDDOA/process/CLDDOrderCorrec_m/mainActivity.w
2017-08-10 14:36:43 结束-中间文件生成缓存文件: /UI2/CLDD_NEW/CLDDOA/process/CLDDOrderCorrec_m/mainActivity.w
2017-08-10 14:36:43 加载模块：/CLDD_NEW/CLDDOA/process/CLDDOrderCorrec_m ...
2017-08-10 14:36:43 加载模块：/CLDD_NEW/CLDDOA/process ...
2017-08-10 14:36:43 加载模块：/CLDD_NEW/CLDDOA ...
2017-08-10 14:36:43 加载模块：/CLDD_NEW ...
2017-08-10 14:36:43 加载模块：/CLDD_NEW/CLDDOA/logic/code ...
2017-08-10 14:36:43 加载模块：/CLDD_NEW/CLDDOA/logic ...
2017-08-10 14:36:43 加载模块：/CLDD_NEW/CLDDOA/data ...
2017-08-10 14:36:43 加载模块：/CLDD_NEW/CLDDOA/ontology ...
2017-08-10 14:36:43 加载模块：/CLDD_NEW/CLDDOA/logic/action ...
2017-08-10 14:36:43 加载模块：/HTTPR/HTTPR_Power/logic/action ...
2017-08-10 14:36:43 加载模块：/HTTPR/HTTPR_Power/logic ...
2017-08-10 14:36:43 加载模块：/HTTPR/HTTPR_Power ...
2017-08-10 14:36:43 加载模块：/HTTPR ...
2017-08-10 14:36:43 加载模块：/HTTPR/HTTPR_Power/data ...
2017-08-10 14:36:43 加载模块：/HTTPR/HTTPR_Power/ontology ...
2017-08-10 14:36:44 加载模块：/HTTPR/HTTPR_Power/logic/code ...
2017-08-10 14:36:44 system runtime:2017-08-10 08:36
2017-08-10 14:36:44 system runtime:2017-08-10 08:36
2017-08-10 14:36:44 system runtime:2017-08-10 08:36
2017-08-10 14:36:45 system runtime:2017-08-10 08:36
2017-08-10 14:36:48 system runtime:2017-08-10 08:36
insert into PR_History(fID,version,fFuncCode,fFuncName,fSystemName,fBillOrderno,fMID,fDID,fEditWay,fEditContext,fEditUser,fEditDate,fRemark) values(newid(),0,'HTTCLDD03008','派车单据修改','车辆调度系统','170731073','undefined','NULL','修改','字段名：fkilometreStart原始值：33新值：33','system','2017-08-10 14:36:48.705','NULL')
2017-08-10 14:36:48 excute stream action, params:{"accept":"application/json","action":"GetHistoryAction","actionFlag":"__action_0__","activity":"mainActivity","contentType":"application/json","executeContext":"","executor":"","parameters":{"billorderno":"170731073","did":"NULL","editcontext":"字段名：fkilometreStart原始值：33新值：33","editdate":"[DateTime:2017-08-10T14:36:48.705Z]","edituser":"system","editway":"修改","funccode":"HTTCLDD03008","funcname":"派车单据修改","mid":"undefined","remark":"NULL","systemname":"车辆调度系统"},"process":"/CLDD_NEW/CLDDOA/process/CLDDOrderCorrec_m/cLDDOrderCorrec_mProcess"}
java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        at com.justep.system.action.Engine.invokeActions(Native Method)
        at com.justep.system.action.Engine.invokeActions(Unknown Source)
        at com.justep.business.server.BusinessServer.doAction(Unknown Source)
        at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
        at com.justep.business.server.BusinessServer.excute(Unknown Source)
        at com.justep.business.server.BusinessServer.excute(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        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:745)
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: insert into PR_History(fID,version,fFuncCode,fFuncName,fSystemName,fBillOrderno,fMID,fDID,fEditWay,fEditContext,fEditUser,fEditDate,fRemark) values(newid(),0,'HTTCLDD03008','派车单据修改','车辆调度系统','170731073','undefined','NULL','修改','字段名：fkilometreStart原始值：33新值：33','system','2017-08-10 14:36:48.705','NULL'), binds: []出错
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.data.SQL.select(Unknown Source)
        at com.justep.system.data.SQL.select(Unknown Source)
        at CLDDOA.GetHistory(CLDDOA.java:613)
        ... 27 more
Caused by: java.sql.SQLException: The executeQuery method must return a result set.
        at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:429)
        at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:693)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        ... 30 more

以下是代码：
       Model.prototype.saveBtnClick = function(event){
                    this.GetEditContextClick();
           this.comp("mainData").saveData();


        };




       Model.prototype.GetEditContextClick = function(event){
          
          
           if (this.comp("input_cclc").val()===this.comp("main2Data").getValue("fkilometreStart"))
           {}else
           {
             //alert(this.comp("input_cclc").val());
             //alert(this.comp("main2Data").getValue("fkilometreStart"));
             G_EditFieldName="fkilometreStart";
             G_OldValue=this.comp("main2Data").getValue("fkilometreStart");
             G_NewValue=this.comp("input_cclc").val();
             //记录信息
             this.GetHistoryClick();
           }
          
            if (this.comp("input_hclc").val()===this.comp("main2Data").getValue("fkilometreEnd"))
           {
              alert(1)
           }else
           {
             //alert(this.comp("input_cclc").val());
             //alert(this.comp("main2Data").getValue("fkilometreStart"));
             G_EditFieldName="fkilometreEnd";
             G_OldValue=this.comp("main2Data").getValue("fkilometreEnd");
             G_NewValue=this.comp("input_hclc").val();
             //记录信息
             this.GetHistoryClick();
           }
        };

Model.prototype.GetHistoryClick = function(event){
           //记录修改内容
            var param = new biz.Request.ActionParam();
            var sdate=new Date();
        param.setString("funccode","HTTCLDD03008");//功能编码
        param.setString("funcname","派车单据修改");//功能名称
        param.setString("systemname","车辆调度系统");// 系统名称
        param.setString("billorderno",this.comp("mainData").getValue("fSeries"));//单据号码
        param.setString("mid",this.comp("mainData").getValue("fID"));//主档ID
        param.setString("did","NULL");//明细档ID
        param.setString("editway","修改");//修改方式


        param.setString("editcontext","字段名："+G_EditFieldName+"原始值："+G_OldValue+"新值："+G_NewValue);//修改内容        
        param.setString("edituser",this.getContext().getCurrentPersonName());//修改用户
        param.setDateTime("editdate",new Date());//修改日期
        param.setString("remark","NULL");//备注

            biz.Request.sendBizRequest({
            context : this.getContext(),
            contentType:"application/json",//请求数据类型
            dataType: "application/json",//返回数据类型
            action:"GetHistoryAction",
            parameters:param,
              });
       
        };
       





回复

使用道具 举报

91

主题

13万

帖子

3万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
36185
发表于 2017-8-10 15:35:02 | 显示全部楼层
CLDDOA.GetHistory(CLDDOA.java:613)

自己的java文件中报错的

这个错误是sql的标准错误信息
https://zhidao.baidu.com/question/42033800.html
http://blog.csdn.net/ylchou/article/details/7279630
远程的联系方法QQ1392416607,添加好友时，需在备注里注明其论坛名字及ID，公司等信息
发远程时同时也发一下帖子地址，方便了解要解决的问题  WeX5教程  WeX5下载



如按照该方法解决，请及时跟帖，便于版主结贴
回复 支持 反对

使用道具 举报

返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|X3技术论坛|Justep Inc.    

GMT+8, 2025-7-15 06:43 , Processed in 0.062539 second(s), 25 queries .

Powered by Discuz! X3.4

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表