| Wiki Markup |
|---|
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". |
...
h4. *Component Name: |
...
Inputs:
REQUIRED
JNDI Name - Name of the JNDI connection.
or the following JDBC information
JDBC Driver - The JDBC driver to use when connecting to the data source.
JDBC Connection String - The connection string identifying the location of the data source.
JDCB User Name - User name to use when connecting to the data source.
JDBC Password - Password to use when connecting to the data source.
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.
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.
| Note | ||
|---|---|---|
| ||
Explain the PREPARE: parameter* SQLLookupRule
h4. *Inputs:*
_REQUIRED_
*JNDI Name* \- Name of the JNDI connection.
_or an SQL Prepared Component object_
*Prepared Component* \- A previous SQLLookupRule that defined a prepared component as the output. The previous SQLLookupRule will share it's connection with the current SQLLookupRule
_or the following JDBC information_
*JDBC Driver* \- The JDBC driver to use when connecting to the data source.
*JDBC Connection String* \- The connection string identifying the location of the data source.
*JDCB User Name* \- User name to use when connecting to the data source.
*JDBC Password* \- Password to use when connecting to the data source.
_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.
*SQL Query* \- This is required if no prepared component object is defined. to utilize SQL's prepared statement functionality.
Use {PREPARE:<paramname>} in the sql query, where <paramname> is an input parameter to the SQLLookupRule. This parameter is resolved during the execution of the SQLLookupRule.
Use {PREPARELATER:<paramname>} in the sql query when defined as a prepared component (see outputs below). The <paramname> and value is provided by the executing component.
*Note:* Any parameter may be referenced in the query by enclosing the parameter in curly braces.
h4. *Outputs:*
*Result Set Name*\-\- The name of the parameter in which to store the query results.
_or_
*Prepared Component* \- The name of the parameter in which to store the prepared component object, which can be used for shared connections and later processing by other components. |