JDBC Heap space error
JDBC Heap space error
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?
Re: JDBC Heap space error [RESOLVED]
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...)
- DrewJensen
- Volunteer
- Posts: 1734
- Joined: Sat Oct 06, 2007 9:01 pm
- Location: Cumberland, MD - USA
Re: JDBC Heap space error
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
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
Former member of Apache OpenOffice PMC
LibreOffice on Ubuntu 18.04
Re: JDBC Heap space error
Thanks, but I knew that; the question was how to get Base to use those options. As my previous post related, I found that.
- DrewJensen
- Volunteer
- Posts: 1734
- Joined: Sat Oct 06, 2007 9:01 pm
- Location: Cumberland, MD - USA
Re: JDBC Heap space error
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
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
Former member of Apache OpenOffice PMC
LibreOffice on Ubuntu 18.04