[jira] Updated: (XALANJ-1168) SQL Extension broken for streaming mode

[xa...@xml.apache.org]

The following issue has been updated:

    Updater: Brian Minchau (mailto:minchau@ca.ibm.com)
       Date: Sat, 4 Sep 2004 6:08 PM
    Changes:
             assignee changed from Xalan Developers Mailing List
             description changed from 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). to 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).
             environment changed from Operating System: Other
Platform: All to Operating System: Other
Platform: All
             priority changed to Blocker
             Component changed to Xalan extensions (SQL)
             Component changed from Xalan-interpretive transformation
    ---------------------------------------------------------------------
For a full history of the issue, see:

  http://issues.apache.org/jira/browse/XALANJ-1168?page=history

---------------------------------------------------------------------
View the issue:
  http://issues.apache.org/jira/browse/XALANJ-1168

Here is an overview of the issue:
---------------------------------------------------------------------
        Key: XALANJ-1168
    Summary: SQL Extension broken for streaming mode
       Type: Bug

     Status: Unassigned
   Priority: Blocker

    Project: XalanJ2
 Components: 
             Xalan extensions (SQL)
   Versions:
             2.4Dx

   Assignee: 
   Reporter: John Gentilin

    Created: Thu, 5 Sep 2002 4:21 PM
    Updated: Sat, 4 Sep 2004 6:08 PM
Environment: Operating System: Other
Platform: All

Description:
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).


---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.

If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira


---------------------------------------------------------------------
To unsubscribe, e-mail: xalan-dev-unsubscribe@xml.apache.org
For additional commands, e-mail: xalan-dev-help@xml.apache.org