You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@xalan.apache.org by bu...@apache.org on 2002/09/05 18:21:07 UTC
DO NOT REPLY [Bug 12337] New: -
SQL Extension broken for streaming mode
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://nagoya.apache.org/bugzilla/show_bug.cgi?id=12337>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND
INSERTED IN THE BUG DATABASE.
http://nagoya.apache.org/bugzilla/show_bug.cgi?id=12337
SQL Extension broken for streaming mode
Summary: SQL Extension broken for streaming mode
Product: XalanJ2
Version: 2.4Dx
Platform: All
OS/Version: Other
Status: NEW
Severity: Normal
Priority: Other
Component: org.apache.xalan.lib.sql
AssignedTo: xalan-dev@xml.apache.org
ReportedBy: johnglinux@eyecatching.com
The iterator used when traversing the result set from the SQL Extension
unnecessarily sorts the data. In streaming mode, this causes loss of data
which results in only the last row of data being returned.
To workaround this problem only apply-templates to the row-set element and
provide another level of templates i.e.
<xsl:apply-templates select="$table/sql/row-set"/>
instead of
<xsl:apply-templates select="$table/sql/row-set/row"/>
Then provide a dummy template
<xsl:template match="row-set">
<xsl:apply-templates select="row"/>
</xsl:template>
I am also assuming that this will provide a performance enhancement since
the first select statement only selects one row, then only one row will
be sorted (in non streaming mode).