关于OA中资产拆旧功能报错

chenshiqiang00 · 发表于 2013-2-26 14:59:17

老师，您好，我们现在用OA中的资产拆旧功能，原先的时候输入年月是报数据类型不对，是inter类型和varchar类型不匹配，改完JS代码中点查询的时候不报错了，但是现在点拆旧按钮报错，找到对应的java文件把SQL文件改了，后来提示说对应的class文件拒绝访问！求教！！！

jishuang · 发表于 2013-2-26 15:16:50

详细的错误信息发一下

chenshiqiang00 · 发表于 2013-2-26 15:32:54

2013-02-26 15:32:35 excute Action error:<?xml version="1.0" encoding="UTF-8"?>
<action direct-execute="false" process="/OA/asset/process/assetDepreciation/assetDepreciationProcess" activity="assetDepreciationActivity" action-flag="__action_0__" executor="" execute-context="" name="insertDepreciationAction"><parameters xmlns:xbiz="http://www.justep.com/xbiz#"><parameter name="year"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"><![CDATA[3]]></xbiz:simple></parameter><parameter name="month"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"><![CDATA[2]]></xbiz:simple></parameter></parameters></action>
com.justep.model.exception.ModelException: java.lang.RuntimeException: compile error :
C:\X5.2.3\model\BIZ\OA\asset\logic\code\dsrc\asset.java:13: 写入 asset.rAssetInfo 时出错： C:\X5.2.3\model\BIZ\OA\asset\logic\code\dclasses\asset$rAssetInfo.class (拒绝访问。)
private static class rAssetInfo {
^
1 错误

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.BusinessServerServlet.execService(Unknown Source)
at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
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.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:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.lang.RuntimeException: compile error :
C:\X5.2.3\model\BIZ\OA\asset\logic\code\dsrc\asset.java:13: 写入 asset.rAssetInfo 时出错： C:\X5.2.3\model\BIZ\OA\asset\logic\code\dclasses\asset$rAssetInfo.class (拒绝访问。)
private static class rAssetInfo {
^
1 错误

at com.justep.model.impl.ModelImpl$DynamicClassManager.compile(Unknown Source)
at com.justep.model.impl.ModelImpl$DynamicClassManager.getDynamicClass(Unknown Source)
at com.justep.model.impl.ModelImpl$DynamicClassManager.getDynamicMethod(Unknown Source)
at com.justep.model.impl.ModelImpl.getModelMethod(Unknown Source)
at com.justep.system.action.Engine.invokeActions(Native Method)
... 21 more

jishuang · 发表于 2013-2-26 15:55:31

文件中写的有错误没有编辑成功
把dsrc目录右键设置为源码路径把java文件中错误修改正确

chenshiqiang00 · 发表于 2013-2-26 16:00:57

设置完了以后都是ContextHelper这个无法解析，这又是怎么回事？？？

jishuang · 发表于 2013-2-26 16:17:51

在构建路径中把runtime\BusinessServer\WEB-INF\lib、model\BIZ\system\logic\code\lib下的jar包导入

chenshiqiang00 · 发表于 2013-2-26 16:37:58

麻烦您给看看吧，我怎么把这两个文件下的jar包都导入还是不行。

jishuang · 发表于 2013-2-26 16:55:01

qq1392416607看一下

chenshiqiang00 · 发表于 2013-2-26 17:42:17

老师，您好，现在点拆旧的时候还会报错，JS代码里面改了，现在是java代码里面报错，执行的是这个方法;
public static void insertDepreciation(String year, String month)
throws Exception {
Statement stmt = null;
String sql = null;
String guid = "";
Connection conn = ModelUtils.getConnection("/OA");
ContextHelper.getTransaction().begin(conn);
try {
stmt = conn.createStatement();
String strDatabaseType = conn.getMetaData()
.getDatabaseProductName();
if (strDatabaseType.equalsIgnoreCase("Oracle")) {
guid = "sys_guid()";
} else {
guid = "newid()";
}
try {
sql = "insert into OA_AS_Deprecition"
+ "(fDepreYear,fDepreMonth,fBgDepreYear,fBgDepreMonth"
+ ",fID,fKindID,fKind,fName,fSpecType,fOriginValue"
+ ",fAddDepreValue"
+ ",fDutyDeptID,fDutyDeptName,fDutyPsnID,fDutyPsnName,fServiceYear"
+ ",fCreateTime,fCode,version)"
+ "select "
+ year
+ ","
+ month
+ ""
+ ",fBgDepreYear,fBgDepreMonth,"
+ guid
+ ",fKindID,fKind,fName,fSpecType,fOriginValue"
+ ",fAddDepreValue"
+ ",fDutyDeptID,fDutyDeptName,fDutyPsnID,fDutyPsnName,fServiceYear"
+ ",fCreateTime,fCode,version" + " from OA_AS_Card"
+ " where fcode not in (select d.fcode from OA_AS_Deprecition d where d.fdepreyear="+ year
+" and d.fdepremonth="+ month
+") and ((fBgDepreYear < " + year
+ " and fBgDepreMonth is not null)"
+ " or (fBgDepreYear =" + year
+ " and fBgDepreMonth <" + month
+ ")) and (fBgDepreYear+fServiceYear > "+ year
+" or (fBgDepreYear+fServiceYear ="+ year
+"and fBgDepreMonth > "+ month
+"))";
stmt.execute(sql);
} finally {
stmt.close();
stmt = null;
}
} finally {
conn.close();
conn = null;
}
}
现在输入的年份和月份都是Integer类型的，但是现在把上面代码中的单引号去掉，现在还是报类型不符合！

MaHZ · 发表于 2013-2-26 17:53:41

chenshiqiang00 发表于 2013-2-26 17:42
老师，您好，现在点拆旧的时候还会报错，JS代码里面改了，现在是java代码里面报错，执行的是这个方法;
publ ...

把后台报错信息贴出来

		自动登录	找回密码
密码			注册

[结贴] 关于OA中资产拆旧功能报错