Uses of Class
org.apache.empire.db.DBObject
Packages that use DBObject
Package
Description
This package contains the core Empire-DB implementation classes.
This package contains classes for exception handling of database related errors.
This package contains SQL-generator classes for column expressions.
This package contains SQL-generator classes for compare expressions used in the where and having clause.
This package contains SQL-generator classes for join expressions used in the from clause.
This package contains SQL-generator classes for set expressions used in the set clause.
This package contains classes necessary to support the Apache Derby database system.
This package contains classes necessary to support the H2 database system.
This package contains classes necessary to support the HSQLDB database system.
This package contains classes necessary to support the MySQL database system.
This package contains classes necessary to support the Oracle database system.
This package contains classes necessary to support the PostgreSQL database system.
This package contains classes necessary to support the Microsoft SQL-Server database system.
-
Uses of DBObject in org.apache.empire.db
Subclasses of DBObject in org.apache.empire.dbModifier and TypeClassDescriptionclassThis class defines a parameter for a prepared statement query.classThis is the base class for all database columns that have a physical representation.classThis class is the base class for all expressions that represent a single value.classThis class is used for combining two DBCommandExpr objects to a new single DBCommandExpr This may be used to create "UNION" or "INTERSECT" queriesclassThis abstract class handles the creation of the SQL-Commands.classThis abstract class handles the creation of the SQL-Commands.protected static classThis class wraps a column of sql command in a special command column object.protected static classclassThis abstract class is the applicaton's interface for a particular database schema.classThis abstract class is the base class for all database expression classes (e.g.classThis class allows to create an expression based indexclassDBGeneratedValue Abstract base class for Auto generated valuesstatic classDBFuncGeneratedValue Auto-generates a record value from other record fields The template must contain the column names wrapped in square brackets like e.g.static classDBTriggerGeneratedValue Value is generated by TriggerclassThis class handles the primary key for the tables.classThis 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.classclassThis class is used to perform database queries from a DBCommand object and access the results.
In oder to perform a query call the open() function or - for single row queries - call getRecordData();
You can iterate through the rows using moveNext() or an iterator.classThis 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.classThis 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.classThis 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 beanclassThis 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.classThis class creates a DBReferene object for a foreing key relation.classThis class is the base class for all the DBTable, DBView and DBQuery classes this class contains all the columns of the tables, views or queriesclassThis class represent one table of the database.classThis class represent one column of a table.classThis class represents a database view.static classDBViewColumnMethods in org.apache.empire.db that return DBObjectMethods in org.apache.empire.db with parameters of type DBObjectModifier and TypeMethodDescriptionvoidDBDDLGenerator.getDDLScript(DBDDLGenerator.DDLActionType type, DBObject dbo, DBSQLScript script) Appends the required DLL commands to create, drop or alter an object to the supplied DBDQLScript.voidDBContext.removeRollbackHandler(DBObject object) -
Uses of DBObject in org.apache.empire.db.context
Methods in org.apache.empire.db.context that return DBObjectMethods in org.apache.empire.db.context with parameters of type DBObjectModifier and TypeMethodDescriptionvoidDBRollbackManager.removeHandler(Connection conn, DBObject object) Remove the rollback handler for a particular Connection and ObjectvoidDBContextBase.removeRollbackHandler(DBObject object) -
Uses of DBObject in org.apache.empire.db.exceptions
Methods in org.apache.empire.db.exceptions with parameters of type DBObjectModifier and TypeMethodDescriptionprotected static DBMSHandlerEmpireSQLException.handlerFromObject(DBObject obj) Constructors in org.apache.empire.db.exceptions with parameters of type DBObjectModifierConstructorDescriptionEmpireSQLException(DBObject obj, SQLException cause) QueryFailedException(DBObject obj, String sqlCmd, String sqlParams, SQLException cause) -
Uses of DBObject in org.apache.empire.db.expr.column
Subclasses of DBObject in org.apache.empire.db.expr.columnModifier and TypeClassDescriptionclassThis implements some basic functionality for SQL functions based on a column expressionclassThis class allows column renaming in SQL.classThis class is used for performing calculations in SQL
It handles the mathematical operations ("+", "-", "*", "/") for the current column.classThis class represents a SQL case expression like "case when ?classThis class is used to create a SQL CASE constraint in the form of case {expr} when {value1} then {result1} when {value2} then {result2} ...classThis class is used to create a SQL CASE constraint in the form of case when {cond1} then {result1} when {cond2} then {result2} ...classclassclassThis class is used for performing string concatenation in SQLclassDBConcatExpressionclassThis class is used to convert a value to a different data type.classThis class is used to add the "count" statement to the SQL-Command.classThis class is used to decode a set of keys to the corresponding target values.classThis class is used for performing various SQL functions on a column or column expression.classThis class allows column renaming in SQL.classThis class is used for declaring scalar functions in SQL (like e.g. random).classThis class is used for declaring constant values in SQL.class -
Uses of DBObject in org.apache.empire.db.expr.compare
Subclasses of DBObject in org.apache.empire.db.expr.compareModifier and TypeClassDescriptionclassThis class is used for combining two filter constraints by and / or operatorclassThis class is used for defining filter constraints based on a column expression in SQLclassThis class is a common base class for all SQL filter constraints classesclassThis class is used for defining filter constraints based on a column expression in SQLclassThis class wraps an existing compare expression with parenthesis.classThis class is used for building up the SQL-Command for the EXISTS syntax. -
Uses of DBObject in org.apache.empire.db.expr.join
Subclasses of DBObject in org.apache.empire.db.expr.joinModifier and TypeClassDescriptionclassclassThis class is used for building a join expression of an SQL statement.classThis class is used for building a join expression of an SQL statement.classThis class is used for building a join expression of an SQL statement. -
Uses of DBObject in org.apache.empire.db.expr.order
Subclasses of DBObject in org.apache.empire.db.expr.order -
Uses of DBObject in org.apache.empire.db.expr.set
Subclasses of DBObject in org.apache.empire.db.expr.setModifier and TypeClassDescriptionclassThis class is used for building a set expression of a SQL update statement. -
Uses of DBObject in org.apache.empire.db.generic
Subclasses of DBObject in org.apache.empire.db.generic -
Uses of DBObject in org.apache.empire.db.validation
Methods in org.apache.empire.db.validation with parameters of type DBObjectModifier and TypeMethodDescriptionvoidDBModelErrorHandler.itemNotFound(DBObject dbo) This method is called when an object (e. g. table or column) is missing in the database.voidDBModelErrorLogger.itemNotFound(DBObject dbo) handle itemNotFound errorsvoidDBModelErrorHandler.objectTypeMismatch(DBObject object, String name, Class<?> expectedType) This method is called when an object (e. g. table or column) is missing in the database.voidDBModelErrorLogger.objectTypeMismatch(DBObject object, String name, Class<?> expectedType) handle objectTypeMismatch errors -
Uses of DBObject in org.apache.empire.dbms
Subclasses of DBObject in org.apache.empire.dbmsModifier and TypeClassDescriptionstatic final classDBMSCommand A Default DBCommand implementation with no additional featuresstatic classThis class is used to emulate sequences by using a sequence table.Methods in org.apache.empire.dbms with parameters of type DBObjectModifier and TypeMethodDescriptionbooleanDBMSHandler.detectQuoteName(DBObject object, String name) Returns true if a name needs to be wrapped in quotes or false otherwisebooleanDBMSHandlerBase.detectQuoteName(DBObject object, String name) Detects whether a table or column name needs to be quoted or not
By default all reserved SQL keywords as well as names containing a "-", "/", "+" or " " require quoting.
Overrides this function to add database specific keywords like "user" or "count"voidDBMSHandler.getDDLScript(DBDDLGenerator.DDLActionType type, DBObject dbo, DBSQLScript script) Appends the required DLL commands to create, drop or alter an object to the supplied DBDQLScript. -
Uses of DBObject in org.apache.empire.dbms.derby
Methods in org.apache.empire.dbms.derby with parameters of type DBObjectModifier and TypeMethodDescriptionvoidDBMSHandlerDerby.getDDLScript(DBDDLGenerator.DDLActionType type, DBObject dbo, DBSQLScript script) -
Uses of DBObject in org.apache.empire.dbms.h2
Subclasses of DBObject in org.apache.empire.dbms.h2Modifier and TypeClassDescriptionstatic classDefines the H2 command type.Methods in org.apache.empire.dbms.h2 with parameters of type DBObjectModifier and TypeMethodDescriptionvoidDBMSHandlerH2.getDDLScript(DBDDLGenerator.DDLActionType type, DBObject dbo, DBSQLScript script) -
Uses of DBObject in org.apache.empire.dbms.hsql
Subclasses of DBObject in org.apache.empire.dbms.hsqlModifier and TypeClassDescriptionclassThis class handles the special features of an HSqlDB database.Methods in org.apache.empire.dbms.hsql with parameters of type DBObjectModifier and TypeMethodDescriptionvoidDBMSHandlerHSql.getDDLScript(DBDDLGenerator.DDLActionType type, DBObject dbo, DBSQLScript script) voidHSqlDDLGenerator.getDDLScript(DBDDLGenerator.DDLActionType type, DBObject dbo, DBSQLScript script) -
Uses of DBObject in org.apache.empire.dbms.mysql
Subclasses of DBObject in org.apache.empire.dbms.mysqlModifier and TypeClassDescriptionstatic classDefines the MySQL command type.Methods in org.apache.empire.dbms.mysql with parameters of type DBObjectModifier and TypeMethodDescriptionvoidDBMSHandlerMySQL.getDDLScript(DBDDLGenerator.DDLActionType type, DBObject dbo, DBSQLScript script) -
Uses of DBObject in org.apache.empire.dbms.oracle
Subclasses of DBObject in org.apache.empire.dbms.oracleModifier and TypeClassDescriptionclassThis class handles the special features of an oracle database.classimplements a column expression for the Oracle rownum functionclassRepresents the data model of the system tables.static classstatic classstatic classstatic classstatic classMethods in org.apache.empire.dbms.oracle with parameters of type DBObjectModifier and TypeMethodDescriptionvoidDBMSHandlerOracle.getDDLScript(DBDDLGenerator.DDLActionType type, DBObject dbo, DBSQLScript script) voidOracleDDLGenerator.getDDLScript(DBDDLGenerator.DDLActionType type, DBObject dbo, DBSQLScript script) -
Uses of DBObject in org.apache.empire.dbms.postgresql
Subclasses of DBObject in org.apache.empire.dbms.postgresqlModifier and TypeClassDescriptionclassDefines the PostgreSQL command type.classPostgresAtAt create a Postgres @@ comparatorclassclassclassMethods in org.apache.empire.dbms.postgresql with parameters of type DBObjectModifier and TypeMethodDescriptionvoidDBMSHandlerPostgreSQL.getDDLScript(DBDDLGenerator.DDLActionType type, DBObject dbo, DBSQLScript script) -
Uses of DBObject in org.apache.empire.dbms.sqlite
Subclasses of DBObject in org.apache.empire.dbms.sqliteModifier and TypeClassDescriptionstatic classDefines the SQLite command type.Methods in org.apache.empire.dbms.sqlite with parameters of type DBObjectModifier and TypeMethodDescriptionvoidDBMSHandlerSQLite.getDDLScript(DBDDLGenerator.DDLActionType type, DBObject dbo, DBSQLScript script) -
Uses of DBObject in org.apache.empire.dbms.sqlserver
Subclasses of DBObject in org.apache.empire.dbms.sqlserverModifier and TypeClassDescriptionstatic classProvides a DBCommand implementation for Microsoft SQL-ServerMethods in org.apache.empire.dbms.sqlserver with parameters of type DBObjectModifier and TypeMethodDescriptionvoidDBMSHandlerMSSQL.getDDLScript(DBDDLGenerator.DDLActionType type, DBObject dbo, DBSQLScript script) voidMSSqlDDLGenerator.getDDLScript(DBDDLGenerator.DDLActionType type, DBObject dbo, DBSQLScript script)