Activity - sqlResultsToXML

Activity Type: Relational

Description

Convert the results of an SQL query or a stored procedure into XML. Results of an SQL query are converted into WebRowSet format. For stored procedure results, update counts and output parameters are converted into single XML elements.

Example

<sqlResultsToXML name="results">
 <resultSet from="sqlStatement" />
 <webRowSet name="webrowset" />
</sqlResultsToXML>

Example output

<outputParameter position="1">10000</outputParameter>
<resultStream updateCount="100"/>
<webRowSet xmlns="http://java.sun.com/xml/ns/jdbc" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/jdbc http://java.sun.com/xml/ns/jdbc/webrowset.xsd">
 <properties> ... </properties>
 ... 
 <data> ... </data>
</webRowSet>

Specification

Element sqlResultsToXML:

• Attribute name - unique name for the activity within the scope of a request.
• Element resultSet (required) - input stream.
  • Attribute from - name of the output from another activity which provides the SQL results.
• Element webRowSet (required) - output stream.
  • Attribute name - name of the activity's output stream.

Input and Output Types

• Input: resultSet- java.sql.ResultSet
• Output: webRowSet - java.lang.String in a WebRowSet format.

Data Resource Accessor

This activity can operate with any data resource accessor.

XML Schema

OGSA-DAI/schema/ogsadai/xsd/activities/sql_results_to_xml.xsd

Class

uk.org.ogsadai.activity.sql.SQLResultsToXMLActivity

Client Toolkit Class

uk.org.ogsadai.client.toolkit.activity.sql.WebRowSet