| Wiki Markup |
|---|
{scrollbar} |
Performs a SQL query against a JDBC or JNDI data source. The query results are available as an output to the action. The query may contain references parameters be enclosing the parameter in curly braces. For example select * from myTable where department = '{dept}' would replace {dept} with the value of the parameter named "dept".
Component Name:
...
Relational
Inputs:
REQUIRED
JNDI Name - Name of the JNDI connection.
...
OPTIONAL
Keep Connection Open _-- If selected the query results are retrieved from the data source as needed, otherwise the entire query results are brought over from the data source and cached in memory. It is recommended that you set this option with larger datasets. Never use this option if you are storing the resultset in the session.
Forward Only - This sets the cursor for the resultset to a forward-only cursor type, allowing one pass at data retrieval. If this is false, and the connection supports scrollable cursors, then the cursor type is scrollable, allowing multiple passes at the data. Forward only is false by default.
SQL Query - This is required if no prepared component object is defined. to utilize SQL's prepared statement functionality.
...
Note: Any parameter may be referenced in the query by enclosing the parameter in curly braces.
Outputs:
Result Set Name-- The name of the parameter in which to store the query results.
...