Overview
The SQL Query Action executes SQL queries against relational databases. 
Database Connection Type - Specifies the type of connection to be used to connect to the database.
JDBC - Connect using a standard JDBC connection. The following inputs must also be provided.* JDBC Drive - Name of the JDBC driver class to use when connecting to the database.
- Database URL - The database connection URL.
- User Name - The username to use when connecting to the database.
- Password - The password to use when connection to the database.JNDI - Connect using the specified JNDI name.
Shared - Connect to the database using the named shared connection. See the Relational Connection Action for further details
Result Set Type - Specifies the type of result set to use when returnin the query results. The options are:
Live Result - The query results are fetched from the dabase server on an as needed basis using a data set cursor. This is the preferred option when the data sets being returned are expected to be very large. Performance is slower but memory usage is reduced.
In-Memory Result Set - The query results are returned in their entirety from the database server and cached on the BI server.
Query - The SQL query to be executed.
Run Query - Determines when the query is to be executed. The options are:
Immediately - The query is run immediately by the Pentaho BI server.
From Pentaho Subreport - The query is prepared for execution, with the intention of being run later in the action sequence by a subreport within a JFree Report. See the JFree Report action for further details.