Re: NullPointer error returned from ResultSet.java

On Friday, October 11, 2002, at 06:14 AM, Dave Cramer wrote:

> Jeff,
>
> Can you show me how the statements are being created? I was partially
> correct, you can't have multiple result sets open on the same
> statement.
>
Dave,

  Before I enter the first block, I predeclare all Statements and
ResultSets that will be used like so:

Statement stmt   = conn.createStatement();
Statement stmt2  = conn.createStatement();
Statement stmt3  = conn.createStatement();
ResultSet rs, rs2, rs3;

  I know you can't have many RS's per statement, but I'm very sure that
I am not attempting to do that. As I said before, this only seems to
happen when I have an executeUpdate call from within a nested rs.next()
loop, but it's definitely not the same statement object, which is why
it's puzzling.

Jeff