public class JRJdbcQueryExecuterFactory extends AbstractQueryExecuterFactory
JRJdbcQueryExecuter
Modifier and Type | Field and Description |
---|---|
static String |
PROPERTY_CACHED_ROWSET
Flag property specifying if data will be stored in a cached rowset.
|
static String |
PROPERTY_FIELDS_TIME_ZONE |
static String |
PROPERTY_JDBC_CONCURRENCY
Property specifying the ResultSet concurrency.
|
static String |
PROPERTY_JDBC_FETCH_SIZE
Property specifying the ResultSet fetch size.
|
static String |
PROPERTY_JDBC_HOLDABILITY
Property specifying the ResultSet holdability.
|
static String |
PROPERTY_JDBC_MAX_FIELD_SIZE
Property specifying the statement max field size.
|
static String |
PROPERTY_JDBC_RESULT_SET_TYPE
Property specifying the ResultSet type.
|
static String |
PROPERTY_PARAMETERS_TIME_ZONE |
static String |
PROPERTY_TIME_ZONE
Property specifying the default time zone to be used for sending and retrieving
date/time values to and from the database.
|
static String |
QUERY_LANGUAGE_SQL
SQL query language.
|
QUERY_EXECUTER_FACTORY_PREFIX
Constructor and Description |
---|
JRJdbcQueryExecuterFactory() |
Modifier and Type | Method and Description |
---|---|
JRQueryExecuter |
createQueryExecuter(JasperReportsContext jasperReportsContext,
JRDataset dataset,
Map<String,? extends JRValueParameter> parameters)
Creates a query executer.
|
Object[] |
getBuiltinParameters()
Returns the built-in parameters associated with this query type.
|
boolean |
supportsQueryParameterType(String className)
Decides whether the query executers created by this factory support a query parameter type.
|
createQueryExecuter
public static final String PROPERTY_JDBC_FETCH_SIZE
public static final String PROPERTY_JDBC_RESULT_SET_TYPE
public static final String PROPERTY_JDBC_CONCURRENCY
public static final String PROPERTY_JDBC_HOLDABILITY
public static final String PROPERTY_JDBC_MAX_FIELD_SIZE
public static final String PROPERTY_CACHED_ROWSET
public static final String PROPERTY_TIME_ZONE
The property can be set globally, at dataset level, at parameter and field levels, and as a report/dataset parameter. Note that sending a value as parameter will override all properties, and the time zone will be used for all date/time parameters and fields in the report.
The property value can be a time zone ID or REPORT_TIME_ZONE.
In the latter case the report time zone (as in JRParameter.REPORT_TIME_ZONE
will be used.
public static final String PROPERTY_PARAMETERS_TIME_ZONE
public static final String PROPERTY_FIELDS_TIME_ZONE
public static final String QUERY_LANGUAGE_SQL
public JRQueryExecuter createQueryExecuter(JasperReportsContext jasperReportsContext, JRDataset dataset, Map<String,? extends JRValueParameter> parameters) throws JRException
QueryExecuterFactory
jasperReportsContext
- the JasperReportsContextdataset
- the dataset containing the query, fields, etcparameters
- map of value parameters (instances of JRValueParameter
)
indexed by nameJRException
public Object[] getBuiltinParameters()
QueryExecuterFactory
{"Param1", String.class, "Param2", "List.class"}
).public boolean supportsQueryParameterType(String className)
QueryExecuterFactory
className
- the value class name of the parameterCopyright © 2016. All rights reserved.