Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Adobe Summit 2023 [19th to 23rd March, Las Vegas and Virtual] | Complete AEM Session & Lab list

Populating 100K rows in Advanced Data Grid from LCDS

Avatar

Level 1

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;

1 Reply

Avatar

Employee

You should try to setup a Data Management architecture.

The tag <mx:DataServices> will help you to activate data-paging and handle your memory issue.