mysql fetchsize默认值,结果集中的fetchsize默认设置为0

I have to query a database and result set is very big. I am using MySQL as data base. To avoid the "OutOfMemoryError" after a lot of search I got two options: One using LIMIT(specific to database) and other is using jdbc fetchSize attribute.

I have tested the option 1(LIMIT) an it is working but it is not the desired solution. I do not want to do it.

Using jdbc I found out that ResultSet size is set to 0 by default. How can I change this to some other value. I tried the following:

a) First Try:

rs = preparedStatement.executeQuery();

rs.setFetchSize(1000); //Not possible as exception occurs before.

b) Second T Even if this is not there then also I need to communicate to databse multiple timry:

rs.setFetchSize(1000); //Null pointer exception(rs is null).

rs = preparedStatement.executeQuery();

c) Third Try: