Update row failed. unable to locate row to update in table

purple.taro 2011-04-08 12:47:18

今天在对SYBASE数据库的查询结果集进行使用updaterowRow()操作时，报SQLException异常如下:

view plaincopy to clipboardprint?

java.sql.SQLException: Update row failed. unable to locate row to update in table.
at net.sourceforge.jtds.jdbc.CachedResultSet.updateRow(CachedResultSet.java:1316)
at com.css.court.newzx.export.cxzj.updateZzjgdm.update(updateZzjgdm.java:75)
at com.css.court.newzx.export.cxzj.updateZzjgdm.main(updateZzjgdm.java:97)

JDBC包使用的是jtds.jar包，经过查看结果集中的列，发现会否是因为没有可以唯一确定一行的数据的原因呢，随即试着将结果中的列更多些，并将可以唯一确定一行数据的列都查询出来，然后再运行软件，成功了，如果有知道问题所在的，留言哦，谢谢

...全文

74 回复打赏收藏转发到动态举报

写回复

回复

切换为时间正序

请发表友善的回复…

发表回复

from sqlalchemy import create_engine, MetaData, Table, Column, Integer, Numeric, String, ForeignKey, Boolean from sqlalchemy import CheckConstraint from datetime import datetime from sqlalchemy import...

OGG-01043: Terminate on fetch result = {1} ({2,number,0}) (table: {0...Cause: The process failed to fetch column data, and the ABEND action is specified by the REPFETCHEDCOLOPTIONS parameter. Action:...

OGG-10548: Schema.table is required for heartbeattable...Cause: The heartbeat table is required in GLOBALS with schema and table name. Action: Edit the GLOBALS file and specify a fully qualified hear...

you are unable to optimize your queries you may want to increase your join_buffer_size to accommodate larger joins in one pass . This script will still suggest ...

ORA-00000 to ORA-00877 2-1 ORA-00000 to ORA-00877 2 ORA-00000: normal, successful completion Cause: Normal exit. Action: None ORA-00001: unique constraint (string.string) violated Cause: An UPDA

2,596

社区成员

25,614

社区内容

发帖

与我相关

我的任务

社区管理员

加入社区

近7日
近30日
至今

加载中

查看更多榜单

社区公告

暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章