uk.org.ogsadai.client.toolkit.activity.sql
Class ResultSetActivityOutputConverter

java.lang.Object
  |
  +--uk.org.ogsadai.client.toolkit.activity.sql.ResultSetActivityOutputConverter

public class ResultSetActivityOutputConverter
extends java.lang.Object

Converts XML WebRowSet from an SQL activity or CSV data into a java.sql.ResultSet.

Author:
The OGSA-DAI Project Team

Field Summary
private static java.lang.String COPYRIGHT_NOTICE
          Copyright statement
 
Constructor Summary
ResultSetActivityOutputConverter()
           
 
Method Summary
static java.sql.ResultSet convert(ActivityOutput output)
          Converts an activity output to a forward-only java.sql.ResultSet.
static java.sql.ResultSet convert(ActivityOutput output, int resultSetType)
          Converts an activity output to a java.sql.ResultSet.
static java.sql.ResultSet convertFromCSV(ActivityOutput output)
          Converts an activity output to a forward-only java.sql.ResultSet.
static java.sql.ResultSet convertFromCSV(ActivityOutput output, int resultSetType)
          Converts an activity output to a java.sql.ResultSet.
static java.sql.ResultSet convertFromCSV(ActivityOutput output, int resultSetType, CSVConfigurator configurator)
          Converts an activity output to a java.sql.ResultSet.
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

COPYRIGHT_NOTICE

private static final java.lang.String COPYRIGHT_NOTICE
Copyright statement

See Also:
Constant Field Values
Constructor Detail

ResultSetActivityOutputConverter

public ResultSetActivityOutputConverter()
Method Detail

convert

public static java.sql.ResultSet convert(ActivityOutput output)
                                  throws NoActivityOutputException,
                                         DataFormatException
Converts an activity output to a forward-only java.sql.ResultSet. The activity output must be an XML WebRowSet representation of a relational database query result.

Parameters:
output - Output with the data to convert
Returns:
forward-only ResultSet representing the query result that is in the give activity output.
Throws:
NoActivityOutputException - if there is no output data or the data has not yet been processed to this output or the activity that generates this output has not yet been executed.
DataFormatException - if the output from the activity cannot be parsed into a ResultSet.

convert

public static java.sql.ResultSet convert(ActivityOutput output,
                                         int resultSetType)
                                  throws NoActivityOutputException,
                                         DataFormatException
Converts an activity output to a java.sql.ResultSet. The activity output must be an XML WebRowSet representation of a relational database query result.

Parameters:
output - Output with the data to convert
resultSetType - One of ResultSet.TYPE_FORWARD_ONLY or ResultSet.TYPE_SCROLL_INSENSITIVE.
Returns:
ResultSet of the requested type representing the query result that is in the give activity output.
Throws:
java.lang.IllegalArgumentException - if resultSetType is not one of the two above.
NoActivityOutputException - if there is no output data or the data has not yet been processed to this output or the activity that generates this output has not yet been executed.
DataFormatException - if the output from the activity cannot be parsed into a ResultSet.

convertFromCSV

public static java.sql.ResultSet convertFromCSV(ActivityOutput output)
                                         throws NoActivityOutputException,
                                                DataFormatException
Converts an activity output to a forward-only java.sql.ResultSet. The activity output must be a CSV representation of a relational database query result. This method assumes default CSV file format (delimiter=, lineBreak=CRLF nullDataStr=NULL).

Parameters:
output - Output with the data to convert
Returns:
forward-only ResultSet representing the query result that is in the give activity output.
Throws:
NoActivityOutputException - if there is no output data or the data has not yet been processed to this output or the activity that generates this output has not yet been executed.
DataFormatException - if the output from the activity cannot be parsed into a ResultSet.

convertFromCSV

public static java.sql.ResultSet convertFromCSV(ActivityOutput output,
                                                int resultSetType)
                                         throws NoActivityOutputException,
                                                DataFormatException
Converts an activity output to a java.sql.ResultSet. The activity output must be a CSV representation of a database query result. This method assumes default CSV file format (delimiter=, lineBreak=CRLF nullDataStr=NULL).

Parameters:
output - Output with the data to convert
resultSetType - One of ResultSet.TYPE_FORWARD_ONLY or ResultSet.TYPE_SCROLL_INSENSITIVE.
Returns:
ResultSet of the requested type representing the query result that is in the give activity output.
Throws:
java.lang.IllegalArgumentException - if resultSetType is not one of the two above.
NoActivityOutputException - if there is no output data or the data has not yet been processed to this output or the activity that generates this output has not yet been executed.
DataFormatException - if the output from the activity cannot be parsed into a ResultSet.

convertFromCSV

public static java.sql.ResultSet convertFromCSV(ActivityOutput output,
                                                int resultSetType,
                                                CSVConfigurator configurator)
                                         throws NoActivityOutputException,
                                                DataFormatException
Converts an activity output to a java.sql.ResultSet. The activity output must be a CSV representation of a database query result. This method assumes default CSV file format (delimiter=, lineBreak=CRLF nullDataStr=NULL).

Parameters:
output - Output with the data to convert
resultSetType - One of ResultSet.TYPE_FORWARD_ONLY or ResultSet.TYPE_SCROLL_INSENSITIVE.
configurator - Description of the CSV format.
Returns:
ResultSet of the requested type representing the query result that is in the give activity output.
Throws:
java.lang.IllegalArgumentException - if resultSetType is not one of the two above.
NoActivityOutputException - if there is no output data or the data has not yet been processed to this output or the activity that generates this output has not yet been executed.
DataFormatException - if the output from the activity cannot be parsed into a ResultSet.