Author |
Erik Johnson |
Creation date |
06/01/2011 |
Firing policy |
all |
Package |
org.seasr.meandre.components.io.datasource |
DESCRIPTION
Overview:
This compnent executes a query and returns the resultset. The user has three options.
First they may specify a path to a query file on the local filesystem using the Query_Path property.
If this property is not blank, the component will attempt to load from the path and execute the query stored in that file.
If the Query_Path property is blank, it will check the Query_Statement Property.
If this is not blank, it will attempt to execute the text in the Query_Statement property as an sql query.
Finally, if both properties are blank, it will present the user with a WebUI to enter a query manually
INPUTS
Name |
Description |
Example |
|---|---|---|
Connection |
The input databse connection |
|
OUTPUTS
Name |
Description |
Example |
|---|---|---|
Connection |
A connection to the same database |
|
ResultSet |
The result of the executed query |
|
PROPERTIES
Name |
Description |
Default value |
|---|---|---|
Query_Path |
Full path to a text file with an sql query (i.e. C:/myquery.sql). This file will be parsed for an sql query. Lines beginning with // will be ignored as comments. The first semicolon will be treated as the end of the file; this component does not support multiple simultaneous queries. If the value "none" is specified, a webUI will be started to allow the user to enter a query manually. |
none |
Query_Statement |
This property is a SQL query (such as SELECT * FROM SAMPLETABLE). If no sql query file path is specified, the component will look at this property before presenting the user with a WebUI. If it is not blank it will execute this query. |
none |
Add Comment