Please explain the limitations of getting data out of teradata using sql

Error using cursor/fetch (line 283) Java exception occurred: java.lang.OutOfMemoryError: Java heap space

at java.util.Arrays.copyOf(Unknown Source)

at java.util.Vector.grow(Unknown Source)

at java.util.Vector.ensureCapacityHelper(Unknown Source)

at java.util.Vector.addElement(Unknown Source)

at com.mathworks.toolbox.database.fetchTheData.dataFetch(fetchTheData.java:666)

Error in loadPrepaymentData (line 36) cursor = fetch(cursor);

[Geoff Hayes]

Alex - you may want to show some of the code (and in particular the query) that you are using when the above is generated. What is the version of MATLAB that you are using? What are the expected number of records being returned from your SQL query?

Answer 1

[per isakson]

Take a chance and increase the heap. See Java Heap Memory Preferences