<br><font size=2 color=blue face="sans-serif"><i>Ref: Servlet Mailing
List Archives. Dt. 2005-11-09 Number: 15765</i></font>
<br>
<br>
<br><font size=2 face="sans-serif">Hi,</font>
<br>
<br><font size=2 face="sans-serif">I am using ResultSetBuilder.java. And
all it displays in output xml file is:</font>
<br>
<br><font size=2 face="sans-serif"><?xml version="1.0" encoding="UTF-8"?></font>
<br><font size=2 face="sans-serif"><RootElement /></font>
<br>
<br><font size=2 face="sans-serif">Thru debug stmt, I could see that the
result set has been populated before going in to while loop [</font>
<table width=100%>
<tr valign=top>
<td width=100% bgcolor=white><font size=3 color=blue face="Courier New"><b>while</b></font><font size=3 face="Courier New">
(rs.next() && (rowCount++ < maxRows)) {</font></table>
<br><font size=2 face="sans-serif">]</font>
<br>
<br><font size=2 face="sans-serif">I put the debug stmts in below loop
and it does display all the column names</font>
<br>
<br>
<table width=100%>
<tr valign=top>
<td width=100% bgcolor=white><font size=3 color=#008000 face="Courier New">//
get the column labels for this record set </font><font size=3 color=#bbbbbb face="Courier New"><br>
216 </font><a href=http://kickjava.com/777.htm><font size=3 color=#003399 face="Courier New"><u>String</u></font></a><font size=3 face="Courier New">[]
columnName = </font><font size=3 color=blue face="Courier New"><b>new</b></font><font size=3 face="Courier New">
</font><a href=http://kickjava.com/777.htm><font size=3 color=#003399 face="Courier New"><u>String</u></font></a><font size=3 face="Courier New">[colCount];
</font><font size=3 color=#bbbbbb face="Courier New"><br>
217 </font><font size=3 face="Courier New"> </font><font size=3 color=blue face="Courier New"><b>for</b></font><font size=3 face="Courier New">
(</font><font size=3 color=blue face="Courier New"><b>int</b></font><font size=3 face="Courier New">
index = 0; index < colCount; index++) { </font><font size=3 color=#bbbbbb face="Courier New"><br>
218 </font><font size=3 face="Courier New"> columnName[index]
= rsmd.getColumnName(index+1); </font>
<br><font size=3 color=#bbbbbb face="Courier New">
System.out.println(</font><font size=3 face="Courier New">columnName[index]</font><font size=3 color=#bbbbbb face="Courier New">);
<br>
219 </font><font size=3 face="Courier New"> }
</font></table>
<br>
<br>
<br><font size=2 face="sans-serif">in build() method. But it does not enter
this loop and thus not building the XML file for the resultset.</font>
<br>
<br><font size=2 face="sans-serif">I did use the toString() methods as
mentioned by below contanct, but still its giving the same result.</font>
<br>
<br>
<table>
<tr>
<td><font size=2 face="sans-serif"><br>
</font>
<table width=100%>
<tr valign=top>
<td width=100%><font size=2 face="sans-serif"><br>
</font>
<table width=100%>
<tr>
<td width=100%><font size=2 face="sans-serif">Subject: RE: [jdom-interest]
ResultSetBuilder issue<br>
Date: Wed, 9 Nov 2005 11:21:23 -0500<br>
From: "Mark Hale" <Mark@beforethecall.com><br>
</font></table>
<br></table>
<br></table>
<br>
<br>
<br>
<br>
<br><font size=2 face="sans-serif">Can anybody help me fixing this issue?</font>
<br>
<br><font size=2 face="sans-serif">Thanks</font>
<br><font size=2 face="sans-serif">Jasmin</font><p><font size="1"><font face="arial,helvetica,sans-serif"><strong>******************************************************************************<br /></strong><font color="#ff0000">ATTENTION ATTENTION ATTENTION ATTENTION ATTENTION</font> <br />Our domain name is changing. Please take note of the sender's<br />e-Mail address and make changes to your personal address list,<br />if needed. Both domains will continue to work, only for a limited<br />time.<br />******************************************************************************<br />This email and any files transmitted with it are intended solely for <br />the use of the individual or agency to whom they are addressed. <br />If you have received this email in error please notify the Navy <br />Exchange Service Command e-mail administrator. This footnote <br />also confirms that this email message has been scanned for the<br />presence of computer viruses.</font></font></p><p><font size="1"><font face="arial,helvetica,sans-serif">Thank You! <br /><strong>******************************************************************************</strong></font></font></p>