ResultSet 的一个奇怪问题

[cnlsq]

我用的是Resin服务器，数据库是oralce，为什么我在取数据时，resultset可以next(),getString()却不能rs.last()我的程序是:
<%
Context ic = new InitialContext();
DataSource ds = (DataSource) ic.lookup("java:comp/env/jdbc/test");

Connection conn = ds.getConnection();
ResultSet rs=null;
Statement stmt;
try {
stmt = conn.createStatement();
rs = stmt.executeQuery("SELECT * FROM djadwk");
rs.last()
out.print(rs.getRow());
%><h2>Brooms:</h2>
<br>
<%
while (rs.next()) { %>
<%= rs.getString(1) %>--<%=rs.getRow()%> ;
<%= rs.getString(2) %>;
<%= rs.getString(3) %>;
<%= rs.getString(4) %>;
<%= rs.getString(5) %><br>
<%}
}catch(SQLException e ){}finally{stmt.close();}
%>

[cnlsq]

报错：
java.sql.SQLException: 对只转发结果集的无效操作: absolute
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
at oracle.jdbc.driver.BaseResultSet.absolute(BaseResultSet.java)
at _test__jsp._jspService(/test.jsp:47)
at com.caucho.jsp.JavaPage.service(JavaPage.java:74)
at com.caucho.jsp.Page.subservice(Page.java:485)
at com.caucho.server.http.FilterChainPage.doFilter(FilterChainPage.java:181)
at com.caucho.server.http.Invocation.service(Invocation.java:291)
at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:132)
at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:217)
at com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:159)
at com.caucho.server.TcpConnection.run(TcpConnection.java:136)
at java.lang.Thread.run(Thread.java:536)

[cnlsq]

怎么还是没人知道啊？

[qizi168]

是不是jdbc版本不支持？我听说过这样的。

[lolouser]

将stmt = conn.createStatement();改为
st=cnn.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY); ;
试试

[rain11er]

可能你没有贴全程序吧.
我决的你程序.
你怎么rs.last后,
怎么又rs.next,rs只能用一次,不能往前查,

[AlexHoo]

lolouser()说的对