java.sql.SQLException: [Microsoft][ODBC 驱动程序管理器] 无效的游标状态

[daanhan]

<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="java.sql.*"%>
<%
String driver="sun.jdbc.odbc.JdbcOdbcDriver";
Class.forName(driver).newInstance();
String connectionURL="jdbc:odbc:mydb";
Connection con=DriverManager.getConnection(connectionURL);
Statement stmt=null;
stmt=con.createStatement();
ResultSet rs=null;

String sqlstr="select * from admin";
rs=stmt.executeQuery(sqlstr);
out.println(rs.getString(1));
out.println("<br>");

%>

500 Servlet Exception
java.sql.SQLException: [Microsoft][ODBC 驱动程序管理器] 无效的游标状态
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6879)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7036)
at sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(JdbcOdbc.java:3862)
at sun.jdbc.odbc.JdbcOdbcResultSet.getDataString(JdbcOdbcResultSet.java:5561)
at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:338)
at _cksql__jsp._jspService(/cksql.jsp:14)
at com.caucho.jsp.JavaPage.service(JavaPage.java:75)
at com.caucho.jsp.Page.subservice(Page.java:506)
at com.caucho.server.http.FilterChainPage.doFilter(FilterChainPage.java:182)
at com.caucho.server.http.Invocation.service(Invocation.java:315)
at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135)
at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:246)
at com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:163)
at com.caucho.server.TcpConnection.run(TcpConnection.java:139)
at java.lang.Thread.run(Thread.java:536)


--------------------------------------------------------------------------------
Resin 2.1.9 (built Tue Apr 15 14:28:40 PDT 2003)

[acefr]

while(rs.next())
{
out.print(rs.......);
}