java.lang.OutOfMemoryError: Java heap space

[Steve kuan]

Hi there,

I am using eclipse EE to write my JSP script which will get the data from MySQL database but I being thrown error
messages.

Here's my code:

<%@ page language="java" 
import = "java.io.*"
import="java.sql.*" 
import = "javax.sql.*"
import = "java.sql.Connection"
import = "java.sql.Statement"
import = "java.sql.ResultSet"
import = "java.sql.DriverManager"
%>
<%
response.setContentType("text/html");
String licenseeName=request.getParameter("licenseeName"); System.out.println(licenseeName);
String businessName=request.getParameter("businessName"); System.out.println(businessName);
String licenseNo=request.getParameter("licenseNo"); System.out.println(licenseNo);
%>
<h2><font color=blue>
<%
    String connectionURL="jdbc:mysql://localhost:3306/mobile_lic"; 
    Connection connection=null;
    ResultSet rs=null;
    String licenseeNam="";
    String businessNam="";
    String licenseN="";
    String for_t01_15050_Objectid="";
    String t01_15050_objectid="";
    String for_t15_00033_objectid="";
    String t01_00033_objectid="";
    String t15_00034_payStatus="";
    String for_t01_15010_objectid="";
    String t01_15010_objectid="";
    String t01_15010_code="";
    String t15_00033_requestStatus="";
    String licenseType="";
    String expiryDate="";
    String totalAmount="";
  	String name="";
  	String strQuery="";
    response.setContentType("text/html");
    try {
       // Load the database driver
      Class.forName("com.mysql.jdbc.Driver").newInstance();
      // Get a Connection to the database
      connection = DriverManager.getConnection(connectionURL, "root", "root"); 
      //Add the data into the database
  strQuery ="select * from t15_00034, t15_00033, t01_15050, t15_00030, t01_15010 where 
t15_00033.t01_15050_OBJECTID=t01_15050.OBJECTID and t15_00034.t15_00033_OBJECTID=t15_00033.OBJECTID 
and t15_00034.PAY_STATUS='01' and t15_00030.t01_15010_OBJECTID=t01_15010.OBJECTID and t01_15010.CODE I
N (01, 04) and t15_00033.REQUEST_STATUS='APPROVED' and t15_00034.EXPIRY_DATE <CURDATE()";
  Statement s = connection.createStatement();
  s.executeQuery (strQuery);
   rs = s.getResultSet();
  while (rs.next ()){
	licenseeNam=rs.getString("t15_00010.LICENSEE_NAME"); System.out.println(licenseeNam);
	businessNam=rs.getString("t15_00020.BUSINESS_NAME");
	licenseN=rs.getString("t15_00030.LIC_NAME");
	for_t01_15050_Objectid=rs.getString("t15_00033.t01_15050_OBJECTID");
	t01_15050_objectid=rs.getString("t01_15050.OBJECTID");
	for_t15_00033_objectid=rs.getString("t15_00034.t15_00033_OBJECTID");
	t01_00033_objectid=rs.getString("t15_00033.OBJECTID");
	t15_00034_payStatus=rs.getString("t15_00034.PAY_STATUS");
	for_t01_15010_objectid=rs.getString("");
	t01_15010_objectid=rs.getString("t01_15010.OBJECTID");
	t01_15010_code=rs.getString("t01_15010.CODE");
	t15_00033_requestStatus=rs.getString("t15_00033.REQUEST_STATUS");
	licenseType=rs.getString("t01_15050.DESCRIPTION");System.out.println(licenseType);
	expiryDate=rs.getString("t15_00034.EXPIRY_DATE");
	totalAmount=rs.getString("t15_00034.FEE_AMT");
	
    if(!connection.isClosed()){
        name=licenseeNam;
      }
       }
    rs.close ();
      s.close ();
      }catch(Exception e){
      System.out.println("Exception is ;"+e);
      }
    if(name.equals(licenseeName)){
    	if(businessNam.equals(businessName)){
    		if(licenseN.equals(licenseNo)){
    	
  %>
  <font color="red">Welcome</font>
  <%
  out.println(name);
  out.println("<br>");out.println("License Type: ");out.println(licenseType);
  out.println("<br>");out.println("Expiry Date: ");out.println(expiryDate);
  out.println("<br>");out.println("Total Amount  : ");out.println(totalAmount);

   }else{
	    out.println("You are not an authentic licensee!"); 
   }}else{
	    out.println("You are not an authentic licensee!"); 
   }}
    else{
    out.println("You are not an authentic licensee!"); 
      }
%>
</font></h2>

And Error Message's here:

Jul 27, 2012 9:44:12 AM org.apache.catalina.core.StandardWrapperValve invoke
SEVERE: Servlet.service() for servlet jsp threw exception
java.lang.OutOfMemoryError: Java heap space
at com.mysql.jdbc.MysqlIO.nextRowFast(MysqlIO.java:2123)
at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1900)
at com.mysql.jdbc.MysqlIO.readSingleRowSet(MysqlIO.java:3401)
at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:483)
at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:3096)
at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:2266)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2687)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2713)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2663)
at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1599)
at org.apache.jsp.searchValidation_jsp._jspService(searchValidation_jsp.java:102)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Unknown Source)

Please advise. Thanks in advance.

[Bear Bibeault]

First read, this JspFaq entry.

Then find out why your app is using too much memory (profiling tool) or allocate more memory to the Java process.

How many rows are getting fetched?

[Paul Clapham]

Reading all of the records of a very large query, and then checking to see whether the last record read happens to match the input data, is an extremely poor strategy. Besides the obvious problems which you have already observed, what happens if the record you are looking for is not the last one returned?

[Jordan Josh]

Hi,

Can you tell us what you are trying to achieve from this code ,so we can better help you.

Regards
Jatan