Matlab2012b gives memory error when loading SQL data.

I am moving from 2010a to 2012b and for a given database I could retrieve 100k records in 2010a but get Java memory error in 2012a at 100k records. Java exception occurred: java.lang.OutOfMemoryError: Java heap space at java.util.Arrays.copyOf(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:638) I am using sqljdbc4.jar to access SQL. Is there some other trick with 2012b ?

thanks for any help.

Answer 1

[Sean de Wolski]

If you're on a 64bit system I highly recommend bumping your Java Heap Space up a fair amount for R2012b. On Win7 8Gb of RAM I have it set to 1000ish.

Home->Preferences->General->Java Heap Memory->Adjust it, apply and restart MATLAB.

[Barry Dillon]

Thanks that sorted the problem. I guess 2012b must use more memory than 2012a as the problem didn't arise with earlier version or maybe it had a larger default setting for the heap. I was almost being forced to revert to R which I didn't want to do. thanks.

[Sean de Wolski]

Yes it does use more Java Memory since there's more UI stuff going on.

Answer 2

[Bobby]

You may get rid of the error owing to fix mdf files

http://www.fixmdffiles.sqlmdffix.com analyzes the internal structure of SQL databases and retrieves affected data even after serious data corruption problems