CallabaleStatement and ResultSet

If you close your statement, I think your ResultSet becomes unusable

Typical code is:

try {
            XXXStatement statement = getConnection().prepareStatement(...);
            try {
                ...
                ResultSet rs = statement.executeQuery();
                try {
                    while (rs.next()) {
                        ...
                    };
                } finally {
                    rs.close();  // First close your ResultSet
                }
            } finally {
                statement.close();  // then your statement
            }

Thanks for the confirmation ;°)

Argh, forgot to refresh first
:-)

No problem. That way the author can be sure ;°)

melchkishore, imo a points split would have been fair.

Hi, back from vacation today - I'd agree, points split would have been fair.
Cheers,
C.

Thanks cliff.