Tomcat 5 & JSP page buffer

Hi all,

I'm new to JSP and am having a problem with the page buffer. I have a page which uses a for loop to print out the contents of a row from a SQL table. The JSP stops outputting html at different points in the page, depending on the data and the page stops way before the closing body and html or even table tags later in the page. I've tried changing the page buffer directive to 10kb, but I get a cryptic exception error. Is there some setting in Tomcat that is screwing me up? Please help!

Thanks!

-Carlo

[539 byte] By [axelr8] at [2007-9-30 19:41:30]
# 1
A cut and past of the cryptic exception output might help.Are you connecting to the DB directly from the JSP, or are you using intermediary Beans?
stevejluke at 2007-7-7 0:26:07 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...
# 2
Also, how many rows are you getting from the DB... More details are needed to attempt an answer.
stevejluke at 2007-7-7 0:26:07 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...
# 3

I figured out what was wrong but I have no idea why this works. My code is below. I added a space to this line of code: out.write(result.getString(i)+" "); Without anything behind the result.getSring(i), the loop would arbitrarily end and the page would be output with the rest of the HTML missing. Any ideas on why this is?

Thanks!

<%

while (result.next()) {

for (int i=1; i<=columns; i++) {%>

<tr>

<td bordercolor="#999999" bgcolor="#FFFFFF" class="maintextsmpurp" ><strong>

<%out.write(rsmd.getColumnLabel(i));%>

</strong></td>

<td bordercolor="#999999">

<%out.write(result.getString(i)+" ");%>

</td>

<td width="1%" bordercolor="#FFFFFF"> </td>

</tr>

<% } }%>

axelr8 at 2007-7-7 0:26:07 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...