DO NOT REPLY [Bug 23235] New: - XML in database field not handled properly by SQLTransformer

[bu...@apache.org]

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=23235>.
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=23235

XML in database field not handled properly by SQLTransformer

           Summary: XML in database field not handled properly by
                    SQLTransformer
           Product: Cocoon 2
           Version: 2.1.1
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: Critical
          Priority: Other
         Component: sitemap components
        AssignedTo: dev@cocoon.apache.org
        ReportedBy: dean.cording@kaz-group.com


If a database field contains XML data and more than one row is returned, each 
column element in the row elements for the column that contains the XML, also 
contains all of the XML data from the previous rows.

The problem is because the same XMLSerializer is used for each row and it is 
not being recycled between rows.  Therefore when getSAXFragment is called it is 
returning all of the SAX events that it has collected since the start of the 
query.

Alternatively, the XMLSerializer is not flushing its buffer when it receives a 
StartDocument event.