SQL Extension - Bug Fixes

[John Gentilin <jo...@eyecatching.com>]

Scott,

Found a couple of bugs is the SQL Code. Attached is an explanation,
the code fixes and a sample that exercises Bug#2. Mkay.sxl in its
current
form exercises Bug#1.


Bug #1
The first row of data returned by the Row object is actually
the  Row before the first row as defined by the JDBC ResultSet
Object.  The problem manifests as the first node of the /row-set/row/col

nodes to be empty strings. The can be observed by running the
mkay.xsl test stylesheet. The result will show a row of empty <TD>
nodes between the column-headers and the data grid.

Fix: In the Row#constructor, call the ResultSet#next method.

Bug#2

If the row-set/column-header tree was NOT traversed prior to
traversing the row-set/row/col tree, the attributes at the col level
were not available. Accessing them would cause a null pointer exception.

Fix: In the RowSet#getFirstChild,  fully initialize the m_columnHeader
array for both cases and not just the /column-header case.


John G