java.sql.SQLException: ResultSet is closed

最新推荐文章于 2021-02-26 06:37:43 发布

逍锅锅_

最新推荐文章于 2021-02-26 06:37:43 发布

阅读量4.4k

点赞数 1

分类专栏： mysql 文章标签： jdbc sparkstreaming

本文链接：https://blog.csdn.net/yx_keith/article/details/80338809

版权

mysql 专栏收录该内容

7 篇文章 0 订阅

订阅专栏

自定义连接池将mysql和spark-streaming进行集成，连接池JDBCWrapper类中的doQuery()方法如下：

public ResultSet doQuery(String sqlText) {

    Connection conn = getConnection();
    PreparedStatement preparedStatement = null;
    //Boolean bool = null;
    ResultSet rs = null;

    try {
        preparedStatement = conn.prepareStatement(sqlText);
        rs = preparedStatement.executeQuery();

    } catch (Exception e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    } finally {
        if (preparedStatement != null) {
            try {
                //关闭preparedStatement的同时也关闭了resultSet
                preparedStatement.close();
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }
        if (conn != null) {
            try {
                connectionPool.put(conn);
            } catch (InterruptedException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }
    }
    return rs;
}

然后在spark-streaming中调用，并将查询结果打印出来：

ResultSet rs = jdbcWrapper.doQuery("select * from region_count");
while (rs.next()) {
    String region = rs.getString(1);
    int count = rs.getInt(2);
    System.out.println(region+","+count);
}

此时运行就会报错java.sql.SQLException: ResultSet is closed

因为在doQuery()方法中，PreparedStatment关闭后就把 ResultSet也关了，所以doQuery()方法不应该返回ResultSet，修改后如下：

public void doQuery(String sqlText) {

    Connection conn = getConnection();
    PreparedStatement preparedStatement = null;
    //Boolean bool = null;
    ResultSet rs = null;

    try {
        preparedStatement = conn.prepareStatement(sqlText);
        rs = preparedStatement.executeQuery();
        while (rs.next()) {
            String region = rs.getString(1);
            int count = rs.getInt(2);
            System.out.println(region+","+count);
        }
    } catch (Exception e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    } finally {
        if (preparedStatement != null) {
            try {
                //关闭preparedStatement的同时也关闭了resultSet
                preparedStatement.close();
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }
        if (conn != null) {
            try {
                connectionPool.put(conn);
            } catch (InterruptedException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }
    }