Question

I m 存在问题。 ResultSet, I have a java.sql.PreparedStatement on which Iîcut Query() to re a Resultery 然而,当我试图从Im的提问中取得结果时,我却被抛出一个例外:

Exception: java.sql.SQLException Message: Operation not allowed after ResultSet closed.

从网上搜索看,它就看着一种结果。由于以下几个原因,最终可以关闭:

The PreparedStatement object that generated it is closed.
The PreparedStatement object that generated it is re-executed.
The PreparedStatement object that generated it is used to retrieve the next result from a sequence of multiple results.
Closing the Connection which was used to generate the PreparedStatement.

I checked my code and do none of those things. Below is a snippet of the code that causes the problem:

PreparedStatement psAccountPartyIdByEmail = null;
....
try {
    String [] nextLine;
    while ((nextLine = reader.readNext()) != null) {
        String email = nextLine[0];
        .....
        try {
            if (psAccountPartyIdByEmail == null) {
                psAccountPartyIdByEmail = session.connection().prepareStatement(SQL_GET_ACCOUNTPARTYID_BY_EMAILADDRESS);
            }

            psAccountPartyIdByEmail.setString(1, email);
            ResultSet partyIds = psAccountPartyIdByEmail.executeQuery();

            while (partyIds.next()) {
               String partyId = partyIds.getString(1);
                .....
            }
        } catch (SQLException e) {
            Debug.logError(e, "Encountered SQLException while running group service.", MODULE);
        }
    }
} catch (IOException e) {
    Debug.logError(e, "Problem reading line in file", MODULE);
}

在试图执行时,除外:while (Part Ids.next())){

同我一样,我从未结束联系或发言,因为你在试图看到我的结果之前,不能再重复发言。

感谢......

页: 1

Answer 1

我不知道这是否会解决这个问题,但你能够/应该采取行动。

if (psAccountPartyIdByEmail == null) {
            psAccountPartyIdByEmail = session.connection().prepareStatement(SQL_GET_ACCOUNTPARTYID_BY_EMAILADDRESS);
        }

outside of the while loop. Also, close the ResultSet after you ve processed the rows. Then, when you re all done close your statement and connection.

友情链接