DatabaseQueryActivity documentation for details on how to
send non-transactional asynchronous queries and
for details on how to send transactional asynchronous queries.
DatabaseQueryProvider documentation for details on how to send
a synchronous queries.
The examples linked to above mention that the
QueryInfo object should
contain a copy of the values to set as parameters. Another way of stating this rule is that the
QueryInfo object must not directly or indirectly reference fields or methods
of an SBB.
The reason for this rule is that the
QueryInfo object will be used by
the resource adaptor at an unspecified time, when the SBB object may not exist, or may not represent the same SBB
QueryInfo documentation for an implementation example.
Interface Summary Interface Description DatabaseFutureResultA "future" for retrieving database results when they are available. DatabaseQueryActivityThe query activity on which result and failure events are fired. DatabaseQueryActivityContextInterfaceFactoryInterface implemented by the SLEE to get activity context interfaces for
DatabaseQueryFailureEventA failure event. DatabaseQueryProviderDefines the provider interface used by services to send queries using the Database Query resource adaptor. DatabaseQueryTransactionalActivityThe query activity on which result and failure events are fired. DatabaseResultEventThe result event. DatabaseTransactionDefines an interface for synchronous queries to interact with a explicit transaction. QueryInfoA callback interface implemented by SBBs to set the SQL statement and parameters for the query.
Class Summary Class Description QueryThis is a convenience abstract class for creating a QueryInfo with a QUERY ExecuteType UpdateQueryThis is a convenience abstract class for creating a QueryInfo with an UPDATE ExecuteType
Enum Summary Enum Description QueryFailureReasonEnumeration of failure reasons. QueryInfo.ExecuteTypeThe type of execute method to call on the prepared statement. QueryInfo.RetryBehaviourRetry behaviour options in the case of multiple data sources. QueryInfo.StatementTypeThe type of Statement.
Exception Summary Exception Description DatabaseQueryExceptionThrown by the Database Query resource adaptor for any exception that is not caused by a database problem (where
SQLExceptionis used) or a timeout (
TimeoutException) or no DataSources being available (
InsufficientResourcesExceptionThrown by the Database Query resource adaptor when there are insufficient resources (worker threads, connections) to process a request. NoDataSourcesAvailableExceptionThrown by the Database Query resource adaptor when none of the configured DataSources are available.