Re: [Squirrel-sql-users] Allocate 20GB memory to SQuirreL

[Alexandre P. <Ale...@ei...>]

You can’t allocate more memory that you physically have, or that can be addressed in the corresponding addressing model (i.e., no more than 4 GB in 32 bit JVM).

--
Alexandre Peshansky, MS
Lead Bioinformatics Analyst, Research Informatics Core (RIC)
Harold & Muriel Block Institute for Clinical & Translational Research at Einstein and Montefiore
Albert Einstein College of Medicine
1300 Morris Park Ave, Block Bldg., Rm 534 Bronx, NY 10461
(914) 294-6916 (office) (201) 970-3530 (cell)
[cid:image001.png@01D42360.1ED44F50]

From: Jonas BUNSEN [mailto:bu...@gr...]
Sent: Tuesday, July 24, 2018 10:04 AM
To: squ...@li...
Subject: [Squirrel-sql-users] Allocate 20GB memory to SQuirreL

I am using SQuirreL 3.8.1 on Windows 10. If I open large tables I receive the following error.

“Error occurred during task execution: Java heap space”

Apparently, this has something to do with the memory that is allocated to my SQuirreL installation. Therefore, I changed `-Xmx256M` in the `squirrel-sql.bat` file to `-Xmx1024M`.

    start "SQuirreL SQL Client" /B "%LOCAL_JAVA%" -Xmx1024M -Dsun.awt.nopixfmt=true -Dsun.java2d.noddraw=true -cp %CP% -splash:"%SQUIRREL_SQL_HOME%/icons/splash.jpg" net.sourceforge.squirrel_sql.client.Main %TMP_PARMS%


However, I still receive the same error and if I increase the allocated memory even more (e.g. `-Xmx26624M`) SquirreL will not start anymore.

> Error: Could not create the Java Virtual Machine.

> Error: A fatal exception has occured. Program will exit.

How can I allocate 26624 MB memory to my SQuirreL installation. I guess it has something to do with Java 32/64 bit!?

Thanks