I tried to extract 1.2 millions records out of 9 tables in three databases on the same server.
Unfortunately, after ten minutes the query fails and I got following error message: java.lang.OutOfMemoryError: Java heap space
Running the same query works when limiting the output of records by 100'000!
That means the syntax of the query is correct
In the internet, I found the advice to add -Xmx512M to the file Eclipse.ini, but there is no such file.
What can I do?
You can call the eclipse binary from command line and use the -vmargs -Xmx<memory size> paremeters.
For detailed informations look here:
If you don't have an eclipse.ini you can create one. Look here for informations where to find eclipse.ini:
thanks a lot for your helpful information. In fact, I discovered that the ini file on my pc is sqlexplorer.ini when I saw your syntax for eclipse.ini. I have put the maximum to 1024m, sql explorer didn't accept more like 1536m or 2048m. But anyway the query I have huild didn't work either. As I ran it the first time after having increased the memory / heap space, it was still running after 2 hours and unfortunately I had to stopp the query. When I tried a second time, I got the same error message again after ten or fifteen minutes. So it looks like that there is no way to make the query running for 1.2 million records.
What d you think?
Yes, for the standalone version of SQL Explorer the ini is sqlexplorer.ini.
And the standalone version uses the bundled JVM which is a 32Bit JVM and you are using Windows, right?
On Windows with 32Bit JVM user space is limitted to round about 1,5GB.
So if you have a 64Bit Win OS with a 64 Bit JVM installed, try to rename the jre directory under sqlexplorer (or move it away) and then try to increase max heap size.
Log in to post a comment.
Sign up for the SourceForge newsletter:
You seem to have CSS turned off.
Please don't fill out this field.