各位大哥帮忙看一下这个错误:java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]ResultSet can not re-read row data
有如下代码:
Connection conn = DBPool.getConnection();
Statement stmt = conn.createStatement();
ResultSet rs = null;
String sql = " select (select kinds_name
" from newsKinds where news_kind = a.news_kind)
" as kinds_name, a.* " +
" from news a order by news_pub_date desc";
rs = stmt.executeQuery(sql);
while ( rs.next() )
{
rows++;
out.println( rs.getString("news_id") );
out.prontln( rs.getString("news_name") )
}
运行,即出现标题中的错误:
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]ResultSet can not re-read row data for column 1.
环境:
tomcat4.1.27 + sql server 2000 + windwos 2000 server
小弟在这里先谢谢了