写了一个连接到数据库读取数据的jsp文件，但是在tomcat下运行的时候，出现了下面的错误：

HTTP Status 500 -

---

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

javax.servlet.ServletException
	org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:845)
	org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:778)
	org.apache.jsp.connect_jsp._jspService(connect_jsp.java:77)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

root cause

java.lang.OutOfMemoryError

note The full stack trace of the root cause is available in the Apache Tomcat/5.0.29 logs. 部分代码是这样的： Connection conn= DriverManager.getConnection(url,user,password); Statement stmt=conn.createStatement(); String sql = new String(); sql="select signal_name from repdata1_pri where rec_id like'200507172000%'"; ResultSet rs=stmt.executeQuery(sql); while(rs.next()) { temp=rs.getString("signal_name"); out.println(temp); } rs.close(); stmt.close(); conn.close(); 请高手们帮我看看这到底是怎么回事啊？

----------------解决方案--------------------------------------------------------
在TOMCAT启动文件catalina.bat里面"JAVA_OPTS='-Xms256m -Xmx300m'"
    -Xms是最小内存容量,-Xmx是最大内存容量。
试试把内存容量改大点

[此贴子已经被作者于2005-9-22 16:30:11编辑过]

----------------解决方案--------------------------------------------------------
网上复制的代码有时候就是这样！~
----------------解决方案--------------------------------------------------------
建议你用javabean实现数据库连接
----------------解决方案--------------------------------------------------------