Subject setFetchSize
Author Hugh Purcell
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(




(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?


Hugh Purcell

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