Hi,

In the following simplified code the line stmt = rset.getStatement() doesn't return the PreparedStatement I would like to close (but returns a unknown statement).
So I'm getting the freezing warning "Closing a statement you left open, please do your own housekeeping" when executing conx.close(), since I didn't close the PreparedStatement.
Executing pstmt.close() within the finally blocks effectively close the PrepareStatement, but I wouldn't like to do that since all our code has been writen using the ElementosConexao.fecharResultSet() method in order to do so.
Is it legal to execute in Java stmt = rset.getStatement() in order to get a PreparedStatement, or is it a JBoss or Informix (since we're using it) issue?
Thanks a lot.

try {
pstmt = conx.prepareStatement(...);
pstmt.setInt(1, ...);
pstmt.setString(2, ...);
rset = pstmt.executeQuery();
}

finally {
ElementosConexao.fecharResultSet(rset, true);
conx.close();
}


public static void fecharResultSet(ResultSet rset, boolean fecharStatement){
Statement stmt = null;

if (fecharStatement) {
stmt = rset.getStatement();
}
rset.close();
stmt.close();
}