JDBC Heap space error

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER
Post Reply
User avatar
ignatz
Posts: 3
Joined: Sat Mar 22, 2008 3:50 am

JDBC Heap space error

Post by ignatz »

The JDBC Connector works fine with MySQL under Windows...except for moderately large tables. If you try to simply open such a table for browsing, Base returns an error complaining the data content could not be loaded, and indicates a Java heap error. Within the Base setup for the MySQL JDBC connector, how can I increase the heap space?
User avatar
ignatz
Posts: 3
Joined: Sat Mar 22, 2008 3:50 am

Re: JDBC Heap space error [RESOLVED]

Post by ignatz »

Ok, working on this I found the CLI option -Xmx<max size>. If you go to Tools->Options, Java, you can add options to the configuration for a Java execution environment. In this case, I added -Xmx384m to set the max heap size to 384 Mb. There are values that fail--they're accepted by Base, but result in a failure to run the execution environment, e.g., "-Xms128m -Xmx768m" wasn't accepted. I haven't found either the docco for what valid ranges are, or seen anything in a quick Google. But at least this problem has a resolution. (Now if only I didn't have to set the Java preferences on each and every workstation...)
User avatar
DrewJensen
Volunteer
Posts: 1734
Joined: Sat Oct 06, 2007 9:01 pm
Location: Cumberland, MD - USA

Re: JDBC Heap space error

Post by DrewJensen »

It isn't the Base documentation you want to look at it is the Java documentation.

Those are command line parameters to the java environment - if you are using SUN java ( jre ) then maybe this page will be of help
http://java.sun.com/performance/referen ... uning.html
Former member of The Document Foundation
Former member of Apache OpenOffice PMC
LibreOffice on Ubuntu 18.04
User avatar
ignatz
Posts: 3
Joined: Sat Mar 22, 2008 3:50 am

Re: JDBC Heap space error

Post by ignatz »

Thanks, but I knew that; the question was how to get Base to use those options. As my previous post related, I found that.
User avatar
DrewJensen
Volunteer
Posts: 1734
Joined: Sat Oct 06, 2007 9:01 pm
Location: Cumberland, MD - USA

Re: JDBC Heap space error

Post by DrewJensen »

Ok - Sorry,

You tell OpenOffice.org about java parameters in the Options dialogs:

Tools > Options ( Under OpenOffice.org ) java
Click on the button for Parameters
Former member of The Document Foundation
Former member of Apache OpenOffice PMC
LibreOffice on Ubuntu 18.04
Post Reply