ResultSet to XML Transform Pipeline Item

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.