result set type is TYPE_FORWARD_ONLY
来源:互联网 发布:php格式视频 编辑:程序博客网 时间:2024/09/21 08:52
connect=dataSource.getConnection();
Statement stmt=connect.createStatement();
ResultSet rs=stmt.executeQuery(strSql);
rs.last(); (转载)
这样写之后会报rs.last()有错,后来看到last()方法:
SQLException
- if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
后来查明原因果然是因为the result set type is
TYPE_FORWARD_ONLY,查明的具体过程是:System.out.println(rs.getType());看到打印出来的结果是1003,后到JDK的src里面查到int TYPE_FORWARD_ONLY = 1003;这句话,说明the result set type is
TYPE_FORWARD_ONLY。
那么解决办法就是要把the result set type 不要设成 TYPE_FORWARD_ONLY,后来在网上查到解决办法是:
connect=dataSource.getConnection();
Statement stmt=connect.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
ResultSet rs=stmt.executeQuery(strSql);
rs.last();
- result set type is TYPE_FORWARD_ONLY
- Result set type is TYPE_FORWARD_ONLY
- 分页显示解决Result set type is TYPE_FORWARD_ONLY
- result属性之type_forward_only
- nested exception is java.sql.SQLException: Unknown type '246 in column 1 of 3 in binary-encoded result set. 问题
- ResultSet 的Type属性 TYPE_FORWARD_ONLY, TYPE_SCROLL_I
- here is no result type defined for type 'plaintext'解决
- MySQL: Unknown type '246 in binary-encoded result set.
- result type
- result: type
- result type
- This result is a forward only result set, calling rewind() after moving forward is not supported
- 错误积累(二) There is no result type defined 错误
- Caused by: The Result type [json] which is defined in the Result annotation on the class
- struts2 配置错误There is no result type defined for type 'json'
- Struts2 错误:There is no result type defined for type 'json' mapped with name 'success'.
- There is no result type defined for type 'json' mapped with name 'success'.
- SSH 报 There is no result type defined for type 'json' mapped with name 'success'. 错
- PHP开发工具集锦-分析
- http协议中有关http头的技术资料[转载]
- eXtremeComponents的eXtremeTable分页特性
- 如何使页面不被浏览器Cache保留
- 我从编程中悟出八个字:1专 2静 3谦 4筹 5悟 6慎 7透 8恒
- result set type is TYPE_FORWARD_ONLY
- 爱情
- load average
- Shell 编程之一
- ABAP 将大量表数据写入文本
- 如何去除Visual Studio .NET工程同SourceSafe的关联
- 高性能标准里看不清楚的曙光
- 装载MXD文件 保存Mxd文档
- 年轻时所不了解的事情