borland Packages  borland Class Hierarchy

Package borland.sql.dataset


About the borland.sql.dataset package

The borland.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 borland.jbcl.dataset package, which provides general routines for data connectivity, management and manipulation.

The borland.sql.dataset package includes the following types of functionality:
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.
 

Visit the database newsgroup on the Borland Web page at news://forums.borland.com/borland.public.jbuilder.database. This newsgroup is dedicated to issues about writing database applications in JBuilder and is actively monitored by our support engineers as well as the JBuilder Development team.

See also:


Interfaces

  • ConnectionUpdateListener
  • DefaultResolver
  • Load
  • Task
  • TransactionSupport
  • Classes and Components

  • ConnectionDescriptor
  • ConnectionUpdateAdapter
  • ConnectionUpdateEvent
  • Database
  • DatabaseBeanInfo
  • DesignerConnectionCache
  • OracleProcedureProvider
  • ProcedureDataSet
  • ProcedureDataSetBeanInfo
  • ProcedureDescriptor
  • ProcedureProvider
  • ProcedureResolver
  • ProcedureResolverBeanInfo
  • QueryDataSet
  • QueryDataSetBeanInfo
  • QueryDescriptor
  • QueryProvider
  • QueryResolver
  • QueryResolverBeanInfo
  • ResolutionException
  • ResTable
  • RuntimeMetaData
  • SQLDialect
  • SqlElement
  • SQLResolutionManager
  • SQLResolver
  • UniqueQueryAnalyzer

  • Overview of classes in the borland.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. Can be configured via the UI Designer, to show connection history, test the connection, and register drivers with JDBC.
    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. Easy to use via the UI Designer.

    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.