Hello all.



I am attempting to use setFetchSize to avoid an "out of memory" condition.



(512M ram)

28 column table, all VARCHAR (35) or less, name, address, and so forth



Here's the code where I think I should setFetchSize.



// connect to database with user and password

connection = DriverManager.getConnection( url, user, password );



// create Statement to query database

statement = connection.createStatement(

resultSet.TYPE_SCROLL_INSENSITIVE,

resultSet.CONCUR_READ_ONLY );



statement.setFetchSize(10);



(code deleted)



// specify query and execute it

resultSet = statement.executeQuery( query );



System.out.println( "resultSet worked" );







It never reaches the println statement.



WHAT am I doing wrong here?



Thanks.



Hugh Purcell





[Non-text portions of this message have been removed]