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();
}
}
}