java.lang.OutOfMemoryError: Java heap space

[carina caoor]

Hi, i am creating an xlsx file with more that 100000 rows.

public class Exelim extends HttpServlet {
				
		private static final long serialVersionUID = 1L;
		
		
		
		//private static final long serialVersionUID = 1L;
		@SuppressWarnings("deprecation")
		public void doGet(HttpServletRequest request,
	            HttpServletResponse response)throws IOException, ServletException
	{
			response.setCharacterEncoding("UTF-8");
			OracleDatabaseConnection d;
			Connection connection=null;
			Statement stmt;
			ResultSet rs=null;
			int j=1;
	            PrintWriter out=response.getWriter();
	            String Error="Error:";
	            FileOutputStream fos = null;
	            Workbook wb = null;
	            try
	    		{
	            	                                 d= new OracleDatabaseConnectionPROD();
	    	   		 connection=d.connect();
	    	   		 stmt = connection.createStatement();
	    	     	                 connection.setAutoCommit(false);
	    	   		 wb = new XSSFWorkbook();  
	    	   		 int k=1,i=1;
	    	   		 fos = new FileOutputStream("sample.xlsx");  
	    	   		 Sheet sh = wb.createSheet("new sheet 1");  
	    	   	
	    	   	
	     		     rs=stmt.executeQuery("select propertyid from property_all");
	     		   
	     		while(rs.next())
	     		{
	     			String propid= rs.getString(1);
	     			 
	     			 Row row = sh.createRow((short)k); 
	     			 
	     			 Cell cell = row.createCell((short)1);  
                      
	     			 cell.setCellValue(propid);  
	     			 k++;
	     		}
                                                          wb.write(fos);    connection.close();

	    		}
	     		catch(Exception e)
	     		{
	     			e.printStackTrace();
	     		}
	     		finally{
                                                         
                                                        fos.close();  

	     		}
	            
			
 }  
		 public  void doPost(HttpServletRequest request, HttpServletResponse  response)
	        throws IOException, ServletException {

	        doGet(request, response);
	        }
	  
    

 } 

and i am gettign the error:

java.lang.OutOfMemoryError: Java heap space

i googled and found that the java heap size need to be increased, but I am confused either to increse it in Tomcat or eclipse or command line. As I am using these three in my project. Also i dont want to increase the heap for one specific application , as i have 2 more running .

Also please suggest me the commands to increse the heap size.

[Bear Bibeault]

"rocx sum", please check your private messages for an important administrative matter. Failure to do so will result in the removal of your account.

[Jesper de Jong]

If this is part of a web application, then you will need to change the memory settings in the Tomcat configuration. Lookup the documentation for your specific version of Tomcat to find out how to do that.

If it is part of a standalone Java application that you run from the command line, then you'd need to add a -Xmx option to the command. For example:

java -Xmx1024m org.mypackage.MyProgram

to give it a max of 1024 MB (1 GB) memory.

[ravi khonal]

check out this link guys,,

http://javarevisited.blogspot.com/2011/05/java-heap-space-memory-size-jvm.html

[carina caoor]

I added a new environmental variable named JAVA_OPTS = -Xms1024m -Xmx1024m -XX:MaxPermSize=128m


Still i am getting the same error.

My tomcat is plugged into Eclipse and in eclipse.ini file i tried changing the -vmargs and gave -Xms1024m -Xmx1024m .
But Eclipse failed to start after this changes and i revert back the previous settings.