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 implementingSqlResultHandler.NamedMacro A named macro for use withSqlService, 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 withSqlService.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 ofSqlRows fetched from the database.SqlResultMeta Describes the metadata related to a SqlResult.SqlRow Contains the result of a query executed throughSqlService.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 bySqlResultHandlerto abort processing of query results