Re: [cinjug-users] ResultSet closing prematurely

[Scott T Weaver <sweaver@xxxxxxxxxxxxxxx>]

Something may be happening your jdbc connection.  For debugging sake,
why don't you check on each iteration if your connection is still open.


On Thu, 2004-05-20 at 16:17, Jason Kretzer/STAR BASE Consulting Inc.
wrote:
> 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
-- 
******************************************
*           Scott T. Weaver              *
*         <weaver@xxxxxxxxxx>            *
*     <http://www.einnovation.com>       *   
* -------------------------------------- *
*   Apache Jetspeed Enterprise Portal    *
*     Apache Pluto Portlet Container     *
*                                        *
* OpenEditPro, Website Content Mangement *
*     <http://www.openeditpro.com>       *
******************************************