users
[Top] [All Lists]

ResultSet closing prematurely

To: users@xxxxxxxxxx
Subject: ResultSet closing prematurely
From: "Jason Kretzer/STAR BASE Consulting Inc." <JKretzer@xxxxxxxxxxxxxxx>
Date: Thu, 20 May 2004 16:17:33 -0400
Delivered-to: mailing list users@cinjug.org
Mailing-list: contact users-help@cinjug.org; run by ezmlm

I have a query that returns two records and using a standard while loop, I get the records.  For some reason the loop is only entered once and then I get the exception at the bottom on the second iteration.  The exception references the while(rs.next())

Anyone know what could cause this?




ResultSet rs = stmt.executeQuery("some_query");

while(rs.next())
{
        //do something with rs
}




com.ibm.db2.jcc.b.SQLException: Invalid operation: result set closed
<Prev in Thread] Current Thread [Next in Thread>