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
Classes and Components
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.