结果集已耗尽

dh_n

结果集已耗尽。

jishuang

把java文件和完整的错误信息发一下

dh_n

1. ava.sql.SQLException: 结果集已耗尽
   
2.         at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
   
3.         at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
   
4.         at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
   
5.         at oracle.jdbc.driver.OracleResultSetImpl.getBigDecimal(OracleResultSetImpl.java:1528)
   
6.         at oracle.jdbc.driver.OracleResultSet.getBigDecimal(OracleResultSet.java:2042)
   
7.         at Transaction.selectTaskState(Transaction.java:220)
   
8.         at Transaction.selectTask(Transaction.java:163)
   
9.         at Transaction.selectTrans(Transaction.java:31)
   
10.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    
11.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    
12.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    
13.         at java.lang.reflect.Method.invoke(Method.java:497)
    
14.         at com.justep.system.action.Engine.invokeActions(Native Method)
    
15.         at com.justep.system.action.Engine.invokeActions(Unknown Source)
    
16.         at com.justep.business.server.BusinessServer.doAction(Unknown Source)
    
17.         at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
    
18.         at com.justep.business.server.BusinessServer.excute(Unknown Source)
    
19.         at com.justep.business.server.BusinessServer.excute(Unknown Source)
    
20.         at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
    
21.         at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
    
22.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
    
23.         at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
    
24.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
    
25.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    
26.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    
27.         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    
28.         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    
29.         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    
30.         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
    
31.         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    
32.         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
    
33.         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
    
34.         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
    
35.         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    
36.         at java.lang.Thread.run(Thread.java:745)
    
37. java.lang.RuntimeException: 结果集已耗尽
    
38.         at Transaction.selectTaskState(Transaction.java:227)
    
39.         at Transaction.selectTask(Transaction.java:163)
    
40.         at Transaction.selectTrans(Transaction.java:31)
    
41.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    
42.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    
43.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    
44.         at java.lang.reflect.Method.invoke(Method.java:497)
    
45.         at com.justep.system.action.Engine.invokeActions(Native Method)
    
46.         at com.justep.system.action.Engine.invokeActions(Unknown Source)
    
47.         at com.justep.business.server.BusinessServer.doAction(Unknown Source)
    
48.         at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
    
49.         at com.justep.business.server.BusinessServer.excute(Unknown Source)
    
50.         at com.justep.business.server.BusinessServer.excute(Unknown Source)
    
51.         at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
    
52.         at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
    
53.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
    
54.         at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
    
55.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
    
56.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    
57.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    
58.         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    
59.         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    
60.         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    
61.         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
    
62.         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    
63.         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
    
64.         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
    
65.         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
    
66.         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    
67.         at java.lang.Thread.run(Thread.java:745)
    
68. 2017-12-29 15:43:25 excute stream action, params:{"accept":"application/json","action":"selectTransAction","actionFlag":"__action_0__","activity":"mainActivity","contentType":"json","executeContext":"","executor":"","parameters":{"personID":"null","role":"null","taskType":"工艺计划接收"},"process":"/erp/transaction/process/technics/technicsProcess"}
    
69. java.lang.reflect.InvocationTargetException
    
70.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    
71.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    
72.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    
73.         at java.lang.reflect.Method.invoke(Method.java:497)
    
74.         at com.justep.system.action.Engine.invokeActions(Native Method)
    
75.         at com.justep.system.action.Engine.invokeActions(Unknown Source)
    
76.         at com.justep.business.server.BusinessServer.doAction(Unknown Source)
    
77.         at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
    
78.         at com.justep.business.server.BusinessServer.excute(Unknown Source)
    
79.         at com.justep.business.server.BusinessServer.excute(Unknown Source)
    
80.         at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
    
81.         at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
    
82.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
    
83.         at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
    
84.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
    
85.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    
86.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    
87.         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    
88.         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    
89.         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    
90.         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
    
91.         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    
92.         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
    
93.         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
    
94.         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
    
95.         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    
96.         at java.lang.Thread.run(Thread.java:745)
    
97. Caused by: java.lang.RuntimeException: 结果集已耗尽
    
98.         at Transaction.selectTrans(Transaction.java:39)
    
99.         ... 27 more

复制代码

dh_n

1. import java.math.*;

复制代码

jishuang

用了平台的KSQL的API不需要自己在创建连接

http://bbs.wex5.com/forum.php?mod=viewthread&tid=33592

dh_n

结贴