JDBC.SQLServerException:结果集没有当前行

本文介绍了JDBC.SQLServerException:结果集没有当前行的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

因此，我创建的解决方案引发了以下异常:jdbc.SQLServerException: The result set has no current row在以下代码中标记的行上.

So, a solution I created threw this exception: jdbc.SQLServerException: The result set has no current row on the line marked in the below code.

public String get64BitEncodedImageBySiteID(int siteID){
    try {
        Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
        Connection conn = DriverManager.getConnection(url, userName, password);

        Statement stmt = conn.createStatement();
        ResultSet rs = stmt.executeQuery( "SELECT SitePicture FROM SiteTable WHERE SiteID ="+siteID );

        rs.next();
        // The above line has since been moved to the if statement below where you can see it commented out,
        // which prevents the exception from occuring but still doesn't fix the fact that the row is not being found.

        if(/*rs.next() &&*/ rs.getBytes("SitePicture")!=null){ // EXCEPTION THROWN HERE!
            byte ba[] = rs.getBytes("SitePicture");
            return new sun.misc.BASE64Encoder().encodeBuffer(ba);
        }
        else {return null;}
    } catch (Exception ex) {
        ex.printStackTrace();
    }
    return null;
}

在抛出异常的情况下，上述方法从直接从同一表中提取的Entity对象中获取真实的siteID(22379).在此方法中使用System.out.println(siteID);时，它声明该数字仍然正确，即仍然为22379.我已经通过在SQL Server中运行相同的语句直接与SQL Server进行了核对，因此我知道表中存在该行，但由于某种原因未找到它.下图.

The method above, in the instance the exception was thrown, is taking a genuine siteID (22379) from an Entity object pulled directly from the same table. When using System.out.println(siteID); during this method, it declared that number to still be correct, ie still 22379. I've checked directly with the SQL server by running an identical statement in SQL Server, so I know the row exists in the table, but for some reason it is not being found. Image below.

所以问题是，即使我知道它在那里，ResultsSet rs也没有找到该行.有人对您有帮助吗?

So the problem is, the ResultsSet rs is not finding the row even though I know that it's there. Does anyone have any helpful insights?

澄清:请明确一点，我知道ResultsSet不包含任何行，这就是为什么我得到异常的原因.我也知道将rs.next()放入if语句将防止异常(如注释中所述).令我感到困惑的是，即使确实有ID被可解析地解析的行，结果集也不包含任何行，因为我已经直接通过SQL Server对其进行了检查.

ResultsSet

JDBC.SQLServerException:结果集没有当前行

问题描述

推荐答案