Jeff,
Can you supply me with a test case, and I can debug the driver and see
what is going on?
Dave
On Fri, 2002-10-11 at 08:35, Jeffrey Duffy wrote:
>
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
>