Activity - sqlResultToBytes

Activity Type: Relational

Description

Converts a BLOB (or similar) column of the result of an SQL Query or a stored procedure into a stream of byte arrays. The activity will output output data from a single specified column of the first row of the input result set. If the input result set contains more than one row all rows except the first will be ignored.

This activity is useful if you wish to deliver data held in a BLOB to delivery activities such as deliverToURL, deliverToGFTP or outputStream .

Example

<sqlResultToBytes name="myActivityInstance">
 <resultSet from="resultSetStream"/>
 <columnIndex value="1"/>
 <blockSize value="2000"/>
 <outputStream name="byteStream"/>
</sqlResultToBytes>

Specification

Element sqlResultToBytes:

• Attribute name - unique name for the activity instance 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 columnIndex (required) - index of column from which to extract the data.
  • Attribute value - index value. The first column has an index value of 1.
• Element blockSize (optional) - maximum number of bytes in each output block. If specified all blocks except the final one are guaranteed to contain this many bytes. If not specified the default value of 1024 bytes is used.
  • Attribute value - block size value. The block size in bytes.
• Element outputStream (required) - output stream.
  • Attribute name - name of the activity's output stream.

Input and Output Types

• Input: resultSet - java.sql.ResultSet
• Output: outputStream - multiple output blocks of type byte[].

Data Resource Accessor

This activity can operate with any data resource accessor.

XML Schema

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

Class

uk.org.ogsadai.activity.sql.SQLResultToBytesActivity

Client Toolkit Class

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