Increase heap size for sqlworkbench/J

java macos heap-memory sql-workbench-j
Neil picture Neil · Mar 7, 2016 · Viewed 16.1k times · Source

How do we increase heap size for SqlWorkbench/J?

I have tried different options but most of it says to execute below command :-

java -Xmx4g -jar sqlworkbench.jar

Even on http://www.sql-workbench.net/manual/install.html#install-increase-memory , it provides me this solution.

Now, I am using macbook. So I have sqlworkbench.app file only. I neither have any .ini file or .jar file for sqlworkbench.

So, how do increase memory size?

Answer

Amy123 picture Amy123 · May 5, 2016

I could not find the info.plist file any where in the application folder on my Macbook pro. When I searched for Info.plist, I could find only the Microsoft Office related one.

I right clicked the sql workbench J icon on the desktop, and selected Show package contents. I could finally find the Info.plist file there!! I changed the heap size there from 512mb to 4096 mb. 

<string>-Xmx4096m</string>

Related questions

How to install Java 8 on Mac

I want to do some programming with the latest JavaFX, which requires Java 8. I'm using IntelliJ 13 CE and Mac OS X 9 Mavericks. I ran Oracle's Java 8 installer, and the files look like they ended up at /Library/Java/JavaVirtualMachines/jdk1.8.0_05.…

Read More
How to set or change the default Java (JDK) version on OS X?

How can you change the default version of Java on a mac?

Read More
Where is Java Installed on Mac OS X?

I just downloaded Java 7u17 on Mac OS 10.7.5 from here and then successfully installed it. In order to do some JNI programming, I need to know where Java installed on my Mac. I thought that inside the /Library/Java/JavaVirtualMachines/ …

Read More