Result Set not updatable解决办法

最新推荐文章于 2025-01-22 12:04:28 发布
原创 最新推荐文章于 2025-01-22 12:04:28 发布 · 2.6k 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。

本文针对在使用ResultSet进行更新操作时出现的错误进行了详细说明，并提供了解决方案。该错误主要由于ResultSet不可更新引起，通常涉及从单一表中选择所有主键且不使用函数的情况。通过设置PreparedStatement的类型为TYPE_SCROLL_INSENSITIVE和CONCUR_UPDATABLE，可以有效解决问题。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

ResultSet更新操作时产生错误。
com.mysql.jdbc.NotUpdatable: Result Set not updatable.This result set must come from a statement that was created with a result set type of ResultSet.CONCUR_UPDATABLE, the query must select only one table, can not use functions and must select all primary keys from that table. See the JDBC 2.1 API Specification, section 5.6 for more details.This result set must come from a statement that was created with a result set type of ResultSet.CONCUR_UPDATABLE, the query must select only one table, can not use functions and must select all primary keys from that table. See the JDBC 2.1 API Specification, section 5.6 for more details.
解决办法：
ps = getConnection().prepareStatement(sql, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);

SAP Fiori Elements 扩展实战：UI 层扩展、OData 服务扩展、CDS 视图增强及全流程案例
2007 年 ~ 2025 年，深耕 SAP 技术 18 年
05-03 284
UI 层扩展主要关注在不修改标准生成界面的基础上，自定义用户界面元素和交互逻辑。典型需求包括：在现有 Fiori Elements 界面上添加新的字段（如表格列或表单项）、增加自定义按钮并绑定操作、以及通过控制器扩展加入事件处理等。无论在 RAP 还是传统 BOPF 架构下，前端 UI 扩展通常采用 SAPUI5 提供的**扩展点（Extension Points）和控制器扩展（Controller Extension）**机制来安全地插入自定义代码。下面分别说明两种后端架构下 UI 扩展的实现方式。
mysql update 无主键_mysql缺少主键无法更新结果集
weixin_35492662的博客
01-19 937
importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importjava.sql.SQLException;publicclassResultSetTest{priv...import java.sql.Connection;...
Result Set not updatable
weixin_44405758的博客
05-11 1241
com.mysql.jdbc.NotUpdatable: Result Set not updatable (referenced table has no primary keys).This result set must come from a statement that was created with a result set type of ResultSet.CONCUR_UPDATABLE, the query must select only one table, can not use
com.mysql.jdbc.NotUpdatable: Result Set not updatable (references no primary keys).（解决方法）
PacosonSWJTU的博客
02-03 3402
【1】异常详细信息 com.mysql.jdbc.NotUpdatable: Result Set not updatable (references no primary keys). This result set must come from a statement that was created with a result set type of ResultSet.CO
JDBC操作MySQL出现：This result set must come from a statement that was created with a result set type of ...
angou6476的博客
06-12 368
错误如下： This result set must come from a statement that was created with a result set type of ResultSet.CONCUR_UPDATABLE, the query must select only one table, can not use functions and must selec...
JDBC中ResultSet的修改
05-02 1602
JDBC的ResultSet对象，一般用法中update和select是由独立的Statement来完成。尝试了一下直接update结果集。数据库oracle9i,驱动classes12.jarConnection con = ds.buildConnection();PreparedStatement smt = con.prepareStatement(sql,ResultSet.TYPE_S
java Result Set not updatable (referenced table has no primary keys).This result set must come from a statement that was created with a result set type of ResultSet.CONCUR_UPDATABLE, the query must select only one table, can not use functions and must select all primary keys from that table. See the JDBC 2.1 API Specification, section 5.6 for more details.
06-09
当您在使用 JDBC 访问数据库时遇到 "Result Set not updatable (referenced table has no primary keys)" 错误时，这是由 Java JDBC API 的特定约束导致的。错误信息明确表明结果集不可更新，因为它引用了一个没有...
com.mysql.cj.jdbc.exceptions.NotUpdatable: Result Set not updatable (referenced table has no primary keys).This result set must come from a statement that was created with a result set type of ResultSet.CONCUR_UPDATABLE, the query must select only one table, can not use functions and must select all primary keys from that table. See the JDBC 2.1 API Specification, section 5.6 for more details.
最新发布
06-09
根据您遇到的 `com.mysql.cj.jdbc.exceptions.NotUpdatable: Result Set not updatable` 异常，该错误是由 JDBC 对可更新结果集 (`ResultSet.CONCUR_UPDATABLE`) 的严格限制导致的。以下是具体原因及解决方案： ---...
这是数据区表结构：CREATE TABLE `t_framehead` ( `N_FRAMEHEAD_ID` int NOT NULL AUTO_INCREMENT COMMENT '帧结构ID，自增主键', `N_TYPE` tinyint NOT NULL COMMENT '类型，1=遥测，2=遥控，3=其他', `D_CREATE` datetime NOT NULL COMMENT '创建时间，不能为空，系统创建时的时间', `VC_DESC` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '简述，简单描述，如适用项目等，允许为空', PRIMARY KEY (`N_FRAMEHEAD_ID`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC; // 封装请求函数 export const frameheadAPI = (data) => { return request({ url: '/edit/framehead', method: 'POST', data }) } data示例：{desc: “”,type: 2} 写一份后端接口，springboot3，rest风格 ，controller，entity,mapper,service(impl),xml全都要，结果封装：public class Result { private Integer code; private String msg; private Object data; public static Result success() { Result result = new Result(); result.setCode(200); result.setMsg("请求成功"); return result; } public static Result success(Object data) { Result result = new Result(); result.setCode(200); result.setMsg("请求成功"); result.setData(data); return result; } public static Result error() { Result result = new Result(); result.setCode(500); result.setMsg("系统错误"); return result; } public static Result error(Integer code,String msg) { Result result = new Result(); result.setCode(code); result.setMsg(msg); return result; } public static Result error(Integer code,String msg,Object data) { Result result = new Result(); result.setCode(code); result.setMsg(msg); result.setData(data); return result; } public Integer getCode() { return code; } public void setCode(Integer code) { this.code = code; } public String getMsg() { return msg; } public void setMsg(String msg) { this.msg = msg; } public Object getData() { return data; } public void setData(Object data) { this.data = data; } }
03-17
关于时间字段D_CREATE，在插入时应该由数据库自动生成，所以在插入语句中可以使用NOW()，或者在Entity的字段上添加@Column(insertable = false, updatable = false)并设置数据库默认值为CURRENT_TIMESTAMP，这样应用...
Not support this resultset type
12-27
throw new UnsupportedOperationException("This driver does not support scrollable ResultSets."); } ``` #### 检查是否存在记录 为了避免因无法执行某些操作而引发异常，在实际应用中更推荐的做法是在遍历之前...
JDBC中的一些问题！
邱学喆的专栏
09-03 1630
com.mysql.jdbc.NotUpdatable: Result Set not updatable (referenced table has no primary keys).This result set must come from a statement that was created with a result set type of ResultSet.CONCUR_UPDA
JDBC
bfwj520的博客
06-02 158
com.mysql.jdbc.NotUpdatable: Result Set not updatable.This result set must come from a statement that was created with a result set type of ResultSet.CONCUR_UPDATABLE, the query must select only one t...
IDEA中对某远程MYSQL进行入表操作时，利用select结果记录集进行rs.insertRow()；却报错:java.sql.SQLException: Not on insert row.
gzgenius的博客
01-22 446
IDEA中对某远程MYSQL进行入表操作时，利用select结果记录集进行rs.insertRow();却报错:java.sql.SQLException: Not on insert row.
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值