SQLException：此结果集已关闭

本文介绍了SQLException：此结果集已关闭的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我正在尝试比较三个 Resultset 中的值，但是似乎有例外，我尝试运行它。 有人可以帮我解决问题所在。我将不胜感激。这是引发错误的代码段：

I am trying to compare values from three Resultset, but there seems to exception wen I try to run it. Could someone help me on where am going wrong. I will appreciate any help. Here's the code snippet that's throwing the error:

java.sql.Connection connDB = null; java.lang.Object[] reconciledPaymentDetails = null; java.util.Vector shiftsVector = new java.util.Vector(1, 1); String status = ""; try { Class.forName("org.postgresql.Driver"); } catch (ClassNotFoundException ex) { Logger.getLogger(DBConnection.class.getName()).log(Level.SEVERE, null, ex); } try { connDB = DriverManager.getConnection("jdbc:postgresql://" + hostName + ":" + portNumber + "/" + dbName, userName, password); System.out.println("Connection established : [" + connDB.toString() + "]"); java.sql.Statement pstmt = connDB.createStatement(); java.sql.Statement pstmtShifts = connDB.createStatement(); java.sql.ResultSet rset = pstmt.executeQuery("SELECT DISTINCT payment_mode, transaction_type, credit FROM ac_cash_collection WHERE shift_no = '" + shiftNumber + "'"); while (rset.next()) { java.sql.ResultSet rsetShifts = pstmtShifts.executeQuery("SELECT DISTINCT amount, shift_amount FROM ac_shift_collections WHERE shift_no = '" + shiftNumber + "' AND pay_mode ilike '"+rset.getString(1) +"'"); while (rsetShifts.next()) { java.sql.ResultSet rset2 = pstmt.executeQuery("select debit from ac_cash_book where shift_no='"+shiftNumber+"'"); while (rset2.next()){ double debit =rset2.getDouble("debit"); if((rset2.getDouble("debit")<=0 )) status = "no_banked"; else if((rset2.getDouble("debit")==rsetShifts.getDouble("amount")) && (rsetShifts.getDouble("amount"))< rsetShifts.getDouble("shift_amount")) status= "BntClosed"; else if (rset2.getDouble(1)==rsetShifts.getDouble("shift_amount")) Status ="bClosed"; shiftsVector.addElement(rset.getString(1)+":"+rsetShifts.getString(1)+":"+status); } } }

推荐答案

java.sql.ResultSet rset = pstmt.executeQuery("SELECT DISTINCT payment_mode, transaction_type, credit FROM ac_cash_collection WHERE shift_no = '" + shiftNumber + "'"); java.sql.ResultSet rset2 = pstmt.executeQuery("select debit from ac_cash_book where shift_no='"+shiftNumber+"'");

第二个调用释放了第一个调用生成的资源，这就是ResultSet被关闭的原因。

Your second call releases the resources generated by the first one, that's why the ResultSet is closed.