A ResultSet to XML transform pipeline item takes a result set as input and generates a SAX stream as output. This will generate XML of the form:
<result> <row count="1"> <COLUMN_NAME_1 type="1">COLUMN_VALUE</COLUMN_NAME_1> <COLUMN_NAME_2 type="1">COLUMN_VALUE</COLUMN_NAME_2> ... <COLUMN_NAME_N type="1">COLUMN_VALUE</COLUMN_NAME_N> </row> </result>
For each row there is a count
attribute that increments from 1 upwards.
For each row, the column names are used as element tags, and the java.sql.Types
value for the type is added as an attribute. All columns in the result set participate
in the output.