Package com.onenetwork.platform.data.sql

Services for ad-hoc querying and other lower-level database access.
  • Interface Summary 
    Interface Description
    SqlResultHandler
    Event handler which receives notifications during the executing of a query.
    SqlService
    SqlService can be used to execute adhoc queries, stored procedures, reports, and otherwise access the database directly.
  • Class Summary 
    Class Description
    AbstractSqlResultHandler
    Convenient base class for implementing SqlResultHandler.
    NamedMacro
    A named macro for use with SqlService, taking the form ${name:param1,param2,etc}.
    QueryRequest
    Encapsulates a request to execute a SQL query, parameters bound and optional paging constraints.
    ReportRequest
    Encapsulates all parameters need to execute a Report.
    SqlConstants
    Constants relevant to SQL queries.
    SqlDefQueryRequest
    Encapsulates a request to execute a SQL query which is stored in a SqlDef.
    SqlParams
    Used to pass SQL parameter values when executing a query with SqlService.
    SqlParams.Binding
    Captures a DaoDataType + value.
    SqlQueryRequest
    Encapsulates a request to execute a SQL query, including the query to be executed, parameters bound and optional paging constraints.
    SqlResult
    SqlResult is an in-memory collection of SqlRows fetched from the database.
    SqlResultMeta
    Describes the metadata related to a SqlResult.
    SqlRow
    Contains the result of a query executed through SqlService.
    TransactionSupport
    This class supports executing code blocks with different transaction semantics than the default of "Required".
  • Enum Summary 
    Enum Description
    SortDirection
    Sort direction - ascending or descending.
  • Exception Summary 
    Exception Description
    SqlResultHandlerException
    Can be thrown by SqlResultHandler to abort processing of query results