clickhouse jdbc读取批量数据报java.io.IOException: Attempted read on closed stream

最新推荐文章于 2024-10-07 15:48:38 发布

ibingley

最新推荐文章于 2024-10-07 15:48:38 发布

阅读量945

点赞数

分类专栏： java 文章标签： java clickhouse mysql

本文链接：https://blog.csdn.net/chenhuabin2011/article/details/129018791

版权

java 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

java.io.IOException: Attempted read on closed stream

原因是 ResultSet 数据读取完成之前已经把 ClickHousePreparedStatement 关闭。

public ResultSet QueryResultSet(Connection connection, String sql, String[] params) {
ResultSet rst=null;
ClickHousePreparedStatement pst=null;
if (connection==null) {
System.out.println("connection is empty");
System.exit(-1);
}
try {
pst= (ClickHousePreparedStatement) connection.prepareStatement(sql);
if (params!=null)
for (int i = 0; i < params.length; i++) {
pst.setObject(i+1,params[i]);
}
rst = pst.executeQuery();

} catch (SQLException throwables) {
throwables.printStackTrace();
}finally{
close(pst,connection);
}
return rst;
}

需要调整代码为

public ResultSet QueryResultSet(Connection connection,ClickHousePreparedStatement pst, String sql, String[] params) {
ResultSet rst=null;

if (connection==null) {
System.out.println("connection is empty");
System.exit(-1);
}
try {
pst= (ClickHousePreparedStatement) connection.prepareStatement(sql);
if (params!=null)
for (int i = 0; i < params.length; i++) {
pst.setObject(i+1,params[i]);
}
rst = pst.executeQuery();

} catch (SQLException throwables) {
throwables.printStackTrace();
}finally{

}
return rst;
}

然后调用该方法后用

Connection conn1 =null;
ClickHousePreparedStatement pst=null;
ResultSet resultsll =null;

try

{

}catch

{

}

finally
      {
          ClickHouseDaoUtils.closeClickhouse(resultsll,pst,conn1);
      }