Matlab2012b gives memory error when loading SQL data.

1 次查看（过去 30 天）
Barry Dillon
Barry Dillon 2012-10-17
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.

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

采纳的回答

Sean de Wolski
Sean de Wolski 2012-10-17
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
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
Sean de Wolski 2012-10-18
Yes it does use more Java Memory since there's more UI stuff going on.

请先登录，再进行评论。

更多回答（1 个）

Bobby
Bobby 2013-4-5
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

类别

在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

产品

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by