Hi All, I have wriiten a query which will fetch records more than 2 lakhs. and i have written the code as PreparedStatement pstmt = connection.prepareStatement("select * from BIG_TABLE where col1=?"); pstmt.set.... pstmt.executeQuery();
When i execute this code am getting java.lang.OutOfMemoryError: Java heap space I get this exception when the code executes executeQuery().
Can anyone provide me a solution ? Thanks in advance