public class JRJdbcQueryExecuter extends JRAbstractQueryExecuter
JRAbstractQueryExecuter.QueryParameter, JRAbstractQueryExecuter.QueryParameterEntry, JRAbstractQueryExecuter.QueryParameterVisitor, JRAbstractQueryExecuter.ValuedQueryParameter, JRAbstractQueryExecuter.VisitExceptionWrapper
Modifier and Type | Field and Description |
---|---|
protected static java.lang.String |
CACHED_ROWSET_CLASS |
static java.lang.String |
CANONICAL_LANGUAGE |
static java.lang.String |
CLAUSE_ID_BETWEEN |
static java.lang.String |
CLAUSE_ID_BETWEEN_CLOSED |
static java.lang.String |
CLAUSE_ID_BETWEEN_LEFT_CLOSED |
static java.lang.String |
CLAUSE_ID_BETWEEN_RIGHT_CLOSED |
static java.lang.String |
CLAUSE_ID_EQUAL |
static java.lang.String |
CLAUSE_ID_GREATER |
static java.lang.String |
CLAUSE_ID_GREATER_OR_EQUAL |
static java.lang.String |
CLAUSE_ID_IN |
static java.lang.String |
CLAUSE_ID_LESS |
static java.lang.String |
CLAUSE_ID_LESS_OR_EQUAL |
static java.lang.String |
CLAUSE_ID_NOTEQUAL |
static java.lang.String |
CLAUSE_ID_NOTIN |
protected static java.lang.String |
CLOSE_CURSORS_AT_COMMIT |
protected static java.lang.String |
CONCUR_READ_ONLY |
protected static java.lang.String |
CONCUR_UPDATABLE |
protected java.sql.Connection |
connection |
static java.lang.String |
EXCEPTION_MESSAGE_KEY_MULTI_PARAMETERS_CANNOT_CONTAIN_NULL_VALUES |
static java.lang.String |
EXCEPTION_MESSAGE_KEY_QUERY_STATEMENT_CANCEL_ERROR |
static java.lang.String |
EXCEPTION_MESSAGE_KEY_QUERY_STATEMENT_EXECUTE_ERROR |
static java.lang.String |
EXCEPTION_MESSAGE_KEY_QUERY_STATEMENT_PREPARE_ERROR |
static java.lang.String |
EXCEPTION_MESSAGE_KEY_UNEXPECTED_MULTI_PARAMETER_TYPE |
protected static java.lang.String |
HOLD_CURSORS_OVER_COMMIT |
protected java.sql.ResultSet |
resultSet |
protected java.sql.PreparedStatement |
statement
The statement used to fire the query.
|
protected static java.lang.String |
TYPE_FORWARD_ONLY |
protected static java.lang.String |
TYPE_SCROLL_INSENSITIVE |
protected static java.lang.String |
TYPE_SCROLL_SENSITIVE |
CLAUSE_POSITION_ID, clauseFunctions, dataset, EXCEPTION_MESSAGE_KEY_NUMERIC_TYPE_REQUIRED, EXCEPTION_MESSAGE_KEY_PARAMETER_NOT_FOUND, EXCEPTION_MESSAGE_KEY_QUERY_CLAUSE_CIRCULARLY_NESTED_PARAMETER, EXCEPTION_MESSAGE_KEY_QUERY_CLAUSE_ID_FIRST_TOKEN_MISSING, EXCEPTION_MESSAGE_KEY_QUERY_CLAUSE_NOT_FOUND, EXCEPTION_MESSAGE_KEY_UNSUPPORTED_PARAMETER_TYPE, GET_COLLECTED
Constructor and Description |
---|
JRJdbcQueryExecuter(JasperReportsContext jasperReportsContext,
JRDataset dataset,
java.util.Map<java.lang.String,? extends JRValueParameter> parameters) |
JRJdbcQueryExecuter(JRDataset dataset,
java.util.Map<java.lang.String,? extends JRValueParameter> parameters)
Deprecated.
|
Modifier and Type | Method and Description |
---|---|
boolean |
cancelQuery()
Cancels the query if it's currently running.
|
void |
close()
Closes resources kept open during the data source iteration.
|
JRDataSource |
createDatasource()
Executes the query and creates a
JRDataSource out of the result. |
protected void |
createStatement() |
protected java.lang.String |
getCanonicalQueryLanguage()
Returns a canonical query language for this query executer implementation.
|
protected static int |
getConcurrency(java.lang.String concurrency) |
protected static int |
getHoldability(java.lang.String holdability,
java.sql.Connection connection) |
protected java.util.Calendar |
getParameterCalendar(JRPropertiesHolder properties) |
protected java.lang.String |
getParameterReplacement(java.lang.String parameterName)
Returns the replacement text for a query parameter.
|
java.sql.ResultSet |
getResultSet() |
protected static int |
getResultSetType(java.lang.String type) |
protected void |
registerFunctions()
Registers built-in
clause functions . |
protected java.util.TimeZone |
resolveTimeZone(java.lang.String timezoneId) |
protected void |
setDate(int parameterIndex,
java.lang.Object parameterValue,
JRPropertiesHolder properties) |
protected void |
setStatementMultiParameter(int parameterIndex,
java.lang.String parameterName,
int valueIndex,
java.lang.Object value,
JRPropertiesHolder properties) |
protected int |
setStatementMultiParameters(int parameterIndex,
java.lang.String parameterName,
boolean ignoreNulls) |
protected void |
setStatementParameter(int parameterIndex,
java.lang.Class<?> parameterType,
java.lang.Object parameterValue,
JRPropertiesHolder properties) |
protected void |
setStatementParameter(int parameterIndex,
java.lang.String parameterName) |
protected void |
setTime(int parameterIndex,
java.lang.Object parameterValue,
JRPropertiesHolder properties) |
protected void |
setTimestamp(int parameterIndex,
java.lang.Object parameterValue,
JRPropertiesHolder properties) |
protected void |
setTimeZone() |
addQueryMultiParameters, addQueryMultiParameters, addQueryParameter, addQueryParameter, appendClauseChunk, appendParameterChunk, appendParameterClauseChunk, appendQueryChunk, appendTextChunk, applyClause, checkParameter, findExtensionQueryFunction, getBooleanParameter, getBooleanParameter, getBooleanParameterOrProperty, getBooleanParameterOrProperty, getCollectedParameterNames, getCollectedParameters, getJasperReportsContext, getParameter, getParameterValue, getParameterValue, getPropertiesUtil, getQueryString, getStringParameter, getStringParameterOrProperty, getValueParameter, getValueParameter, parameterHasValue, parseQuery, registerClauseFunction, resolveFunction, unregisterClauseFunction, visitQueryParameters
public static final java.lang.String EXCEPTION_MESSAGE_KEY_MULTI_PARAMETERS_CANNOT_CONTAIN_NULL_VALUES
public static final java.lang.String EXCEPTION_MESSAGE_KEY_QUERY_STATEMENT_CANCEL_ERROR
public static final java.lang.String EXCEPTION_MESSAGE_KEY_QUERY_STATEMENT_EXECUTE_ERROR
public static final java.lang.String EXCEPTION_MESSAGE_KEY_QUERY_STATEMENT_PREPARE_ERROR
public static final java.lang.String EXCEPTION_MESSAGE_KEY_UNEXPECTED_MULTI_PARAMETER_TYPE
public static final java.lang.String CANONICAL_LANGUAGE
public static final java.lang.String CLAUSE_ID_IN
public static final java.lang.String CLAUSE_ID_NOTIN
public static final java.lang.String CLAUSE_ID_EQUAL
public static final java.lang.String CLAUSE_ID_NOTEQUAL
public static final java.lang.String CLAUSE_ID_LESS
public static final java.lang.String CLAUSE_ID_GREATER
public static final java.lang.String CLAUSE_ID_LESS_OR_EQUAL
public static final java.lang.String CLAUSE_ID_GREATER_OR_EQUAL
public static final java.lang.String CLAUSE_ID_BETWEEN
public static final java.lang.String CLAUSE_ID_BETWEEN_CLOSED
public static final java.lang.String CLAUSE_ID_BETWEEN_LEFT_CLOSED
public static final java.lang.String CLAUSE_ID_BETWEEN_RIGHT_CLOSED
protected static final java.lang.String TYPE_FORWARD_ONLY
protected static final java.lang.String TYPE_SCROLL_INSENSITIVE
protected static final java.lang.String TYPE_SCROLL_SENSITIVE
protected static final java.lang.String CONCUR_READ_ONLY
protected static final java.lang.String CONCUR_UPDATABLE
protected static final java.lang.String HOLD_CURSORS_OVER_COMMIT
protected static final java.lang.String CLOSE_CURSORS_AT_COMMIT
protected static final java.lang.String CACHED_ROWSET_CLASS
protected java.sql.Connection connection
protected java.sql.PreparedStatement statement
protected java.sql.ResultSet resultSet
public JRJdbcQueryExecuter(JasperReportsContext jasperReportsContext, JRDataset dataset, java.util.Map<java.lang.String,? extends JRValueParameter> parameters)
public JRJdbcQueryExecuter(JRDataset dataset, java.util.Map<java.lang.String,? extends JRValueParameter> parameters)
JRJdbcQueryExecuter(JasperReportsContext, JRDataset, Map)
.protected void registerFunctions()
clause functions
.protected java.lang.String getCanonicalQueryLanguage()
JRAbstractQueryExecuter
The canonical language is used to retrieve extensions for the query executer.
The default implementation returns the runtime query language used in the dataset, but query executer implementations should override this method and return a fixed language.
getCanonicalQueryLanguage
in class JRAbstractQueryExecuter
protected void setTimeZone()
protected java.util.TimeZone resolveTimeZone(java.lang.String timezoneId)
protected java.lang.String getParameterReplacement(java.lang.String parameterName)
JRAbstractQueryExecuter
getParameterReplacement
in class JRAbstractQueryExecuter
parameterName
- the parameter nameJRQueryChunk.TYPE_PARAMETER
public JRDataSource createDatasource() throws JRException
JRQueryExecuter
JRDataSource
out of the result.JRDataSource
wrapping the query execution result.JRException
protected void createStatement() throws JRException
JRException
public java.sql.ResultSet getResultSet()
protected void setStatementParameter(int parameterIndex, java.lang.String parameterName) throws java.sql.SQLException
java.sql.SQLException
protected int setStatementMultiParameters(int parameterIndex, java.lang.String parameterName, boolean ignoreNulls) throws java.sql.SQLException
java.sql.SQLException
protected void setStatementMultiParameter(int parameterIndex, java.lang.String parameterName, int valueIndex, java.lang.Object value, JRPropertiesHolder properties) throws java.sql.SQLException
java.sql.SQLException
protected void setStatementParameter(int parameterIndex, java.lang.Class<?> parameterType, java.lang.Object parameterValue, JRPropertiesHolder properties) throws java.sql.SQLException
java.sql.SQLException
protected void setTimestamp(int parameterIndex, java.lang.Object parameterValue, JRPropertiesHolder properties) throws java.sql.SQLException
java.sql.SQLException
protected void setTime(int parameterIndex, java.lang.Object parameterValue, JRPropertiesHolder properties) throws java.sql.SQLException
java.sql.SQLException
protected void setDate(int parameterIndex, java.lang.Object parameterValue, JRPropertiesHolder properties) throws java.sql.SQLException
java.sql.SQLException
protected java.util.Calendar getParameterCalendar(JRPropertiesHolder properties)
public void close()
JRQueryExecuter
createDatasource
.public boolean cancelQuery() throws JRException
JRQueryExecuter
true
if and only if the query was running and it has been canceledJRException
protected static int getResultSetType(java.lang.String type)
protected static int getConcurrency(java.lang.String concurrency)
protected static int getHoldability(java.lang.String holdability, java.sql.Connection connection) throws java.sql.SQLException
java.sql.SQLException
© 2001-2014 TIBCO Software Inc. www.jaspersoft.com