Increasing Java heap space for Base on Mac 10.6

[dhs56]

Base keeps giving me a Java Heap Space error. Specifically “The data content could not be loaded. Java heap space”

I’ve tried increasing the memory under preferences without success.

I’ve also tried using the standard approach using the -Xms512m and -Xmx1024m parameters to specify the minimum and maximum. This causes LO to crash. Removing the ‘m’ post fix and only using -Xms1024 removes the crash but doesn’t eliminate the Java heap issue.

Context:

• Database is on a remote server (Amazon)
• Connection made because I can access other tables within the database
• But the largest table (330,000 records), gives me the Java heap message

My colleagues use Mac’s and wish to be able to see the data in the various tables without resorting to Excel (UTF-8 issues and maximum size in Excel). Since they are none technical, phpMyAdmin is problematic. And there is no Access for Mac’s of course.

Any suggestions?

Thanks,

David

[iplaw67]

Hi,

I could only find this other information so far, don’t know whether it will solve your problem, but 330,000 tuples (how many objects per tuple ?) over a Cloud connection and a JDBC driver with LO on Mac is not exactly the most robust of setups that you could be using…this has more to do with LO/Java instability than anything else.

http://openoffice.2283327.n4.nabble.com/Java-heap-space-td2788890.html

http://www.mail-archive.com/users@dba.openoffice.org/msg04566.html

[qubit1]

Hi @dhs56,

If installing the latest release doesn’t seem to fix this heap-space problem, please file a bug and provide a list of steps that can reproduce your problem.

Please post a link to any bugs you file in a comment below using the format “fdo#123456”.

Thanks!