1 Reply Latest reply on Aug 25, 2009 1:31 AM by MichaelChaize

    Populating 100K rows in Advanced Data Grid from LCDS

    rgaurava

      I have an Oracle database with 100K rows that I need to populate a AdvancedDataGrid. I have setup my RemoteObject to point to an destination which invokes a java class to return the values. The Java class makes the jdbc connection and creates a List of Maps and retuns the value back.

       

      The problem I am facing is that the code throws an "out of memory" after 2K of data. Any idea on what parameters to configure or is there a better way to do this?

       

      Thanks,

      rgaurava

       

      List list =

      new ArrayList();

      Map testResult;

       

       

      while (rs.next()) {

       

       

      testResult =

      new HashMap();

      testResult.put(

      "STRING1", rs.getString("STRING1"));

      testResult.put(

      "STRING2", rs.getString("STRING2"));

      testResult.put(

      "STRING3", rs.getString("STRING3"));

      list.add(testResult);

       

      }

       

       

       

       

      return

       

       

       

       

      list;