1. Squirrel Sql Client
2. Squirrel Sql Make Editable

Question or issue on macOS:

We are using it with Oracle, MS SQL Server and probably soon PostgreSQL. Currently we are five people in our department using it regularly. Having some users stuck on old Office versions, we extract a lot of (summarized) data into XLS files. Pasting large SQL scripts into the editor can be quite slow. Squirrel.Mac Cocoa framework for updating OS X apps. Objective-C MIT 128 1,358 48 3 Updated Nov 3, 2020. NuGet Forked from anaisbetts/NuGet A fork.

I’m running SQuirreL SQL (2.6.8) on Max OS X.

I’m running out of heap space when trying to create a Table script.

Squirrel Sql Client

How to configure SQuirreL SQL to start up with a higher JVM heap size?

How to solve this problem?

Solution no. 1:

Assuming you have the SQuirreL in your Dock you can do following:

2. Cmd-Click on the SQuirreL icon in the Dock, the Finder window will open showing the you the application.
3. Left-Click on the SQuirreL Application and choose “Show package contents”
4. Navigate into Contents folder and open Info.plist file
5. Change or add following to your Info.plist file:

Java

VMOptions
-Xms128m
-Xmx512m

Here you get 128M at the start time with maximal SQuirreL.

Save the Info.plist file and restart the application.

Solution no. 2:

I’m running Linux, so you’ll have to adapt this answer somewhat, but it should be applicable.

In the home directory that the installer jar creates, you’ll find a file called “squirrel-sql.sh”. The last line of this file is the java launch cmd. Not sure about the mac launch configuration, you might need to look for the file in this directory that contains this line. Mine reads

The -Xmx256m configures the heap – it sets the max heap size to 256m. Just edit the file to read -Xmx512m or whatever. (for a list of the memory flags, type “java -X” at a command prompt).

Solution no. 3:

SQuirreL SQL Client Version 3.7 – Windows

I had the following popup:

The query results have exceeded the maximum amount of memory allocated to this application. All result tabs have been closed to allow you to save your work and restart the application.

and the following message in console (Error tab):

java.lang.OutOfMemoryError: GC overhead limit exceeded
Position: 0

Solution

Squirrel Sql Make Editable

1. Right click on the SQuirreL icon > Properties

2. Copy the Target value

3. Open that .bat file in an editor and replace -Xmx256m with -Xmx1024m:

4. Save and open again SQuirreL SQL.

Solution no. 4:

Thank you this helped me, at first I edited the squirrel-sql.bat file from -Xmx256m to --Xmx1024m but that didn’t work, so I changed it to –-Xmx4096m and it worked.

Solution no. 5:

I was facing this situation on the Windows 8 Pro machine and i located this file squirrel-sql.sh on the root folder and edited the following args:

-Xmx256m to –Xmx4096m

it has resolved my issue altogether….!

Hope this helps!