> i believe that when you close the stmt, the rs is automatically
> closed. you have to leave the stmt open until you're done with the
> rs.
Exactly. If you read the Java documentation for interface
java.sql.Statement, method close(), it tells you the Resultset, if any,
also is closed on that call. PreparedStatement extends Statement,
CallableStatement extends PreparedStatement.
It's important to notice that the Postgres implementation of Resultset
et al is meant to work as described in the standard Java documentation;
that's the whole point of the interfaces. Thus a lot of these questions
can be answered by carefully reading through the standard Java
documentation.
Yours,
///Jens Carlberg