Code:

    ResultSet fetchData2D() throws SQLException {

	Connection dbServer;

	dbServer = getConnection();

	// getting the data from the table

	Statement statement = dbServer.createStatement(ResultSet.TYPE_FORWARD_ONLY,
						       ResultSet.CONCUR_READ_ONLY);
	statement.setFetchSize(40000);

	String query = "SELECT "+getXColumnName()+","+getYColumnName()+" FROM "+getTableName()+
	    getQueryRestrictions();

	log(query);


	System.out.println("Executing query2...");

	ResultSet rset = null;
	try {
	    rset = statement.executeQuery(query);
	}
	catch (Exception e) {

	    System.out.println("exception occured..");
	    e.printStackTrace();
	    throw new SQLException(e.toString());
	}
	System.out.println("Query executed...");

	return rset;
    }

catalina.out log:

Jul 13, 2006 12:02:54 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 3030 ms
in bursh updateStyle(). getColor():green
in bursh updateStyle(). getColor():null
in bursh updateStyle(). getColor():green
in bursh updateStyle(). getColor():null
in bursh updateStyle(). getColor():null
in bursh updateStyle(). getColor():null
in bursh updateStyle(). getColor():null
in bursh updateStyle(). getColor():null
in bursh updateStyle(). getColor():null
in bursh updateStyle(). getColor():null
in bursh updateStyle(). getColor():null
Executing query2...


localhost log:

Jul 13, 2006 12:03:04 PM org.apache.catalina.core.ApplicationContext log
INFO: DataPlotter: Gotten tree from second try.
Jul 13, 2006 12:03:04 PM org.apache.catalina.core.ApplicationContext log
INFO: DataPlotter: connecting to jdbc:postgresql://stkensrv6.fnal.gov/enstore
Jul 13, 2006 12:03:04 PM org.apache.catalina.core.ApplicationContext log
INFO: DataPlotter: connected to jdbc:postgresql://stkensrv6.fnal.gov/enstore
Jul 13, 2006 12:03:04 PM org.apache.catalina.core.ApplicationContext log
INFO: DataPlotter: connecting to jdbc:postgresql://stkensrv6.fnal.gov/enstore
Jul 13, 2006 12:03:04 PM org.apache.catalina.core.ApplicationContext log
INFO: DataPlotter: connected to jdbc:postgresql://stkensrv6.fnal.gov/enstore
Jul 13, 2006 12:03:04 PM org.apache.catalina.core.ApplicationContext log
INFO: DataPlotter: SELECT * FROM encp_xfer LIMIT 1
Jul 13, 2006 12:03:04 PM org.apache.catalina.core.ApplicationContext log
INFO: DataPlotter: SELECT date,size FROM encp_xfer
Jul 13, 2006 12:03:20 PM org.apache.catalina.core.StandardWrapperValve invoke
SEVERE: Servlet.service() for servlet DataPlotter threw exception
java.lang.OutOfMemoryError: Java heap space