Uses of Package
org.apache.empire.db

Packages that use org.apache.empire.db

Package	Description
org.apache.empire.data.bean	This package contains implmentations of Empire's data and metadata interfaces for JavaBeans of Data Tranfer Objects (DTO's).
org.apache.empire.data.list
org.apache.empire.db	This package contains the core Empire-DB implementation classes.
org.apache.empire.db.context
org.apache.empire.db.exceptions	This package contains classes for exception handling of database related errors.
org.apache.empire.db.expr.column	This package contains SQL-generator classes for column expressions.
org.apache.empire.db.expr.compare	This package contains SQL-generator classes for compare expressions used in the where and having clause.
org.apache.empire.db.expr.join	This package contains SQL-generator classes for join expressions used in the from clause.
org.apache.empire.db.expr.order
org.apache.empire.db.expr.set	This package contains SQL-generator classes for set expressions used in the set clause.
org.apache.empire.db.generic
org.apache.empire.db.list
org.apache.empire.db.validation
org.apache.empire.dbms
org.apache.empire.dbms.derby	This package contains classes necessary to support the Apache Derby database system.
org.apache.empire.dbms.h2	This package contains classes necessary to support the H2 database system.
org.apache.empire.dbms.hsql	This package contains classes necessary to support the HSQLDB database system.
org.apache.empire.dbms.mysql	This package contains classes necessary to support the MySQL database system.
org.apache.empire.dbms.oracle	This package contains classes necessary to support the Oracle database system.
org.apache.empire.dbms.postgresql	This package contains classes necessary to support the PostgreSQL database system.
org.apache.empire.dbms.sqlite
org.apache.empire.dbms.sqlserver	This package contains classes necessary to support the Microsoft SQL-Server database system.
org.apache.empire.exceptions	This package contains classes for exception handling of general errors.

Classes in org.apache.empire.db used by org.apache.empire.data.bean

Class	Description
DBCommand	This abstract class handles the creation of the SQL-Commands.
DBContext	DBContext A context is required for every database operation
DBRowSet	This class is the base class for all the DBTable, DBView and DBQuery classes this class contains all the columns of the tables, views or queries

Classes in org.apache.empire.db used by org.apache.empire.data.list

Class	Description
DBDatabase	This abstract class is the applicaton's interface for a particular database schema.

Classes in org.apache.empire.db used by org.apache.empire.db

Class	Description
DBCmdParam	This class defines a parameter for a prepared statement query.
DBCmdParamList	DBCmdParamList This class handles command parameters for Prepared Statements
DBCmdParams	DBCmdParams Provides information about the command parameters used in a DBCommand
DBCmpType	This enum allocates the available compare types.
DBColumn	This is the base class for all database columns that have a physical representation.
DBColumnExpr	This class is the base class for all expressions that represent a single value.
DBCommand	This abstract class handles the creation of the SQL-Commands.
DBCommandExpr	This abstract class handles the creation of the SQL-Commands.
DBCommandExpr.DBCmdQuery
DBContext	DBContext A context is required for every database operation
DBDatabase	This abstract class is the applicaton's interface for a particular database schema.
DBDatabase.DBSystemDate	This class represents the database systems current date and time.
DBDDLGenerator.DDLActionType	DDLActionType for DDLScript generation
DBExpr	This abstract class is the base class for all database expression classes (e.g.
DBGeneratedValue	DBGeneratedValue Abstract base class for Auto generated values
DBIndex	This class handles the primary key for the tables.
DBIndex.DBIndexType
DBJoinType	DBJoinType contains the possibilities to join two database tables.
DBObject	Base class for all objects that directly or indirectly belong to a database including the database object itself.
DBQuery	This class can be used to wrap a query from a DBCommand and use it like a DBRowSet. You may use this class for two purposes: In oder to define subqueries simply define a command object with the subquery and wrap it inside a DBQuery.
DBQueryColumn
DBReader.DBReaderIterator	DBReaderIterator Base class for DBReader interators
DBRecord	This class represents a record from a database table, view or query The class provides methods to create, read, update and delete records If an Idendity-column (AUTOINC) is defined, the value will be set upon creation by the dbms to the next value If a Timestamp-column is defined the value will be automatically set and concurrent changes of the record will be detected If changes to the record are made, but a rollback on the connection is performed, the changes will be reverted (Rollback-Handling) The record is Serializable either if the provided DBContext is serializable, or if the Context is provided on deserialization in a derived class.
DBRecordBase	This abstract class provides write access to the fields of a record The class provides methods that are useful for frontend-form development like - providing information about the allowed values for a field (field options) - providing information about whether or not a field is visible to the user - providing information about whether or not a field is required (mandantory) - providing information about whether or not a field is read-only - providing information about whether a particular field value is valid - providing information about whether a field was modified since it was read from the database - providing information about whether the record was modified Also, field value changes, can be handled using the onFieldChanged event.
DBRecordBase.State
DBRecordBean	This class represents a record from a database table, view or query Other than DBRecord it is not permanently attached to a context or rowset Thus it has a Default constructor and is essentially a dynamic bean
DBRecordData	This class provides access to the fields of one data-row of a table, view or query The fields can be accessed either by Column or by index There are various accessor functions for many data types.
DBRelation	This class creates a DBReferene object for a foreing key relation.
DBRelation.DBCascadeAction	DBCascadeAction enum
DBRelation.DBReference
DBRowSet	This class is the base class for all the DBTable, DBView and DBQuery classes this class contains all the columns of the tables, views or queries
DBRowSet.FieldInitMode
DBRowSet.PartialMode
DBSQLBuilder	DBSQLBuilder This class is used for building a single SQL statement
DBSQLScript	DBSQLScript This class is a collection of sql command strings. The class is used for obtaining and executing DDL commands supplied by the database dbms (@see DBMSHandler.getDDLScript(DDLActionType, DBObject, DBSQLScript))
DBSQLScript.SQLStmt	SQLCmd
DBTable	This class represent one table of the database.
DBTableColumn	This class represent one column of a table.
DBUtils	DBUtils This class provides various query functions and functions for command execution.
DBView	This class represents a database view.
DBView.DBViewColumn	DBViewColumn
DBXmlDictionary	This class is used to configure XML generation as performed by the getXmlDocument Document function on DBReader and DBRecord.

Classes in org.apache.empire.db used by org.apache.empire.db.context

Class	Description
DBCommand	This abstract class handles the creation of the SQL-Commands.
DBContext	DBContext A context is required for every database operation
DBObject	Base class for all objects that directly or indirectly belong to a database including the database object itself.
DBTable	This class represent one table of the database.
DBUtils	DBUtils This class provides various query functions and functions for command execution.

Classes in org.apache.empire.db used by org.apache.empire.db.exceptions

Class	Description
DBCommandExpr	This abstract class handles the creation of the SQL-Commands.
DBDatabase	This abstract class is the applicaton's interface for a particular database schema.
DBObject	Base class for all objects that directly or indirectly belong to a database including the database object itself.
DBRecordBase	This abstract class provides write access to the fields of a record The class provides methods that are useful for frontend-form development like - providing information about the allowed values for a field (field options) - providing information about whether or not a field is visible to the user - providing information about whether or not a field is required (mandantory) - providing information about whether or not a field is read-only - providing information about whether a particular field value is valid - providing information about whether a field was modified since it was read from the database - providing information about whether the record was modified Also, field value changes, can be handled using the onFieldChanged event.
DBRowSet	This class is the base class for all the DBTable, DBView and DBQuery classes this class contains all the columns of the tables, views or queries

Classes in org.apache.empire.db used by org.apache.empire.db.expr.column

Class	Description
DBColumn	This is the base class for all database columns that have a physical representation.
DBColumnExpr	This class is the base class for all expressions that represent a single value.
DBCommand	This abstract class handles the creation of the SQL-Commands.
DBCommandExpr	This abstract class handles the creation of the SQL-Commands.
DBDatabase	This abstract class is the applicaton's interface for a particular database schema.
DBExpr	This abstract class is the base class for all database expression classes (e.g.
DBObject	Base class for all objects that directly or indirectly belong to a database including the database object itself.
DBRowSet	This class is the base class for all the DBTable, DBView and DBQuery classes this class contains all the columns of the tables, views or queries
DBSQLBuilder	DBSQLBuilder This class is used for building a single SQL statement

Classes in org.apache.empire.db used by org.apache.empire.db.expr.compare

Class	Description
DBCmpType	This enum allocates the available compare types.
DBColumn	This is the base class for all database columns that have a physical representation.
DBColumnExpr	This class is the base class for all expressions that represent a single value.
DBCommand	This abstract class handles the creation of the SQL-Commands.
DBCommandExpr	This abstract class handles the creation of the SQL-Commands.
DBDatabase	This abstract class is the applicaton's interface for a particular database schema.
DBExpr	This abstract class is the base class for all database expression classes (e.g.
DBObject	Base class for all objects that directly or indirectly belong to a database including the database object itself.
DBRowSet	This class is the base class for all the DBTable, DBView and DBQuery classes this class contains all the columns of the tables, views or queries
DBSQLBuilder	DBSQLBuilder This class is used for building a single SQL statement

Classes in org.apache.empire.db used by org.apache.empire.db.expr.join

Class	Description
DBColumn	This is the base class for all database columns that have a physical representation.
DBColumnExpr	This class is the base class for all expressions that represent a single value.
DBCommand	This abstract class handles the creation of the SQL-Commands.
DBDatabase	This abstract class is the applicaton's interface for a particular database schema.
DBExpr	This abstract class is the base class for all database expression classes (e.g.
DBJoinType	DBJoinType contains the possibilities to join two database tables.
DBObject	Base class for all objects that directly or indirectly belong to a database including the database object itself.
DBRowSet	This class is the base class for all the DBTable, DBView and DBQuery classes this class contains all the columns of the tables, views or queries
DBSQLBuilder	DBSQLBuilder This class is used for building a single SQL statement

Classes in org.apache.empire.db used by org.apache.empire.db.expr.order

Class	Description
DBColumn	This is the base class for all database columns that have a physical representation.
DBColumnExpr	This class is the base class for all expressions that represent a single value.
DBDatabase	This abstract class is the applicaton's interface for a particular database schema.
DBExpr	This abstract class is the base class for all database expression classes (e.g.
DBObject	Base class for all objects that directly or indirectly belong to a database including the database object itself.
DBSQLBuilder	DBSQLBuilder This class is used for building a single SQL statement

Classes in org.apache.empire.db used by org.apache.empire.db.expr.set

Class	Description
DBColumn	This is the base class for all database columns that have a physical representation.
DBCommand	This abstract class handles the creation of the SQL-Commands.
DBDatabase	This abstract class is the applicaton's interface for a particular database schema.
DBExpr	This abstract class is the base class for all database expression classes (e.g.
DBObject	Base class for all objects that directly or indirectly belong to a database including the database object itself.
DBRowSet	This class is the base class for all the DBTable, DBView and DBQuery classes this class contains all the columns of the tables, views or queries
DBSQLBuilder	DBSQLBuilder This class is used for building a single SQL statement

Classes in org.apache.empire.db used by org.apache.empire.db.generic

Class	Description
DBContext	DBContext A context is required for every database operation
DBDatabase	This abstract class is the applicaton's interface for a particular database schema.
DBExpr	This abstract class is the base class for all database expression classes (e.g.
DBObject	Base class for all objects that directly or indirectly belong to a database including the database object itself.
DBRecord	This class represents a record from a database table, view or query The class provides methods to create, read, update and delete records If an Idendity-column (AUTOINC) is defined, the value will be set upon creation by the dbms to the next value If a Timestamp-column is defined the value will be automatically set and concurrent changes of the record will be detected If changes to the record are made, but a rollback on the connection is performed, the changes will be reverted (Rollback-Handling) The record is Serializable either if the provided DBContext is serializable, or if the Context is provided on deserialization in a derived class.
DBRecordBase	This abstract class provides write access to the fields of a record The class provides methods that are useful for frontend-form development like - providing information about the allowed values for a field (field options) - providing information about whether or not a field is visible to the user - providing information about whether or not a field is required (mandantory) - providing information about whether or not a field is read-only - providing information about whether a particular field value is valid - providing information about whether a field was modified since it was read from the database - providing information about whether the record was modified Also, field value changes, can be handled using the onFieldChanged event.
DBRecordData	This class provides access to the fields of one data-row of a table, view or query The fields can be accessed either by Column or by index There are various accessor functions for many data types.
DBRowSet	This class is the base class for all the DBTable, DBView and DBQuery classes this class contains all the columns of the tables, views or queries
DBTable	This class represent one table of the database.
DBView	This class represents a database view.

Classes in org.apache.empire.db used by org.apache.empire.db.list

Class	Description
DBColumnExpr	This class is the base class for all expressions that represent a single value.
DBCommand	This abstract class handles the creation of the SQL-Commands.
DBCommandExpr	This abstract class handles the creation of the SQL-Commands.
DBContext	DBContext A context is required for every database operation
DBDatabase	This abstract class is the applicaton's interface for a particular database schema.
DBRecordBase	This abstract class provides write access to the fields of a record The class provides methods that are useful for frontend-form development like - providing information about the allowed values for a field (field options) - providing information about whether or not a field is visible to the user - providing information about whether or not a field is required (mandantory) - providing information about whether or not a field is read-only - providing information about whether a particular field value is valid - providing information about whether a field was modified since it was read from the database - providing information about whether the record was modified Also, field value changes, can be handled using the onFieldChanged event.
DBRecordBase.State
DBRecordData	This class provides access to the fields of one data-row of a table, view or query The fields can be accessed either by Column or by index There are various accessor functions for many data types.
DBRowSet	This class is the base class for all the DBTable, DBView and DBQuery classes this class contains all the columns of the tables, views or queries

Classes in org.apache.empire.db used by org.apache.empire.db.validation

Class	Description
DBColumn	This is the base class for all database columns that have a physical representation.
DBDatabase	This abstract class is the applicaton's interface for a particular database schema.
DBIndex	This class handles the primary key for the tables.
DBObject	Base class for all objects that directly or indirectly belong to a database including the database object itself.
DBRelation.DBReference
DBRowSet	This class is the base class for all the DBTable, DBView and DBQuery classes this class contains all the columns of the tables, views or queries
DBTable	This class represent one table of the database.
DBView	This class represents a database view.

Classes in org.apache.empire.db used by org.apache.empire.dbms

Class	Description
DBColumn	This is the base class for all database columns that have a physical representation.
DBColumnExpr	This class is the base class for all expressions that represent a single value.
DBCommand	This abstract class handles the creation of the SQL-Commands.
DBCommandExpr	This abstract class handles the creation of the SQL-Commands.
DBDatabase	This abstract class is the applicaton's interface for a particular database schema.
DBDDLGenerator.DDLActionType	DDLActionType for DDLScript generation
DBExpr	This abstract class is the base class for all database expression classes (e.g.
DBObject	Base class for all objects that directly or indirectly belong to a database including the database object itself.
DBRelation	This class creates a DBReferene object for a foreing key relation.
DBRowSet	This class is the base class for all the DBTable, DBView and DBQuery classes this class contains all the columns of the tables, views or queries
DBSQLBuilder	DBSQLBuilder This class is used for building a single SQL statement
DBSQLScript	DBSQLScript This class is a collection of sql command strings. The class is used for obtaining and executing DDL commands supplied by the database dbms (@see DBMSHandler.getDDLScript(DDLActionType, DBObject, DBSQLScript))
DBTable	This class represent one table of the database.
DBTableColumn	This class represent one column of a table.

Classes in org.apache.empire.db used by org.apache.empire.dbms.derby

Class	Description
DBColumnExpr	This class is the base class for all expressions that represent a single value.
DBDatabase	This abstract class is the applicaton's interface for a particular database schema.
DBDDLGenerator
DBDDLGenerator.DDLActionType	DDLActionType for DDLScript generation
DBObject	Base class for all objects that directly or indirectly belong to a database including the database object itself.
DBSQLBuilder	DBSQLBuilder This class is used for building a single SQL statement
DBSQLScript	DBSQLScript This class is a collection of sql command strings. The class is used for obtaining and executing DDL commands supplied by the database dbms (@see DBMSHandler.getDDLScript(DDLActionType, DBObject, DBSQLScript))
DBTableColumn	This class represent one column of a table.

Classes in org.apache.empire.db used by org.apache.empire.dbms.h2

Class	Description
DBColumnExpr	This class is the base class for all expressions that represent a single value.
DBCommand	This abstract class handles the creation of the SQL-Commands.
DBCommandExpr	This abstract class handles the creation of the SQL-Commands.
DBDatabase	This abstract class is the applicaton's interface for a particular database schema.
DBDDLGenerator
DBDDLGenerator.DDLActionType	DDLActionType for DDLScript generation
DBExpr	This abstract class is the base class for all database expression classes (e.g.
DBObject	Base class for all objects that directly or indirectly belong to a database including the database object itself.
DBSQLBuilder	DBSQLBuilder This class is used for building a single SQL statement
DBSQLScript	DBSQLScript This class is a collection of sql command strings. The class is used for obtaining and executing DDL commands supplied by the database dbms (@see DBMSHandler.getDDLScript(DDLActionType, DBObject, DBSQLScript))
DBTableColumn	This class represent one column of a table.

Classes in org.apache.empire.db used by org.apache.empire.dbms.hsql

Class	Description
DBColumnExpr	This class is the base class for all expressions that represent a single value.
DBCommand	This abstract class handles the creation of the SQL-Commands.
DBCommandExpr	This abstract class handles the creation of the SQL-Commands.
DBDatabase	This abstract class is the applicaton's interface for a particular database schema.
DBDDLGenerator
DBDDLGenerator.DDLActionType	DDLActionType for DDLScript generation
DBExpr	This abstract class is the base class for all database expression classes (e.g.
DBObject	Base class for all objects that directly or indirectly belong to a database including the database object itself.
DBRowSet	This class is the base class for all the DBTable, DBView and DBQuery classes this class contains all the columns of the tables, views or queries
DBSQLBuilder	DBSQLBuilder This class is used for building a single SQL statement
DBSQLScript	DBSQLScript This class is a collection of sql command strings. The class is used for obtaining and executing DDL commands supplied by the database dbms (@see DBMSHandler.getDDLScript(DDLActionType, DBObject, DBSQLScript))
DBTableColumn	This class represent one column of a table.

Classes in org.apache.empire.db used by org.apache.empire.dbms.mysql

Class	Description
DBColumnExpr	This class is the base class for all expressions that represent a single value.
DBCommand	This abstract class handles the creation of the SQL-Commands.
DBCommandExpr	This abstract class handles the creation of the SQL-Commands.
DBDatabase	This abstract class is the applicaton's interface for a particular database schema.
DBDDLGenerator
DBDDLGenerator.DDLActionType	DDLActionType for DDLScript generation
DBExpr	This abstract class is the base class for all database expression classes (e.g.
DBObject	Base class for all objects that directly or indirectly belong to a database including the database object itself.
DBRowSet	This class is the base class for all the DBTable, DBView and DBQuery classes this class contains all the columns of the tables, views or queries
DBSQLBuilder	DBSQLBuilder This class is used for building a single SQL statement
DBSQLScript	DBSQLScript This class is a collection of sql command strings. The class is used for obtaining and executing DDL commands supplied by the database dbms (@see DBMSHandler.getDDLScript(DDLActionType, DBObject, DBSQLScript))
DBTable	This class represent one table of the database.
DBTableColumn	This class represent one column of a table.
DBView	This class represents a database view.

Classes in org.apache.empire.db used by org.apache.empire.dbms.oracle

Class	Description
DBCmdParams	DBCmdParams Provides information about the command parameters used in a DBCommand
DBColumn	This is the base class for all database columns that have a physical representation.
DBColumnExpr	This class is the base class for all expressions that represent a single value.
DBCommand	This abstract class handles the creation of the SQL-Commands.
DBCommandExpr	This abstract class handles the creation of the SQL-Commands.
DBContext	DBContext A context is required for every database operation
DBDatabase	This abstract class is the applicaton's interface for a particular database schema.
DBDDLGenerator
DBDDLGenerator.DDLActionType	DDLActionType for DDLScript generation
DBExpr	This abstract class is the base class for all database expression classes (e.g.
DBIndex	This class handles the primary key for the tables.
DBMaterializedView	DBMaterializedView This interface should be used in conjunction with a DBView to indicate that the view is materialized
DBObject	Base class for all objects that directly or indirectly belong to a database including the database object itself.
DBRelation	This class creates a DBReferene object for a foreing key relation.
DBRowSet	This class is the base class for all the DBTable, DBView and DBQuery classes this class contains all the columns of the tables, views or queries
DBSQLBuilder	DBSQLBuilder This class is used for building a single SQL statement
DBSQLScript	DBSQLScript This class is a collection of sql command strings. The class is used for obtaining and executing DDL commands supplied by the database dbms (@see DBMSHandler.getDDLScript(DDLActionType, DBObject, DBSQLScript))
DBTable	This class represent one table of the database.
DBTableColumn	This class represent one column of a table.
DBView	This class represents a database view.

Classes in org.apache.empire.db used by org.apache.empire.dbms.postgresql

Class	Description
DBColumn	This is the base class for all database columns that have a physical representation.
DBColumnExpr	This class is the base class for all expressions that represent a single value.
DBCommand	This abstract class handles the creation of the SQL-Commands.
DBCommandExpr	This abstract class handles the creation of the SQL-Commands.
DBDatabase	This abstract class is the applicaton's interface for a particular database schema.
DBDDLGenerator
DBDDLGenerator.DDLActionType	DDLActionType for DDLScript generation
DBExpr	This abstract class is the base class for all database expression classes (e.g.
DBObject	Base class for all objects that directly or indirectly belong to a database including the database object itself.
DBRowSet	This class is the base class for all the DBTable, DBView and DBQuery classes this class contains all the columns of the tables, views or queries
DBSQLBuilder	DBSQLBuilder This class is used for building a single SQL statement
DBSQLScript	DBSQLScript This class is a collection of sql command strings. The class is used for obtaining and executing DDL commands supplied by the database dbms (@see DBMSHandler.getDDLScript(DDLActionType, DBObject, DBSQLScript))
DBTableColumn	This class represent one column of a table.

Classes in org.apache.empire.db used by org.apache.empire.dbms.sqlite

Class	Description
DBColumnExpr	This class is the base class for all expressions that represent a single value.
DBCommand	This abstract class handles the creation of the SQL-Commands.
DBCommandExpr	This abstract class handles the creation of the SQL-Commands.
DBDatabase	This abstract class is the applicaton's interface for a particular database schema.
DBDDLGenerator
DBDDLGenerator.DDLActionType	DDLActionType for DDLScript generation
DBExpr	This abstract class is the base class for all database expression classes (e.g.
DBObject	Base class for all objects that directly or indirectly belong to a database including the database object itself.
DBRelation	This class creates a DBReferene object for a foreing key relation.
DBSQLScript	DBSQLScript This class is a collection of sql command strings. The class is used for obtaining and executing DDL commands supplied by the database dbms (@see DBMSHandler.getDDLScript(DDLActionType, DBObject, DBSQLScript))
DBTable	This class represent one table of the database.
DBTableColumn	This class represent one column of a table.

Classes in org.apache.empire.db used by org.apache.empire.dbms.sqlserver

Class	Description
DBColumnExpr	This class is the base class for all expressions that represent a single value.
DBCommand	This abstract class handles the creation of the SQL-Commands.
DBCommandExpr	This abstract class handles the creation of the SQL-Commands.
DBDatabase	This abstract class is the applicaton's interface for a particular database schema.
DBDDLGenerator
DBDDLGenerator.DDLActionType	DDLActionType for DDLScript generation
DBExpr	This abstract class is the base class for all database expression classes (e.g.
DBIndex	This class handles the primary key for the tables.
DBObject	Base class for all objects that directly or indirectly belong to a database including the database object itself.
DBRelation	This class creates a DBReferene object for a foreing key relation.
DBSQLBuilder	DBSQLBuilder This class is used for building a single SQL statement
DBSQLScript	DBSQLScript This class is a collection of sql command strings. The class is used for obtaining and executing DDL commands supplied by the database dbms (@see DBMSHandler.getDDLScript(DDLActionType, DBObject, DBSQLScript))
DBTableColumn	This class represent one column of a table.
DBView	This class represents a database view.

Classes in org.apache.empire.db used by org.apache.empire.exceptions

Class	Description
DBRowSet	This class is the base class for all the DBTable, DBView and DBQuery classes this class contains all the columns of the tables, views or queries