Re: cursor "jdbc_curs_1" does not exist - Mailing list pgsql-jdbc

On Tuesday 15 June 2004 18:06, you wrote:
> The problem here is that you commit every 100 rows.  A commit closes any
> open cursors, so the next time you try to call next the cursor isn't there
> any more.

Hmm. And why does this code work then:

        for( int j = 1; row.next(); j++ )
        {
            String id = row.getString( "id" );
            URL url = new URL( row.getString( "url" ) );
            Timestamp time = row.getTimestamp( "timestamp" );

            try
            {
                insertUrls.setString( 1, id );
                insertUrls.setString( 2, url.toString() );
                insertUrls.setString( 3, resp.getText() );
                insertUrls.execute();
            }
            catch( Exception e )
            {
                System.err.println( e );
            }
            finally
            {
                if( j % 100 == 0 )
                {
                    System.out.println();
                    f4t.commit();
                }
            }
        }