I saw the error_log. It gives me the following errors.
[Wed Jan 17 19:43:17 GMT+00:00 2001] Exception raised in servlet: jspServlet
[Wed Jan 17 19:43:17 GMT+00:00 2001] java.io.IOException: Error: Attempt to
clea
r a buffer that's already been flushed
at java.lang.Throwable.fillInStackTrace(Native Method)
at java.lang.Throwable.fillInStackTrace(Compiled Code)
at java.lang.Throwable.<init>(Compiled Code)
at java.lang.Exception.<init>(Compiled Code)
at java.io.IOException.<init>(Compiled Code)
at
com.sun.server.http.pagecompile.jsp.runtime.JspWriterImpl.clear(Compi
led Code)
at pagecompile.jsp._RgeList._jspService(_RgeList.java:130)
at
com.sun.server.http.pagecompile.jsp.runtime.HttpJspBase.service(Compi
led Code)
at javax.servlet.http.HttpServlet.service(Compiled Code)
at
com.sun.server.http.pagecompile.jsp.runtime.JspServlet.runServlet(Com
piled Code)
at
com.sun.server.http.pagecompile.jsp.runtime.JspServlet.processJspPage
(Compiled Code)
at
com.sun.server.http.pagecompile.jsp.runtime.JspServlet.service(Compil
ed Code)
at javax.servlet.http.HttpServlet.service(Compiled Code)
at com.sun.server.ServletState.callService(Compiled Code)
Thanks
JS
-----Original Message-----
From: Singh, Jasbinder
Sent: Wednesday, January 17, 2001 11:15 AM
To: [EMAIL PROTECTED]
Subject: Resultset limit
Hi All,
Is there a limit on the number of records that ResultSet can retrieve.
I have a jsp which has a drop-down box. This is populated from a drop
down box. I use a bean to connect to the database and retrieve the values
from the table. The table has close to 2000 entries. But only about 70
values
are getting populated in the drop down box and the page ends there and
doesn't
display the other fields. Is this a problem with the ResultSet or with the
drop-down box.
I wrote a sample java program. It is able to retrieve all the rows from the
table.
Here is a portion of the jsp.
<form>
<%
java.sql.ResultSet rs = null;
try
{
rs=rangeBean.getMembers();
}
catch(java.sql.SQLException e)
{ }
catch(Exception e)
{ }
%>
......
<table width="75%" cellspacing="2" cellpadding="2" border="0">
<tr>
<td>Member Name</td>
<td><select name="Member">
<option selected value="0">Select a member</option>
<%
while(rs.next())
{
out.println("<option
value=\""+rs.getString(1)+"\">"+rs.getString(1)+"</
option>");
}
%>
</select></td>
</tr>
<%.......
...
%>
</table>
...
</form>
</body>
</html>
Could somebody help !
Thanks
JS
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
