On Mon, 15 Jan 2007, Havard Tveite wrote:
> I have experienced problems using the JDBC type 2 and type 3
> drivers for 8.1 (postgresql-8.1-408.jdbc3.jar,
> postgresql-8.1-408.jdbc2.jar) against PostgreSQL 8.1.5.
>
Are you sure it's complaining that stmt is closed. This coding clearly
looks like the problem will be with stmtchk as you close it in the loop,
but then continue using it.
> Statement stmtchk = conn.createStatement();
> while (rs.next()) {
> ResultSet rsch = stmtchk.executeQuery(checkquery);
> stmtchk.close(); // leads to the closing of stmt!!!
> }
>
Kris Jurka