table 删除行报错

QAQ

看了论坛的帖子，自己写的代码如下，我想删除指定的行

1.                 Table table =BizData.query(concept, idColumn, select, from, condition, range, filter, distinct, offset, limit, columns, orderBy, aggregate,
   
2.                                 aggregateColumns, variables, dataModel, fnModel);
   
3.                 String code=variables.get("org_code").toString();
   
4.                 Set<String> ids = new HashSet<String>();
   
5.                 for (Iterator<Row> iterator = table.iterator(); iterator.hasNext();) {
   
6.                         Row row = iterator.next();
   
7.                         String org_code=row.getValue("org_code").toString();
   
8.                        
   
9.                         if(org_code.equals(code)){
   
10.                                 System.out.println("匹配");
    
11.                                 String fName = row.getValue("org_code").toString();
    
12.                                 System.out.println(fName);
    
13.                                 table.getMetaData().setKeyColumn("org_code");
    
14.                                 table.deleteRows(fName);
    
15.                                
    
16. //                        ids.add(org_code);
    
17. //                        System.out.println(org_code);
    
18. //                    table.getMetaData().setKeyColumn("org_code");
    
19. //                    for (String id : ids){
    
20. //                    table.deleteRows(id);
    
21. //                    }
    
22.                         }

复制代码

org_code是表里一个字段（不是主键，主键是fid）,报错误是

1. java.lang.reflect.InvocationTargetException
   
2.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   
3.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
   
4.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   
5.         at java.lang.reflect.Method.invoke(Method.java:497)
   
6.         at com.justep.system.action.Engine.invokeActions(Native Method)
   
7.         at com.justep.system.action.Engine.invokeActions(Unknown Source)
   
8.         at com.justep.business.server.BusinessServer.doAction(Unknown Source)
   
9.         at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
   
10.         at com.justep.business.server.BusinessServer.excute(Unknown Source)
    
11.         at com.justep.business.server.BusinessServer.excute(Unknown Source)
    
12.         at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
    
13.         at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
    
14.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
    
15.         at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
    
16.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
    
17.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    
18.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    
19.         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    
20.         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    
21.         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    
22.         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
    
23.         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    
24.         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
    
25.         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
    
26.         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
    
27.         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    
28.         at java.lang.Thread.run(Thread.java:745)
    
29. Caused by: java.util.ConcurrentModificationException
    
30.         at java.util.LinkedHashMap$LinkedHashIterator.nextNode(LinkedHashMap.java:711)
    
31.         at java.util.LinkedHashMap$LinkedKeyIterator.next(LinkedHashMap.java:734)
    
32.         at com.justep.system.data.impl.TableImpl$TableIterator.next(Unknown Source)
    
33.         at com.justep.system.data.impl.TableImpl$TableIterator.next(Unknown Source)
    
34.         at Main.queryYX_STATISTICS_MANAGE(Main.java:68)
    
35.         ... 27 more

复制代码

不知道哪里没有设置对，也试了这个

1. String ksql = "select AP_RQ.* from AP_RQ AP_RQ  where AP_RQ.fName like '%delete%'";
   
2.                 Table table = KSQL.select(ksql, null, "/appdemo/test/data", null);
   
3.                 table.getMetaData().setKeyColumn("fName");
   
4.                 Set<String> ids = new HashSet<String>();
   
5.                 Iterator it = table.iterator();
   
6.                 while (it.hasNext()) {
   
7.                         Row row = (Row) it.next();
   
8.                         String fName = (String) row.getValue("fName");
   
9.                         ids.add(fName);
   
10.                 }
    
11.                 table.getMetaData().setKeyColumn("fName");
    
12.                 for (String id : ids) {
    
13.                         table.deleteRows(id);
    
14.                 }
    
15.                 table.save("/appdemo/test/data");
    

复制代码

也是报错误的，这部分代码在这里
//        ids.add(org_code);
//        System.out.println(org_code);
//        table.getMetaData().setKeyColumn("org_code");
//        for (String id : ids){
// table.deleteRows(id);
// 是关于setKeyColumn和deleteRows没使用正确吗，还是怎么样

jishuang

下面的报错是什么？

QAQ

jishuang 发表于 2018-7-10 13:28
下面的报错是什么？

上面不是发了吗，第二段代码就是控制台的报错信息，前端报错如下

1. Error: __justepServerErrorStart__{"message":"刷新数据失败！ , \nnull","reason":"","code":"","stack":"java.lang.reflect.InvocationTargetException\r\n\tat sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n\tat sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n\tat java.lang.reflect.Method.invoke(Method.java:497)\r\n\tat com.justep.system.action.Engine.invokeActions(Native Method)\r\n\tat com.justep.system.action.Engine.invokeActions(Unknown Source)\r\n\tat com.justep.business.server.BusinessServer.doAction(Unknown Source)\r\n\tat com.justep.business.server.BusinessServer.doExcute(Unknown Source)\r\n\tat com.justep.business.server.BusinessServer.excute(Unknown Source)\r\n\tat com.justep.business.server.BusinessServer.excute(Unknown Source)\r\n\tat com.justep.business.server.BusinessServerServlet.execService(Unknown Source)\r\n\tat com.justep.business.server.BusinessServerServlet.service(Unknown Source)\r\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:723)\r\n\tat com.justep.x.bs.BusinessServerServlet.service(Unknown Source)\r\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:723)\r\n\tat org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)\r\n\tat org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)\r\n\tat org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)\r\n\tat org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)\r\n\tat org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)\r\n\tat org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)\r\n\tat org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)\r\n\tat org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)\r\n\tat org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)\r\n\tat org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)\r\n\tat org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)\r\n\tat java.lang.Thread.run(Thread.java:745)\r\nCaused by: java.util.ConcurrentModificationException\r\n\tat java.util.LinkedHashMap$LinkedHashIterator.nextNode(LinkedHashMap.java:711)\r\n\tat java.util.LinkedHashMap$LinkedKeyIterator.next(LinkedHashMap.java:734)\r\n\tat com.justep.system.data.impl.TableImpl$TableIterator.next(Unknown Source)\r\n\tat com.justep.system.data.impl.TableImpl$TableIterator.next(Unknown Source)\r\n\tat Main.queryYX_STATISTICS_MANAGE(Main.java:68)\r\n\t... 27 more\r\n","messages":[],"url":"http://localhost:8080/BusinessServer/business-action","param":{"contentType":"json","accept":"application/json","process":"/newYxgk/statistics/main/process/statisticsMain/statisticsMainProcess","activity":"mainActivity","actionFlag":"__action_0__","executor":"","executeContext":"","action":"queryYX_STATISTICS_MANAGEAction","parameters":{"offset":0,"limit":20,"columns":"YX_STATISTICS_MANAGE,dfhsl,dfhsl_tb,drfhs,issue,node_code,node_sort,org_code,org_name,org_sname,p_node_code,pjdj,pjdj_tb,rfhsl,rfhsl_tb,sdl,sdl_tb,yxyb","variables":{"issue":"2018-07-07","org_code":"08611010201"}},"translateParameter":{"dataType":"row-list","transformIdcolumn":true,"includeState":true,"useNamespace":true,"cellnameByRelation":false,"rowsConfig":{"concept":"YX_STATISTICS_MANAGE","sequence":"YX_STATISTICS_MANAGE,dfhsl,dfhsl_tb,drfhs,issue,node_code,node_sort,org_code,org_name,org_sname,p_node_code,pjdj,pjdj_tb,rfhsl,rfhsl_tb,sdl,sdl_tb,yxyb"}}}}__justepServerErrorEnd__
   
2.     at Object.create (core.min.js:71)
   
3.     at Object.Request.errorMessage (biz.common.min.js:12)
   
4.     at Object.callback (biz.common.min.js:12)
   
5.     at Object.h (biz.common.min.js:12)
   
6.     at f (core.min.js:71)
   
7.     at Object.add (core.min.js:71)
   
8.     at _sendRequest (biz.common.min.js:12)
   
9.     at Object.Request.sendRequest (biz.common.min.js:12)
   
10.     at Object.$var._sendBizRequest (eval at __actionFinish (biz.common.min.js:12), <anonymous>:1:577)
    
11.     at Object.Request.sendBizRequest (biz.common.min.js:12)

复制代码

jishuang

1楼发的两中方法报错都是一样的？

1. Iterator<String> it = strList.iterator();
   
2.                 while(it.hasNext()) {
   
3.                         String s = it.next();
   
4.                        
   
5.                                 strList.remove(s);
   
6.                        
   

复制代码

这样的方式遍历删除看看

QAQ

jishuang 发表于 2018-7-10 14:01
1楼发的两中方法报错都是一样的？

两种方法报错都一样，strList是什么  Lis<String>   strList= ?

QAQ

jishuang 发表于 2018-7-10 14:01
1楼发的两中方法报错都是一样的？

1. java.lang.reflect.InvocationTargetException
   
2. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   
3. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
   
4. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   
5. at java.lang.reflect.Method.invoke(Method.java:497)
   
6. at com.justep.system.action.Engine.invokeActions(Native Method)
   
7. at com.justep.system.action.Engine.invokeActions(Unknown Source)
   
8. at com.justep.business.server.BusinessServer.doAction(Unknown Source)
   
9. at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
   
10. at com.justep.business.server.BusinessServer.excute(Unknown Source)
    
11. at com.justep.business.server.BusinessServer.excute(Unknown Source)
    
12. at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
    
13. at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
    
14. at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
    
15. at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
    
16. at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
    
17. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    
18. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    
19. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    
20. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    
21. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    
22. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
    
23. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    
24. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
    
25. at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
    
26. at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
    
27. at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    
28. at java.lang.Thread.run(Thread.java:745)

复制代码

java.lang.Thread.run(Thread.java:745) Caused by: java.util.ConcurrentModificationException at java.util.LinkedHashMap$LinkedHashIterator.nextNode(LinkedHashMap.java:711)
at java.util.LinkedHashMap$LinkedKeyIterator.next(LinkedHashMap.java:734)
at com.justep.system.data.impl.TableImpl$TableIterator.next(Unknown Source)
at com.justep.system.data.impl.TableImpl$TableIterator.next(Unknown Source)
at Main.queryYX_STATISTICS_MANAGE(Main.java:69) ... 27 more

69行是  Row row = iterator.next();

jishuang

发tomcat控制台完整的错误信息，这个错误看不出什么问题

QAQ

jishuang 发表于 2018-7-10 14:44
发tomcat控制台完整的错误信息，这个错误看不出什么问题

1. 匹配
   
2. 08611010201
   
3. 2018-07-10 14:43:49 excute stream action, params:{"accept":"application/json","action":"queryYX_STATISTICS_MANAGEAction","actionFlag":"__action_0__","activity":"mainActivity","contentType":"json","executeContext":"","executor":"","parameters":{"columns":"YX_STATISTICS_MANAGE,dfhsl,dfhsl_tb,drfhs,issue,node_code,node_sort,org_code,org_name,org_sname,p_node_code,pjdj,pjdj_tb,rfhsl,rfhsl_tb,sdl,sdl_tb,yxyb","limit":20,"offset":0,"variables":{"issue":"2018-07-07","org_code":"08611010201"}},"process":"/newYxgk/statistics/main/process/statisticsMain/statisticsMainProcess","translateParameter":{"cellnameByRelation":false,"dataType":"row-list","includeState":true,"rowsConfig":{"concept":"YX_STATISTICS_MANAGE","sequence":"YX_STATISTICS_MANAGE,dfhsl,dfhsl_tb,drfhs,issue,node_code,node_sort,org_code,org_name,org_sname,p_node_code,pjdj,pjdj_tb,rfhsl,rfhsl_tb,sdl,sdl_tb,yxyb"},"transformIdcolumn":true,"useNamespace":true}}
   
4. java.lang.reflect.InvocationTargetException
   
5.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   
6.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
   
7.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   
8.         at java.lang.reflect.Method.invoke(Method.java:497)
   
9.         at com.justep.system.action.Engine.invokeActions(Native Method)
   
10.         at com.justep.system.action.Engine.invokeActions(Unknown Source)
    
11.         at com.justep.business.server.BusinessServer.doAction(Unknown Source)
    
12.         at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
    
13.         at com.justep.business.server.BusinessServer.excute(Unknown Source)
    
14.         at com.justep.business.server.BusinessServer.excute(Unknown Source)
    
15.         at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
    
16.         at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
    
17.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
    
18.         at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
    
19.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
    
20.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    
21.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    
22.         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    
23.         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    
24.         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    
25.         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
    
26.         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    
27.         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
    
28.         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
    
29.         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
    
30.         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    
31.         at java.lang.Thread.run(Thread.java:745)
    
32. Caused by: java.util.ConcurrentModificationException
    
33.         at java.util.LinkedHashMap$LinkedHashIterator.nextNode(LinkedHashMap.java:711)
    
34.         at java.util.LinkedHashMap$LinkedKeyIterator.next(LinkedHashMap.java:734)
    
35.         at com.justep.system.data.impl.TableImpl$TableIterator.next(Unknown Source)
    
36.         at com.justep.system.data.impl.TableImpl$TableIterator.next(Unknown Source)
    
37.         at Main.queryYX_STATISTICS_MANAGE(Main.java:69)
    
38.         ... 27 more
    

复制代码

jishuang

Main.queryYX_STATISTICS_MANAGE(Main.java:69)
这行是什么？

QAQ

jishuang 发表于 2018-7-10 15:09
Main.queryYX_STATISTICS_MANAGE(Main.java:69)
这行是什么？

68行：                for (Iterator<Row> iterator = table.iterator(); iterator.hasNext();) {
69行：                        Row row = iterator.next();