Matlab2012b gives memory error when loading SQL data.

Question

Barry Dillon 2012-10-17

1
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/51127-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.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Sean de Wolski 2012-10-17

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/51127-matlab2012b-gives-memory-error-when-loading-sql-data#answer_62305

在 MATLAB Online 中打开

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.

2 个评论
显示无隐藏无

Barry Dillon 2012-10-18

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 2012-10-18

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

请先登录，再进行评论。

Answer 2

Bobby 2013-4-5

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/51127-matlab2012b-gives-memory-error-when-loading-sql-data#answer_81154

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