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?
Thanks
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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?
Kind regards
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
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?
Thanks
You can call the eclipse binary from command line and use the -vmargs -Xmx<memory size> paremeters.
For detailed informations look here:
http://help.eclipse.org/helios/index.jsp?topic=%2Forg.eclipse.platform.doc.user%2Ftasks%2Frunning_eclipse.htm
If you don't have an eclipse.ini you can create one. Look here for informations where to find eclipse.ini:
http://wiki.eclipse.org/Eclipse.ini
Hi,
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?
Kind regards
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.