删除报错

MENG1

DELETE FROM OF_SeatUser OF_SeatUser WHERE OF_SeatUser= 'D709EE34F4834C6AA60EB67D167766C6' AND OF_SeatUser.version = '1'

错误报告 -
SQL 错误: ORA-00904: "OF_SEATUSER": 标识符无效
00904. 00000 -  "%s: invalid identifier"

数据库里是有这个字段的啊

jishuang

如果不是用ksql操作的用sql操作的要注意大小写必须与数据库一直

MENG1

这个问题是做批量删除，保存的时候，报了下面的错
保存数据失败！ ,
删除记录OF_SeatUser, OF_SeatUser, key="B3AD6D8C4A494229A04647CBE4098209"出错, 不存在符合条件的数据, DELETE FROM OF_SeatUser OF_SeatUser WHERE OF_SeatUser= :OF_SeatUser AND OF_SeatUser.version = :version
编码：JUSTEP150180
原因：数据被其他用户修改了; 数据被其他用户删除了
隐藏详细
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 com.justep.micro.service.MicroServiceFilter.doFilter(Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 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: 编码: JUSTEP150180; 提示: 删除记录OF_SeatUser, OF_SeatUser, key="B3AD6D8C4A494229A04647CBE4098209"出错, 不存在符合条件的数据, DELETE FROM OF_SeatUser OF_SeatUser WHERE OF_SeatUser= :OF_SeatUser AND OF_SeatUser.version = :version; 可能的原因: 数据被其他用户修改了; 数据被其他用户删除了 at com.justep.exception.BusinessException.create(Unknown Source) at com.justep.system.data.impl.TableImpl.delete(Unknown Source) at com.justep.system.data.impl.TableImpl.save(Unknown Source) at com.justep.system.data.impl.TableImpl.save(Unknown Source) at com.justep.system.data.BizData.save(Unknown Source) at BizProcedure.save(BizProcedure.java:18) ... 30 more

然后再数据库里查，就报标识符无效，我改了大小写，还是报标识符无效

但是一个一个删除就没有问题

批量删除的代码：
var grid = this.comp("mainGrid");
                var rowIDs = grid.getCheckeds();//获取多选选中行的id.返回的是list数组
                var data = this.comp("mainData");
                var rows = [];   
                for(var i=0;i<rowIDs.length;i++){//遍历多选选中的行id
                        rows.push(data.getRowByID(rowIDs[i])) ; //通过行id获取到行，并push到rows中
                        if (rows.length > 0){                              
                                data.deleteData(rows);                                                               
                        }
                }

jishuang

1楼报错就是数据库标准的报错信息，可以到网上查找一下原因

MENG1

检查一楼的报错跟我3楼的问题没有关系，数据库可以正常用sql语句删除

jishuang

1楼的错误从什么地方报出来的?不是删除保存的时候tomcat报的吗？那就是失败的真正原因

MENG1

保存的时候报下面的错

保存数据失败！ ,
删除记录OF_SeatUser, OF_SeatUser, key="B3AD6D8C4A494229A04647CBE4098209"出错, 不存在符合条件的数据, DELETE FROM OF_SeatUser OF_SeatUser WHERE OF_SeatUser= :OF_SeatUser AND OF_SeatUser.version = :version
编码：JUSTEP150180
原因：数据被其他用户修改了; 数据被其他用户删除了
隐藏详细
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 com.justep.micro.service.MicroServiceFilter.doFilter(Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 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: 编码: JUSTEP150180; 提示: 删除记录OF_SeatUser, OF_SeatUser, key="B3AD6D8C4A494229A04647CBE4098209"出错, 不存在符合条件的数据, DELETE FROM OF_SeatUser OF_SeatUser WHERE OF_SeatUser= :OF_SeatUser AND OF_SeatUser.version = :version; 可能的原因: 数据被其他用户修改了; 数据被其他用户删除了 at com.justep.exception.BusinessException.create(Unknown Source) at com.justep.system.data.impl.TableImpl.delete(Unknown Source) at com.justep.system.data.impl.TableImpl.save(Unknown Source) at com.justep.system.data.impl.TableImpl.save(Unknown Source) at com.justep.system.data.BizData.save(Unknown Source) at BizProcedure.save(BizProcedure.java:18) ... 30 more

jishuang

看tomcat控制台完整的错误信息

http://bbs.wex5.com/forum.php?mo ... 4&pid=165654128

MENG1

biz.common.min.js:12 Uncaught Error: __justepServerErrorStart__{"message":"保存数据失败！ , \n删除记录OF_SeatUser, OF_SeatUser, key=\"F53DC13A0B4D4256B4FACA819AA90BB2\"出错, 不存在符合条件的数据, DELETE FROM OF_SeatUser OF_SeatUser WHERE OF_SeatUser= :OF_SeatUser AND OF_SeatUser.version = :version","reason":"数据被其他用户修改了; 数据被其他用户删除了","code":"JUSTEP150180","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 com.justep.micro.service.MicroServiceFilter.doFilter(Unknown Source)\r\n\tat org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)\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: com.justep.exception.BusinessException: 编码: JUSTEP150180; 提示: 删除记录OF_SeatUser, OF_SeatUser, key=\"F53DC13A0B4D4256B4FACA819AA90BB2\"出错, 不存在符合条件的数据, DELETE FROM OF_SeatUser OF_SeatUser WHERE OF_SeatUser= :OF_SeatUser AND OF_SeatUser.version = :version; 可能的原因: 数据被其他用户修改了; 数据被其他用户删除了\r\n\tat com.justep.exception.BusinessException.create(Unknown Source)\r\n\tat com.justep.system.data.impl.TableImpl.delete(Unknown Source)\r\n\tat com.justep.system.data.impl.TableImpl.save(Unknown Source)\r\n\tat com.justep.system.data.impl.TableImpl.save(Unknown Source)\r\n\tat com.justep.system.data.BizData.save(Unknown Source)\r\n\tat BizProcedure.save(BizProcedure.java:18)\r\n\t... 30 more\r\n","messages":["编码: JUSTEP150180; 提示: 删除记录OF_SeatUser, OF_SeatUser, key=\"F53DC13A0B4D4256B4FACA819AA90BB2\"出错, 不存在符合条件的数据, DELETE FROM OF_SeatUser OF_SeatUser WHERE OF_SeatUser= :OF_SeatUser AND OF_SeatUser.version = :version; 可能的原因: 数据被其他用户修改了; 数据被其他用户删除了"],"url":"","param":""}__justepServerErrorEnd__
    at Object.create (core.min.js:71)
    at Object.Request.errorMessage (biz.common.min.js:12)
    at n.doSaveDataAfter (biz.common.min.js:12)
    at Object.callback (biz.common.min.js:12)
    at Object.Request._requestCallback (biz.common.min.js:12)
    at Object.<anonymous> (biz.common.min.js:12)
    at f (core.min.js:71)
    at Object.add (core.min.js:71)
    at Object.Request.endBatch (biz.common.min.js:12)
    at n._endBatch (biz.common.min.js:12)
create @ core.min.js:71
Request.errorMessage @ biz.common.min.js:12
doSaveDataAfter @ biz.common.min.js:12
callback @ biz.common.min.js:12
Request._requestCallback @ biz.common.min.js:12
(anonymous) @ biz.common.min.js:12
f @ core.min.js:71
add @ core.min.js:71
Request.endBatch @ biz.common.min.js:12
_endBatch @ biz.common.min.js:12
saveData @ common.min.js:15
Model.saveBtnClick @ mainActivity.js:99
fire @ core.min.js:71
fireEvent @ core.min.js:71
callParent @ core.min.js:71
fireEvent @ common.min.js:15
_doClick @ comp.min.js:144
i @ core.min.js:71
dispatch @ core.min.js:71
g.handle @ core.min.js:71

MENG1

updateMode设置是whereVersion，删除前刷新也不行，每次都稳定报错