com.borland Packages  com.borland Class Hierarchy

Chapter 5
dx.sql.dataset package


About the com.borland.dx.sql.dataset package

The dx.sql.dataset package contains classes and interfaces that provide data connectivity functionality that is JDBC specific. It collects specific provider/resolver implementations for better support of multi-tier designs and other provider/resolver implementations. Its classes are used in conjunction with those in the com.borland.dx.dataset package, which provides general routines for data connectivity, management, and manipulation.

The dx.sql.dataset package includes the following types of functionality:

Functionality in dx.sql.dataset

Connection    Login to remote data servers through JDBC, and handling of connection events.
Providing     Obtaining data from the remote database through SQL statements or stored procedures.
Resolving Updating of data from the local DataSet back to the original source of the data.

The dx.sql.dataset package contains the following types of classes:

This package includes the following BeanInfo classes:

The following classes, components, and interfaces in this package are used internally by classes in this and other com.borland packages. These classes, components, and interfaces are not intended for general use and are not documented. Do not use them directly in your application.

For more information, visit the database newsgroup. Details on newsgroups can be found at http://www.borland.com/newsgroups. The database newsgroup is dedicated to issues about writing database applications and is actively monitored by our support engineers as well as the Development team.

See also:
Overview of classes in this package
com.borland.dx.dataset package
Library overview


Interfaces

  • ConnectionUpdateListener
  • DefaultResolver
  • Load
  • SQLDialect
  • SQLToken
  • Task
  • TransactionSupport
  • Classes and components

  • ConnectionDescriptor
  • ConnectionUpdateAdapter
  • ConnectionUpdateEvent
  • Database
  • DatabaseBeanInfo
  • DataModelProvider
  • DesignerConnectionCache
  • JdbcProvider
  • OracleProcedureProvider
  • ProcedureDataSet
  • ProcedureDataSetBeanInfo
  • ProcedureDescriptor
  • ProcedureProvider
  • ProcedureResolver
  • ProcedureResolverBeanInfo
  • QueryDataSet
  • QueryDataSetBeanInfo
  • QueryDescriptor
  • QueryProvider
  • QueryResolver
  • QueryResolverBeanInfo
  • ResolutionException
  • ResolutionManager
  • ResolveError
  • RuntimeMetaData
  • SQLElement
  • SQLResolutionManager
  • SQLResolver
  • UniqueQueryAnalyzer

  • Overview of classes in the com.borland.dx.sql.dataset package

    Connecting and data set classes

    Database
    Encapsulates a database connection through JDBC to a SQL server and provides lightweight transaction support using local caching. Required for accessing data on a SQL server.

    ProcedureDataSet
    Extends StorageDataSet, to run a stored procedure against a SQL database. Supports executing stored procedures via a SQL query.
    QueryDataSet
    Extends StorageDataSet, to run a query statement against a table in a SQL database. Requires a Database component and a QueryDescriptor. The query result set is stored in this component, allowing flexible navigation of the results.

    Event, listener, and adapter classes

    ConnectionUpdateEvent
    Used when a database connection is about to close, or is closed. Also used when the transaction isolationLevel has changed.
    ConnectionUpdateListener
    A listener interface for ConnectionUpdateEvent.
    ConnectionUpdateAdapter
    An adapter class for ConnectionUpdateListener.

    Descriptor classes

    ConnectionDescriptor
    Stores properties related to connecting to a SQL database, such as the connection URL, user name, and password. Required for accessing data on a SQL server.
    ProcedureDescriptor
    Stores properties of a stored procedure (ProcedureDataSet) against a SQL database.
    QueryDescriptor
    Stores properties that set a query statement to run against a SQL database. Required for accessing SQL table data.

    Exception classes

    ResolutionException
    Used whenever there is an error during resolution of a DataSet. Extends DataSetException.

    Provider classes

    Load
    Constants that determine how data is loaded into a DataSet.
    OracleProcedureProvider
    A provider class for Oracle stored procedures.
    ProcedureProvider
    A provider component for stored procedures.
    QueryProvider
    A provider class for queries executed against a SQL database.

    Resolver classes

    DefaultResolver
    An interface for resolver functionality.
    ProcedureResolver
    A class implementing DefaultResolver specifically for resolving data changes using a stored procedure.
    QueryResolver
    Used to customize DataSet resolving events and properties.
    SQLResolver
    Allows for alternate implementations of the behavior required to save changes made to a DataSet to its database data source.
    SQLResolutionManager
    Manages the resolution of one or more DataSets to a Database component.

    Miscellaneous dataset classes

    SQLDialect
    Defines constants for SQL database servers.