A B C D E F G H I J K L M N O P Q R S T U V W X Y

A

abs() - Method in class org.apache.empire.db.DBColumnExpr

Creates and returns a sql-expression for the absolute abs() function.

add(Attributes.Attribute) - Method in class org.apache.empire.commons.Attributes

add(Object, String, boolean) - Method in class org.apache.empire.commons.Options

Adds an object, the check for an existing can be skipped for performance issues (not recommended!)

add(OptionEntry) - Method in class org.apache.empire.commons.Options

addAlterTableStmt(DBColumn, StringBuilder, DBSQLScript) - Method in class org.apache.empire.db.DBDDLGenerator

addClass(BeanClass) - Method in class org.apache.empire.data.bean.BeanDomain

addColumn(DBTableColumn) - Method in class org.apache.empire.db.DBTable

Adds a column to this table's column list.

addColumn(String, DataType, double, DataMode, Object) - Method in class org.apache.empire.db.DBTable

Creates a new DBTableColumn object and adds it to the column collection.

addColumn(String, DataType, double, DataMode) - Method in class org.apache.empire.db.DBTable

Creates a new DBTableColumn object and adds it to the column collection.

addColumn(String, DataType, double, boolean, Object) - Method in class org.apache.empire.db.DBTable

Creates a new DBTableColumn object and adds it to the column collection.

addColumn(String, DataType, double, boolean) - Method in class org.apache.empire.db.DBTable

Creates a new DBTableColumn object and adds it to the column collection.

addColumn(DBView.DBViewColumn) - Method in class org.apache.empire.db.DBView

Adds a column to the view.

addColumn(String, DataType) - Method in class org.apache.empire.db.DBView

Adds a column to the view.

addColumn(String, DBColumnExpr) - Method in class org.apache.empire.db.DBView

Adds a column to the view.

addColumn(DBTableColumn) - Method in class org.apache.empire.db.DBView

Adds a column to the view based on an existing column in another table or view.

addColumnDesc(Element) - Method in class org.apache.empire.db.DBReader

Moves the cursor down one row from its current position.

addColumnDesc(Element) - Method in class org.apache.empire.db.DBRecord

This function set the field descriptions to the the XML tag.

addColumnDesc(Element) - Method in class org.apache.empire.db.DBRecordData

addColumnReference(DBColumn, DBColumn) - Method in class org.apache.empire.db.DBRowSet

Adds a column reference to the list of table references.

addCompareExpr(StringBuilder, long) - Method in class org.apache.empire.db.expr.compare.DBCompareColExpr

Add the comparison operator and value to the SQL-Command.

addCreateIndexStmt(DBIndex, StringBuilder, DBSQLScript) - Method in class org.apache.empire.db.DBDDLGenerator

addCreateRelationStmt(DBRelation, StringBuilder, DBSQLScript) - Method in class org.apache.empire.db.DBDDLGenerator

addCreateTableStmt(DBTable, StringBuilder, DBSQLScript) - Method in class org.apache.empire.db.DBDDLGenerator

addCreateViewStmt(DBView, StringBuilder, DBSQLScript) - Method in class org.apache.empire.db.DBDDLGenerator

addDate(Date, int, int, int) - Static method in class org.apache.empire.commons.DateUtils

Calculates a date relative to the supplied date.

addElement(Node, String, String) - Static method in class org.apache.empire.xml.XMLUtil

Adds a new child element to a parent.

addElement(Element, String) - Static method in class org.apache.empire.xml.XMLUtil

Adds a child element to the parent.

addElementNS(Node, String, String, String) - Static method in class org.apache.empire.xml.XMLUtil

Adds a new child element to a parent with a namespace.

addElementNS(Element, String, String) - Static method in class org.apache.empire.xml.XMLUtil

addFrom(StringBuilder) - Method in class org.apache.empire.db.DBCommand

addGrouping(StringBuilder) - Method in class org.apache.empire.db.DBCommand

addIndex(DBIndex) - Method in class org.apache.empire.db.DBTable

Adds an index.

addIndex(String, boolean, DBColumn[]) - Method in class org.apache.empire.db.DBTable

Adds an index.

addJoinRestriction(DBCommand, DBColumn, DBColumn, DBColumn[], DBRecord) - Method in class org.apache.empire.db.DBQuery

Adds join restrictions to the supplied command object.

addJoins(List<DBJoinExpr>) - Method in class org.apache.empire.db.DBCommand

Adds a list of join expressions to the command.

addJoins(List<DBJoinExpr>) - Method in class org.apache.empire.db.sqlite.DBDatabaseDriverSQLite.DBCommandSQLite

addListExpr(StringBuilder, List<? extends DBExpr>, long, String) - Method in class org.apache.empire.db.DBCommandExpr

Internally used to build a string from a list of database expressions

addNamespaceURIs(Document, Map<String, String>) - Static method in class org.apache.empire.xml.XMLUtil

addOrder(StringBuilder) - Method in class org.apache.empire.db.DBCommand

addParam(DataType, Object) - Method in class org.apache.empire.db.DBCommand

Adds an command parameter which will be used in a prepared statement.

addParam(DBColumnExpr, Object) - Method in class org.apache.empire.db.DBCommand

Adds an command parameter which will be used in a prepared statement.

addParam(Object) - Method in class org.apache.empire.db.DBCommand

Adds an command parameter which will be used in a prepared statement.

addParam() - Method in class org.apache.empire.db.DBCommand

Adds an command parameter which will be used in a prepared statement.

addProp(BeanProperty) - Method in class org.apache.empire.data.bean.BeanClass

addProp(String, DataType, double, DataMode, String) - Method in class org.apache.empire.data.bean.BeanClass

addProp(String, DataType, double, DataMode) - Method in class org.apache.empire.data.bean.BeanClass

addProp(String, DataType, double, boolean, String, boolean) - Method in class org.apache.empire.data.bean.BeanClass

addProp(String, DataType, double, boolean, String) - Method in class org.apache.empire.data.bean.BeanClass

addProp(String, DataType, double, boolean) - Method in class org.apache.empire.data.bean.BeanClass

addReferencedColumns(Set<DBColumn>) - Method in class org.apache.empire.db.DBCmdParam

addReferencedColumns(Set<DBColumn>) - Method in class org.apache.empire.db.DBColumn

addReferencedColumns(Set<DBColumn>) - Method in class org.apache.empire.db.DBCombinedCmd

addReferencedColumns(Set<DBColumn>) - Method in class org.apache.empire.db.DBCommand

Adds Columns

addReferencedColumns(Set<DBColumn>) - Method in class org.apache.empire.db.DBCommandExpr.DBCmdQuery

addReferencedColumns(Set<DBColumn>) - Method in class org.apache.empire.db.DBExpr

Internal function to obtain all DBColumnExpr-objects used by this expression.

addReferencedColumns(Set<DBColumn>) - Method in class org.apache.empire.db.DBRowSet

addReferencedColumns(Set<DBColumn>) - Method in class org.apache.empire.db.expr.column.DBAbstractFuncExpr

addReferencedColumns(Set<DBColumn>) - Method in class org.apache.empire.db.expr.column.DBAliasExpr

addReferencedColumns(Set<DBColumn>) - Method in class org.apache.empire.db.expr.column.DBCalcExpr

addReferencedColumns(Set<DBColumn>) - Method in class org.apache.empire.db.expr.column.DBCaseExpr

addReferencedColumns(Set<DBColumn>) - Method in class org.apache.empire.db.expr.column.DBConcatExpr

addReferencedColumns(Set<DBColumn>) - Method in class org.apache.empire.db.expr.column.DBCountExpr

addReferencedColumns(Set<DBColumn>) - Method in class org.apache.empire.db.expr.column.DBDecodeExpr

addReferencedColumns(Set<DBColumn>) - Method in class org.apache.empire.db.expr.column.DBValueExpr

addReferencedColumns(Set<DBColumn>) - Method in class org.apache.empire.db.expr.compare.DBCompareAndOrExpr

addReferencedColumns(Set<DBColumn>) - Method in class org.apache.empire.db.expr.compare.DBCompareColExpr

addReferencedColumns(Set<DBColumn>) - Method in class org.apache.empire.db.expr.compare.DBCompareNotExpr

addReferencedColumns(Set<DBColumn>) - Method in class org.apache.empire.db.expr.compare.DBExistsExpr

addReferencedColumns(Set<DBColumn>) - Method in class org.apache.empire.db.expr.compare.DBParenthesisExpr

addReferencedColumns(Set<DBColumn>) - Method in class org.apache.empire.db.expr.join.DBJoinExpr

addReferencedColumns(Set<DBColumn>) - Method in class org.apache.empire.db.expr.order.DBOrderByExpr

addReferencedColumns(Set<DBColumn>) - Method in class org.apache.empire.db.expr.set.DBSetExpr

addReferencedColumns(Set<DBColumn>) - Method in class org.apache.empire.db.oracle.OracleRowNumExpr

addRelation(DBRelation.DBReference) - Method in class org.apache.empire.db.DBDatabase

Adds a foreign key relation to the database.

addRelation(DBRelation.DBReference, DBRelation.DBReference) - Method in class org.apache.empire.db.DBDatabase

Add a foreign key relation to the database.

addRelation(String, DBRelation.DBReference[]) - Method in class org.apache.empire.db.DBDatabase

Adds a foreign key relation to the database.

addRows(Element) - Method in class org.apache.empire.db.DBReader

Adds all children to a parent.

addRowValues(Element) - Method in class org.apache.empire.db.DBReader

Adds all children to a parent.

addRowValues(Element) - Method in class org.apache.empire.db.DBRecord

Add the values of this record to the specified XML Element object.

addRowValues(Element) - Method in class org.apache.empire.db.DBRecordData

addSelect(StringBuilder) - Method in class org.apache.empire.db.DBCommand

addSelect(StringBuilder) - Method in class org.apache.empire.db.sqlserver.DBDatabaseDriverMSSQL.DBCommandMSSQL

addSQL(StringBuilder, long) - Method in class org.apache.empire.db.DBCmdParam

addSQL(StringBuilder, long) - Method in class org.apache.empire.db.DBColumn

Adds the colunm name to the SQL-Command.

addSQL(StringBuilder, long) - Method in class org.apache.empire.db.DBCommandExpr

Creates the SQL-Command.

addSQL(StringBuilder, long) - Method in class org.apache.empire.db.DBCommandExpr.DBCmdColumn

create the SQL-Command set the expression name to the SQL-Command

addSQL(StringBuilder, long) - Method in class org.apache.empire.db.DBCommandExpr.DBCmdQuery

Creates the SQL-Command adds the select statement into the SQL-Command.

addSQL(StringBuilder, long) - Method in class org.apache.empire.db.DBExpr

Used to build the SQL command.

addSQL(StringBuilder, long) - Method in class org.apache.empire.db.DBQuery

Adds the select SQL Command of this object to the specified StringBuilder object.

addSQL(StringBuilder, long) - Method in class org.apache.empire.db.DBTable

Adds the table's name to the supplied sql command buffer.

addSQL(StringBuilder, long) - Method in class org.apache.empire.db.DBView

Creates the SQL-Command adds the alias name to the SQL-Command.

addSQL(StringBuilder, String, Object[], long) - Method in class org.apache.empire.db.expr.column.DBAbstractFuncExpr

Creates the SQL-Command adds a function to the SQL-Command.

addSQL(StringBuilder, long) - Method in class org.apache.empire.db.expr.column.DBAliasExpr

Creates the SQL-Command adds the alias name to the SQL-Command.

addSQL(StringBuilder, long) - Method in class org.apache.empire.db.expr.column.DBCalcExpr

Creates the SQL-Command adds the mathematical operations for the specified DBColumnExpr object and value to the.

addSQL(StringBuilder, long) - Method in class org.apache.empire.db.expr.column.DBCaseExpr

addSQL(StringBuilder, long) - Method in class org.apache.empire.db.expr.column.DBConcatExpr

Creates the SQL-Command concatenate a specified column with a specified value sets the column with a specified value to the SQL-Command.

addSQL(StringBuilder, long) - Method in class org.apache.empire.db.expr.column.DBConvertExpr

addSQL(StringBuilder, long) - Method in class org.apache.empire.db.expr.column.DBCountExpr

Creates the SQL-Command adds the String "count(*)" to the SQL-Command.

addSQL(StringBuilder, long) - Method in class org.apache.empire.db.expr.column.DBDecodeExpr

addSQL(StringBuilder, long) - Method in class org.apache.empire.db.expr.column.DBFuncExpr

Creates the SQL-Command adds a function to the SQL-Command.

addSQL(StringBuilder, long) - Method in class org.apache.empire.db.expr.column.DBValueExpr

Creates the SQL-Command.

addSQL(StringBuilder, long) - Method in class org.apache.empire.db.expr.compare.DBCompareAndOrExpr

Creates the SQL-Command sets the specified compare value (the varible boolOP) between the two DBCompareExpr objects.

addSQL(StringBuilder, long) - Method in class org.apache.empire.db.expr.compare.DBCompareColExpr

Creates the SQL-Command.

addSQL(StringBuilder, long) - Method in class org.apache.empire.db.expr.compare.DBCompareNotExpr

Creates the SQL-Command sets the specified compare value (the varible boolOP) between the two DBCompareExpr objects.

addSQL(StringBuilder, long) - Method in class org.apache.empire.db.expr.compare.DBExistsExpr

Creates the SQL-Command.

addSQL(StringBuilder, long) - Method in class org.apache.empire.db.expr.compare.DBParenthesisExpr

addSQL(StringBuilder, long) - Method in class org.apache.empire.db.expr.join.DBJoinExpr

Not allowed, this operation have to be done in the DBCommand object.

addSQL(StringBuilder, long) - Method in class org.apache.empire.db.expr.join.DBJoinExprEx

addSQL(StringBuilder, long) - Method in class org.apache.empire.db.expr.order.DBOrderByExpr

Adds a column expression to the orderBy clause followed by the desc keyword if the order should be descending

addSQL(StringBuilder, long) - Method in class org.apache.empire.db.expr.set.DBSetExpr

Creates the SQL-Command.

addSQL(StringBuilder, long) - Method in class org.apache.empire.db.oracle.OracleRowNumExpr

Creates the SQL-Command.

addStatementParam(PreparedStatement, int, Object, Connection) - Method in class org.apache.empire.db.DBDatabaseDriver

Adds a statement parameter to a prepared statement

addStmt(String) - Method in class org.apache.empire.db.DBSQLScript

Adds a statement to the script.

addStmt(StringBuilder) - Method in class org.apache.empire.db.DBSQLScript

Adds a statement to the script.
The supplied StringBuilder will be reset to a length of 0

addTable(DBTable) - Method in class org.apache.empire.db.DBDatabase

Adds a DBTable object to list of database tables.
This function is called internally from the DBTable's constructor.

addTimestampColumn(String) - Method in class org.apache.empire.db.DBTable

Adds a timestamp column to the table used for optimistic locking.

addView(DBView) - Method in class org.apache.empire.db.DBDatabase

Adds a DBView object to list of database views.
This function is called internally from the DBView's constructor.

addWhere(StringBuilder, long) - Method in class org.apache.empire.db.DBCommand

addWhere(StringBuilder) - Method in class org.apache.empire.db.DBCommand

addWhereConstraints(List<DBCompareExpr>) - Method in class org.apache.empire.db.DBCommand

Adds a list of constraints to the command.

addXml(Element, long) - Method in class org.apache.empire.commons.Attributes

addXml(Element, long) - Method in class org.apache.empire.commons.Options

Adds all these options to the xml element

addXml(Element, long) - Method in class org.apache.empire.db.DBColumn

addXml(Element, long) - Method in class org.apache.empire.db.DBColumnExpr

Add a description of this column with relevant metadata to the supplied parent XML Element.

addXml(Element, long) - Method in class org.apache.empire.db.DBCommandExpr.DBCmdColumn

Adds the expression definition to the xml element.

addXml(Element, long) - Method in class org.apache.empire.db.DBQuery.DBQueryColumn

addXml(Element, long) - Method in class org.apache.empire.db.DBTableColumn

Sets field elements, default attributes and all options to the specified Element object (XML tag).

addXml(Element, long) - Method in class org.apache.empire.db.DBView.DBViewColumn

addXml(Element, long) - Method in class org.apache.empire.db.expr.column.DBAbstractFuncExpr

addXml(Element, long) - Method in class org.apache.empire.db.expr.column.DBAliasExpr

This function set the alias name to the XML tag.

addXml(Element, long) - Method in class org.apache.empire.db.expr.column.DBCalcExpr

This function set the specified mathematical operations to the XML tag.

addXml(Element, long) - Method in class org.apache.empire.db.expr.column.DBCaseExpr

addXml(Element, long) - Method in class org.apache.empire.db.expr.column.DBConcatExpr

addXml(Element, long) - Method in class org.apache.empire.db.expr.column.DBCountExpr

this adds the column description to the parent element

addXml(Element, long) - Method in class org.apache.empire.db.expr.column.DBValueExpr

this helper function calls the DBColumnExpr.addXML(Element, long) method

addXml(Element, long) - Method in class org.apache.empire.db.oracle.OracleRowNumExpr

this helper function calls the DBColumnExpr.addXML(Element, long) method

alias - Variable in class org.apache.empire.db.DBQuery

allowFieldChange(DBColumn) - Method in class org.apache.empire.db.DBRecord

Checks whether or not this field can be changed at all.

alterColumnPhrase - Variable in class org.apache.empire.db.DBDDLGenerator

alterTable(DBTableColumn, DBCmdType, DBSQLScript) - Method in class org.apache.empire.db.DBDDLGenerator

Appends the DDL-Script for altering a table to an SQL-Script

and(DBCompareExpr) - Method in class org.apache.empire.db.expr.compare.DBCompareExpr

Creates a new DBCompareAndOrExpr object.

and(DBColumnExpr, DBColumnExpr) - Method in class org.apache.empire.db.expr.join.DBJoinExpr

This function adds an additional constraint to the join.

append(Object) - Method in class org.apache.empire.db.DBColumnExpr

Creates a new DBConcatExpr object with the specified value.

appendColumnDataType(DataType, double, DBTableColumn, StringBuilder) - Method in class org.apache.empire.db.DBDDLGenerator

appends the data type of a column

appendColumnDataType(DataType, double, DBTableColumn, StringBuilder) - Method in class org.apache.empire.db.derby.DerbyDDLGenerator

appendColumnDataType(DataType, double, DBTableColumn, StringBuilder) - Method in class org.apache.empire.db.h2.H2DDLGenerator

appendColumnDataType(DataType, double, DBTableColumn, StringBuilder) - Method in class org.apache.empire.db.mysql.MySQLDDLGenerator

appendColumnDataType(DataType, double, DBTableColumn, StringBuilder) - Method in class org.apache.empire.db.oracle.OracleDDLGenerator

appendColumnDataType(DataType, double, DBTableColumn, StringBuilder) - Method in class org.apache.empire.db.postgresql.PostgreDDLGenerator

appendColumnDataType(DataType, double, DBTableColumn, StringBuilder) - Method in class org.apache.empire.db.sqlserver.MSSqlDDLGenerator

appendColumnDesc(DBTableColumn, boolean, StringBuilder) - Method in class org.apache.empire.db.DBDDLGenerator

Appends a table column definition to a ddl statement

appendColumnDesc(DBTableColumn, boolean, StringBuilder) - Method in class org.apache.empire.db.derby.DerbyDDLGenerator

appendColumnDesc(DBTableColumn, boolean, StringBuilder) - Method in class org.apache.empire.db.postgresql.PostgreDDLGenerator

appendElementName(StringBuilder, String, boolean) - Method in class org.apache.empire.db.DBDatabaseDriver

Appends a table, view or column name to an SQL phrase.

appendElementName(StringBuilder, String) - Method in class org.apache.empire.db.DBDatabaseDriver

Appends a table, view or column name to an SQL phrase.

appendElementName(StringBuilder, String) - Method in class org.apache.empire.db.DBDDLGenerator

appendQualifiedName(StringBuilder, String, boolean) - Method in class org.apache.empire.db.DBDatabase

Adds a full qualified object name including schema prefix and database link postfix (if any).

appendSQLTextValue(StringBuilder, String) - Method in class org.apache.empire.db.DBDatabaseDriver

this helper function doubles up single quotes for SQL

arrayToString(Object[], String) - Static method in class org.apache.empire.commons.StringUtils

Converts an array of objects to a string.

as(String) - Method in class org.apache.empire.db.DBColumnExpr

creates a new DBAliasExpr which renames the current expression to the supplied name.

as(DBColumn) - Method in class org.apache.empire.db.DBColumnExpr

creates a new DBAliasExpr which renames the current expression to the name of the supplied column.

asc() - Method in class org.apache.empire.db.DBColumnExpr

creates a new DBOrderByExpr for ascending order

attachDatabase(DBDatabase, Connection) - Method in class org.apache.empire.db.DBDatabaseDriver

Called when a database is opened

attachDatabase(DBDatabase, Connection) - Method in class org.apache.empire.db.mysql.DBDatabaseDriverMySQL

attachDatabase(DBDatabase, Connection) - Method in class org.apache.empire.db.sqlserver.DBDatabaseDriverMSSQL

Called when a database is opened

Attributes - Class in org.apache.empire.commons

This class holds a map of objects which are identified by a case insensitive key string.

Attributes() - Constructor for class org.apache.empire.commons.Attributes

Attributes(int) - Constructor for class org.apache.empire.commons.Attributes

attributes - Variable in class org.apache.empire.commons.Attributes

attributes - Variable in class org.apache.empire.db.DBColumnExpr

Attributes.Attribute - Class in org.apache.empire.commons

Attributes.Attribute(String, Object, String) - Constructor for class org.apache.empire.commons.Attributes.Attribute

Attributes.Attribute(String, Object) - Constructor for class org.apache.empire.commons.Attributes.Attribute

avg() - Method in class org.apache.empire.db.DBColumnExpr

Creates and returns an aggregation function object which returns the average value for the current expression over a group of rows.

B

BeanClass - Class in org.apache.empire.data.bean

BeanObject This class defines Metadata for any type of java class.

BeanClass(String) - Constructor for class org.apache.empire.data.bean.BeanClass

BeanClass(String, BeanDomain) - Constructor for class org.apache.empire.data.bean.BeanClass

beanClass - Variable in class org.apache.empire.data.bean.BeanProperty

BeanDomain - Class in org.apache.empire.data.bean

BeanDomain This class defines Metadata for a domain of java classes.

BeanDomain(String) - Constructor for class org.apache.empire.data.bean.BeanDomain

BeanIncompatibleException - Exception in org.apache.empire.exceptions

BeanIncompatibleException(Class<?>, DBRowSet) - Constructor for exception org.apache.empire.exceptions.BeanIncompatibleException

BeanInstantiationException - Exception in org.apache.empire.exceptions

BeanInstantiationException(Class<?>, Throwable) - Constructor for exception org.apache.empire.exceptions.BeanInstantiationException

BeanProperty - Class in org.apache.empire.data.bean

BeanObject This class defines Metadata for a single property.

BeanProperty(String, DataType, double, DataMode, String) - Constructor for class org.apache.empire.data.bean.BeanProperty

Constructs a bean property definition

BeanProperty(String, DataType, double, boolean, String, boolean) - Constructor for class org.apache.empire.data.bean.BeanProperty

Constructs a bean property definition

BeanProperty(String, DataType, double, boolean) - Constructor for class org.apache.empire.data.bean.BeanProperty

Constructs a bean property definition

BeanPropertyGetException - Exception in org.apache.empire.exceptions

BeanPropertyGetException(Object, String, Throwable) - Constructor for exception org.apache.empire.exceptions.BeanPropertyGetException

beanPropertyName - Variable in class org.apache.empire.db.DBColumnExpr

BeanPropertySetException - Exception in org.apache.empire.exceptions

BeanPropertySetException(Object, String, Throwable) - Constructor for exception org.apache.empire.exceptions.BeanPropertySetException

BeanRecordProxy<T> - Class in org.apache.empire.data.bean

BeanRecordProxy This class defines proxy that allows any POJO to behave like a record object.

BeanRecordProxy(T, List<Column>, Column[]) - Constructor for class org.apache.empire.data.bean.BeanRecordProxy

BeanRecordProxy(List<Column>, Column[]) - Constructor for class org.apache.empire.data.bean.BeanRecordProxy

BeanRecordProxy(T, BeanClass) - Constructor for class org.apache.empire.data.bean.BeanRecordProxy

BeanRecordProxy(BeanClass) - Constructor for class org.apache.empire.data.bean.BeanRecordProxy

BeanResult<T> - Class in org.apache.empire.data.bean

BeanResult This is a simple helper class that performs reading a list of beans from a query Internally DBReader.getBeanList() is used.

BeanResult(Class<T>, DBCommand) - Constructor for class org.apache.empire.data.bean.BeanResult

Create a bean result from a command object.

BeanResult(Class<T>, DBRowSet) - Constructor for class org.apache.empire.data.bean.BeanResult

Creates a bean result for a Table, View or Query from the supplied columns.

BIGINT - Static variable in class org.apache.empire.db.DBTable

C

C_CHAR_LENGTH - Variable in class org.apache.empire.db.oracle.OracleSYSDatabase.DBColInfo

C_COLUMN_NAME - Variable in class org.apache.empire.db.oracle.OracleSYSDatabase.DBColComments

C_COLUMN_NAME - Variable in class org.apache.empire.db.oracle.OracleSYSDatabase.DBColInfo

C_COLUMN_NAME - Variable in class org.apache.empire.db.oracle.OracleSYSDatabase.DBUserConCol

C_COMMENTS - Variable in class org.apache.empire.db.oracle.OracleSYSDatabase.DBColComments

C_COMMENTS - Variable in class org.apache.empire.db.oracle.OracleSYSDatabase.DBTabComments

C_CONSTRAINT_NAME - Variable in class org.apache.empire.db.oracle.OracleSYSDatabase.DBConstraints

C_CONSTRAINT_NAME - Variable in class org.apache.empire.db.oracle.OracleSYSDatabase.DBUserConCol

C_CONSTRAINT_TYPE - Variable in class org.apache.empire.db.oracle.OracleSYSDatabase.DBConstraints

C_DATA_LENGTH - Variable in class org.apache.empire.db.oracle.OracleSYSDatabase.DBColInfo

C_DATA_PRECISION - Variable in class org.apache.empire.db.oracle.OracleSYSDatabase.DBColInfo

C_DATA_SCALE - Variable in class org.apache.empire.db.oracle.OracleSYSDatabase.DBColInfo

C_DATA_TYPE - Variable in class org.apache.empire.db.oracle.OracleSYSDatabase.DBColInfo

C_DATA_TYPE_MOD - Variable in class org.apache.empire.db.oracle.OracleSYSDatabase.DBColInfo

C_DATA_TYPE_OWNER - Variable in class org.apache.empire.db.oracle.OracleSYSDatabase.DBColInfo

C_NULLABLE - Variable in class org.apache.empire.db.oracle.OracleSYSDatabase.DBColInfo

C_OWNER - Variable in class org.apache.empire.db.oracle.OracleSYSDatabase.DBColComments

C_OWNER - Variable in class org.apache.empire.db.oracle.OracleSYSDatabase.DBColInfo

C_OWNER - Variable in class org.apache.empire.db.oracle.OracleSYSDatabase.DBTabComments

C_OWNER - Variable in class org.apache.empire.db.oracle.OracleSYSDatabase.DBUserConCol

C_R_CONSTRAINT_NAME - Variable in class org.apache.empire.db.oracle.OracleSYSDatabase.DBConstraints

C_SEQNAME - Variable in class org.apache.empire.db.DBDatabaseDriver.DBSeqTable

C_SEQVALUE - Variable in class org.apache.empire.db.DBDatabaseDriver.DBSeqTable

C_STATUS - Variable in class org.apache.empire.db.oracle.OracleSYSDatabase.DBConstraints

C_TABLE_NAME - Variable in class org.apache.empire.db.oracle.OracleSYSDatabase.DBColComments

C_TABLE_NAME - Variable in class org.apache.empire.db.oracle.OracleSYSDatabase.DBColInfo

C_TABLE_NAME - Variable in class org.apache.empire.db.oracle.OracleSYSDatabase.DBConstraints

C_TABLE_NAME - Variable in class org.apache.empire.db.oracle.OracleSYSDatabase.DBTabComments

C_TABLE_NAME - Variable in class org.apache.empire.db.oracle.OracleSYSDatabase.DBUserConCol

C_TABLE_TYPE - Variable in class org.apache.empire.db.oracle.OracleSYSDatabase.DBTabComments

C_TIMESTAMP - Variable in class org.apache.empire.db.DBDatabaseDriver.DBSeqTable

canonical - Variable in class org.apache.empire.xml.XMLWriter

Canonical output.

CC - Variable in class org.apache.empire.db.oracle.OracleSYSDatabase

changeState(DBRecord.State) - Method in class org.apache.empire.db.DBRecord

changes the state of the record

changeTagName(Element, String) - Static method in class org.apache.empire.xml.XMLUtil

Changes the tag name of an element.

checkDatabase(DBDatabase, String, Connection) - Method in class org.apache.empire.db.DBDatabaseDriver

Checks the database whether or not it is consistent with the description.

checkDatabase(DBDatabase, String, Connection) - Method in class org.apache.empire.db.oracle.DBDatabaseDriverOracle

Checks whether the database definition matches the real database structure.

checkDBTableDefinition(List<DBTable>) - Method in class org.apache.empire.db.oracle.OracleDataDictionnary

checkDBViewDefinition(List<DBView>) - Method in class org.apache.empire.db.oracle.OracleDataDictionnary

checkOpen() - Method in class org.apache.empire.db.DBDatabase

checks if the database has been opened or false otherwise

checkOpenResultSets() - Static method in class org.apache.empire.db.DBReader

Call this if you want to check whether there are any unclosed resultsets It logs stack traces to help find piece of code where a DBReader was opened but not closed.

checkValue(Object) - Method in class org.apache.empire.db.DBColumn

Deprecated. use validate() instead

CI - Variable in class org.apache.empire.db.oracle.OracleSYSDatabase

clear() - Method in class org.apache.empire.commons.Attributes

clear() - Method in class org.apache.empire.commons.Options

clear() - Method in class org.apache.empire.db.DBCommand

Clears the entire command object.

clear() - Method in class org.apache.empire.db.DBSQLScript

Clears the script by removing all statements

clear() - Method in class org.apache.empire.db.oracle.DBCommandOracle

clearConnectBy() - Method in class org.apache.empire.db.oracle.DBCommandOracle

Clears the connectBy Expression.

clearGroupBy() - Method in class org.apache.empire.db.DBCommand

Clears the list of group by constraints.

clearHaving() - Method in class org.apache.empire.db.DBCommand

Clears the list of having constraints.

clearJoin() - Method in class org.apache.empire.db.DBCommand

Clears the list of join expressions.

clearLimit() - Method in class org.apache.empire.db.DBCommandExpr

Clears a limit or offset set by calling limit() or offset()

clearLimit() - Method in class org.apache.empire.db.mysql.DBDatabaseDriverMySQL.DBCommandMySQL

clearLimit() - Method in class org.apache.empire.db.oracle.DBCommandOracle

clearLimit() - Method in class org.apache.empire.db.postgresql.DBDatabaseDriverPostgreSQL.DBCommandPostreSQL

clearLimit() - Method in class org.apache.empire.db.sqlserver.DBDatabaseDriverMSSQL.DBCommandMSSQL

clearModified() - Method in class org.apache.empire.data.bean.BeanRecordProxy

clears the modification status of the object and all fields.

clearOrderBy() - Method in class org.apache.empire.db.DBCommandExpr

Clears the list of order by expressions.

clearSelect() - Method in class org.apache.empire.db.DBCommand

Clears the list of selected columns.

clearSelectDistinct() - Method in class org.apache.empire.db.DBCommand

Clears the select distinct option.

clearSet() - Method in class org.apache.empire.db.DBCommand

Clears the list of set expressions.

clearWhere() - Method in class org.apache.empire.db.DBCommand

Clears the list of where constraints.

clone() - Method in class org.apache.empire.commons.Attributes

clone() - Method in class org.apache.empire.commons.Options

clone() - Method in class org.apache.empire.db.DBCommand

Creates a clone of this class.

clone() - Method in class org.apache.empire.db.DBRecord

clone() - Method in class org.apache.empire.db.DBTable

Clones this table and assigns a new table alias.

close(Connection) - Method in class org.apache.empire.db.DBDatabase

closes this database object by detaching it from the driver this is a shortcut for calling getDriver().closeDatabase(db, conn)

close(Statement) - Method in class org.apache.empire.db.DBDatabaseDriver

close() - Method in class org.apache.empire.db.DBReader

Closes the DBRecordSet object, the Statement object and detach the columns.
A reader must always be closed immediately after using it.

close() - Method in class org.apache.empire.db.DBRecord

Closes the record by releasing all resources and resetting the record's state to invalid.

close() - Method in class org.apache.empire.db.DBRecordData

closeResultSet(ResultSet) - Method in class org.apache.empire.db.DBDatabase

Convenience function for closing a JDBC Resultset
Use it instead of rset.close() and stmt.close()

closeStatement(Statement) - Method in class org.apache.empire.db.DBDatabase

Convenience function for closing a JDBC Resultset
Use it instead of stmt.close()

cmd - Variable in class org.apache.empire.db.DBCmdParam

cmd - Variable in class org.apache.empire.db.expr.compare.DBExistsExpr

cmdExpr - Variable in class org.apache.empire.db.DBQuery

cmdParams - Variable in class org.apache.empire.db.DBCommand

cmdQuery - Variable in class org.apache.empire.db.DBCommandExpr

cmp(DBCmpType, Object) - Method in class org.apache.empire.db.DBColumnExpr

Creates and returns a new comparison object for the given comparison operator and value.

cmp - Variable in class org.apache.empire.db.expr.join.DBJoinExprEx

cmpop - Variable in class org.apache.empire.db.expr.compare.DBCompareColExpr

CO - Variable in class org.apache.empire.db.oracle.OracleSYSDatabase

coalesce(T, T) - Static method in class org.apache.empire.commons.ObjectUtils

Checks whether a preferred value is valid and returns an alternative value if not.

coalesce(String, String) - Static method in class org.apache.empire.commons.StringUtils

Returns the preferred String if it is not empty ot the alternative String otherwise.

coalesce(Object) - Method in class org.apache.empire.db.DBColumnExpr

Creates a sql-expression for the nvl() or coalesce() function.

Column - Interface in org.apache.empire.data

The column interface provides methods for accessing metadata that is only relevant for updating records.

column - Variable in class org.apache.empire.db.expr.column.DBValueExpr

column - Variable in class org.apache.empire.db.expr.set.DBSetExpr

ColumnExpr - Interface in org.apache.empire.data

The column interface provides methods for accessing metadata that is relevant for managing and displaying data available through the RecordData interface.

columnReferences - Variable in class org.apache.empire.db.DBRowSet

columns - Variable in class org.apache.empire.data.bean.BeanRecordProxy

columns - Variable in class org.apache.empire.db.DBRowSet

commandSeparator - Variable in class org.apache.empire.db.DBSQLScript

comment - Variable in class org.apache.empire.db.DBColumn

comment - Variable in class org.apache.empire.db.DBRowSet

commit(Connection) - Method in class org.apache.empire.db.DBDatabase

Makes all changes made since the previous commit/rollback permanent and releases any database locks currently held by the Connection.

compareEqual(Object, Object) - Static method in class org.apache.empire.commons.ObjectUtils

Compares two objects for equality

compareEqual(String, String, boolean) - Static method in class org.apache.empire.commons.StringUtils

Compares two Strings with each other - either with or without character case.

compareExpr - Variable in class org.apache.empire.db.expr.compare.DBExistsExpr

compExpr - Variable in class org.apache.empire.db.expr.join.DBJoinExpr

completeInitRecord(DBRecord) - Method in class org.apache.empire.db.DBRowSet

Completes the record initialization.
Override this function to do post initialization processing.

connectBy - Variable in class org.apache.empire.db.oracle.DBCommandOracle

connectByPrior(DBCompareExpr) - Method in class org.apache.empire.db.oracle.DBCommandOracle

contains(Object) - Method in class org.apache.empire.commons.Attributes

contains(T[], T) - Static method in class org.apache.empire.commons.ObjectUtils

returns wheter or not a array contains a certain item

contains(Object) - Method in class org.apache.empire.commons.Options

contains(DBColumn) - Method in class org.apache.empire.db.DBExpressionIndex

Checks if this index contains the column col

contains(DBColumn) - Method in class org.apache.empire.db.DBIndex

Checks if this index contains the column col

convert(Class<T>, Object) - Static method in class org.apache.empire.commons.ObjectUtils

Generic conversion function that will convert a object to another value type.

convert(Class<T>, Collection<? extends T>) - Static method in class org.apache.empire.commons.ObjectUtils

Generic conversion function that will convert a list to another list type.

convertTo(DataType, Object) - Method in class org.apache.empire.db.DBColumnExpr

Creates a new DBFuncExpr object that will convert the current column to the destination data type specified.

convertTo(DataType) - Method in class org.apache.empire.db.DBColumnExpr

Creates and returns a new DBFuncExpr object that will convert the current column to the destination data type specified.

count() - Method in class org.apache.empire.db.DBColumnExpr

Creates and returns an expression for the SQL "count()" function which returns the number of rows in the result set.

count() - Method in class org.apache.empire.db.DBRowSet

Returns a new DBCountExpr object.

countDistinct() - Method in class org.apache.empire.db.DBColumnExpr

Creates and returns an expression for the SQL "count()" function which returns the number of unique values in the result set.

create(DBRowSet, Connection) - Method in class org.apache.empire.db.DBRecord

Creates a new record for the given table.
All record fields will be filled with their default values.

create(DBRowSet) - Method in class org.apache.empire.db.DBRecord

Creates a new record for the given table.
All record fields will be filled with their default values.
The record's state is set to NEW

createCombinedCommand(DBCommandExpr, String, DBCommandExpr) - Method in class org.apache.empire.db.DBDatabaseDriver

This function gives the driver a chance to provide a custom implementation for a combined command such as UNION or INTERSECT

createCombinedCommand(DBCommandExpr, String, DBCommandExpr) - Method in class org.apache.empire.db.mysql.DBDatabaseDriverMySQL

createCommand() - Method in class org.apache.empire.db.DBDatabase

Creates a new Command object for this database

createCommand(DBDatabase) - Method in class org.apache.empire.db.DBDatabaseDriver

This function creates a DBCommand derived object this database

createCommand() - Method in class org.apache.empire.db.DBView

Returns the command required to create the view
This is function is only used for the creation of DDL statements

createCommand(DBDatabase) - Method in class org.apache.empire.db.derby.DBDatabaseDriverDerby

Creates a new Derby command object.

createCommand(DBDatabase) - Method in class org.apache.empire.db.h2.DBDatabaseDriverH2

Creates a new H2 command object.

createCommand(DBDatabase) - Method in class org.apache.empire.db.hsql.DBDatabaseDriverHSql

Creates a new HSQLDB command object.

createCommand(DBDatabase) - Method in class org.apache.empire.db.mysql.DBDatabaseDriverMySQL

Creates a new MySQL command object.

createCommand(DBDatabase) - Method in class org.apache.empire.db.oracle.DBDatabaseDriverOracle

Creates a new Oracle command object.

createCommand(DBDatabase) - Method in class org.apache.empire.db.postgresql.DBDatabaseDriverPostgreSQL

Creates a new PostgreSQL command object.

createCommand(DBDatabase) - Method in class org.apache.empire.db.sqlite.DBDatabaseDriverSQLite

Creates a new SQLite command object.

createCommand(DBDatabase) - Method in class org.apache.empire.db.sqlserver.DBDatabaseDriverMSSQL

Creates a new Microsoft SQL-Server command object.

createComment(DBDatabase, String, DBExpr, String, DBSQLScript) - Method in class org.apache.empire.db.oracle.OracleDDLGenerator

Returns true if the comment has been created successfully.

createDatabase(DBDatabase, DBSQLScript) - Method in class org.apache.empire.db.DBDDLGenerator

Appends the DDL-Script for creating the given database to an SQL-Script
This includes the generation of all tables, views and relations.

createDatabase(DBDatabase, DBSQLScript) - Method in class org.apache.empire.db.hsql.HSqlDDLGenerator

createDatabase(DBDatabase, DBSQLScript) - Method in class org.apache.empire.db.mysql.MySQLDDLGenerator

createDatabase(DBDatabase, DBSQLScript) - Method in class org.apache.empire.db.oracle.OracleDDLGenerator

createDatabase(DBDatabase, DBSQLScript) - Method in class org.apache.empire.db.postgresql.PostgreDDLGenerator

createDatabase(DBDatabase, DBSQLScript) - Method in class org.apache.empire.db.sqlserver.MSSqlDDLGenerator

createDocument() - Static method in class org.apache.empire.xml.XMLUtil

Returns a document newly created by the class's static DocumentBuilder.

createDocument(String) - Static method in class org.apache.empire.xml.XMLUtil

createDocumentNS(String, String, Map<String, String>) - Static method in class org.apache.empire.xml.XMLUtil

createIndex(DBTable, DBIndex, DBSQLScript) - Method in class org.apache.empire.db.DBDDLGenerator

Appends the DDL-Script for creating a single index to an SQL-Script

createOptionEntry(Object, String) - Method in class org.apache.empire.commons.Options

createRecord(DBRecord, Connection) - Method in class org.apache.empire.db.DBCommandExpr.DBCmdQuery

Returns the error message: ERR_NOTSUPPORTED

createRecord(DBRecord, Connection) - Method in class org.apache.empire.db.DBQuery

Returns an error, because it is not possible to add a record to a query.

createRecord(DBRecord, Connection) - Method in class org.apache.empire.db.DBRowSet

createRecord(DBRecord, Connection) - Method in class org.apache.empire.db.DBTable

Gets all table fields and the fields properties.

createRecord(DBRecord, Connection) - Method in class org.apache.empire.db.DBView

createRelation(DBRelation, DBSQLScript) - Method in class org.apache.empire.db.DBDDLGenerator

Appends the DDL-Script for creating the given foreign-key relation to an SQL-Script

createRelation(DBRelation, DBSQLScript) - Method in class org.apache.empire.db.sqlite.SQLiteDDLGenerator

createReverseFunction(Connection) - Method in class org.apache.empire.db.postgresql.DBDatabaseDriverPostgreSQL

Creates the reverse function in postgre sql that returns the reverse of a string value.

createSequence(DBDatabase, DBTableColumn, DBSQLScript) - Method in class org.apache.empire.db.hsql.HSqlDDLGenerator

Appends the DDL-Script for creating a sequence to an SQL-Script

createSequence(DBDatabase, DBTableColumn, DBSQLScript) - Method in class org.apache.empire.db.oracle.OracleDDLGenerator

Returns true if the sequence has been created successfully.

createSequence(DBDatabase, DBTableColumn, DBSQLScript) - Method in class org.apache.empire.db.postgresql.PostgreDDLGenerator

Appends the DDL-Script for creating a sequence to an SQL-Script

createTable(DBTable, DBSQLScript) - Method in class org.apache.empire.db.DBDDLGenerator

Appends the DDL-Script for creating the given table to an SQL-Script

createTable(DBTable, DBSQLScript) - Method in class org.apache.empire.db.mysql.MySQLDDLGenerator

Appends the DDL-Script for creating the given table to an SQL-Script

createTable(DBTable, DBSQLScript) - Method in class org.apache.empire.db.oracle.OracleDDLGenerator

createTable(DBTable, DBSQLScript) - Method in class org.apache.empire.db.sqlite.SQLiteDDLGenerator

createTableIndexes(DBTable, DBIndex, DBSQLScript) - Method in class org.apache.empire.db.DBDDLGenerator

Appends the DDL-Script for creating all indexes of table (except the primary key) to an SQL-Script

createView(DBView, DBSQLScript) - Method in class org.apache.empire.db.DBDDLGenerator

Appends the DDL-Script for creating the given view to an SQL-Script

CTX_ALIAS - Static variable in class org.apache.empire.db.DBExpr

CTX_ALL - Static variable in class org.apache.empire.db.DBExpr

CTX_DEFAULT - Static variable in class org.apache.empire.db.DBExpr

CTX_FULLNAME - Static variable in class org.apache.empire.db.DBExpr

CTX_NAME - Static variable in class org.apache.empire.db.DBExpr

CTX_NOPARENTHESES - Static variable in class org.apache.empire.db.DBExpr

CTX_VALUE - Static variable in class org.apache.empire.db.DBExpr

curCount - Variable in class org.apache.empire.db.DBReader.DBReaderIterator

D

data - Variable in class org.apache.empire.data.bean.BeanRecordProxy

DatabaseNotOpenException - Exception in org.apache.empire.db.exceptions

DatabaseNotOpenException(DBDatabase) - Constructor for exception org.apache.empire.db.exceptions.DatabaseNotOpenException

DataMode - Enum in org.apache.empire.data

DataMode is an enumeration that specifies whether the value of a column is readonly, optional (nullable), required (NotNull), or auto-generated

dataMode - Variable in class org.apache.empire.db.DBTableColumn

DataType - Enum in org.apache.empire.data

DataType is an enumeration of data types that are supported with the empire-db component.

dataType - Variable in class org.apache.empire.db.expr.column.DBAbstractFuncExpr

DATATYPE_BLOB - Variable in class org.apache.empire.db.DBDDLGenerator

DATATYPE_BOOLEAN - Variable in class org.apache.empire.db.DBDDLGenerator

DATATYPE_CHAR - Variable in class org.apache.empire.db.DBDDLGenerator

DATATYPE_CLOB - Variable in class org.apache.empire.db.DBDDLGenerator

DATATYPE_DATE - Variable in class org.apache.empire.db.DBDDLGenerator

DATATYPE_DECIMAL - Variable in class org.apache.empire.db.DBDDLGenerator

DATATYPE_FLOAT - Variable in class org.apache.empire.db.DBDDLGenerator

DATATYPE_INT_BIG - Variable in class org.apache.empire.db.DBDDLGenerator

DATATYPE_INT_SMALL - Variable in class org.apache.empire.db.DBDDLGenerator

DATATYPE_INTEGER - Variable in class org.apache.empire.db.DBDDLGenerator

DATATYPE_TIMESTAMP - Variable in class org.apache.empire.db.DBDDLGenerator

DATATYPE_UNIQUEID - Variable in class org.apache.empire.db.DBDDLGenerator

DATATYPE_VARCHAR - Variable in class org.apache.empire.db.DBDDLGenerator

DateUtils - Class in org.apache.empire.commons

This class contains common functions for comparing and converting values of type Date.

day() - Method in class org.apache.empire.db.DBColumnExpr

Creates and returns an function object that calculates the day of a date value.

db - Variable in class org.apache.empire.db.DBRowSet

db - Variable in class org.apache.empire.db.expr.column.DBValueExpr

db - Variable in class org.apache.empire.db.oracle.OracleRowNumExpr

DBAbstractFuncExpr - Class in org.apache.empire.db.expr.column

This implements some basic functionality for SQL functions based on a column expression

DBAbstractFuncExpr(DBColumnExpr, DBColumn, boolean, DataType) - Constructor for class org.apache.empire.db.expr.column.DBAbstractFuncExpr

Constructs a new DBFuncExpr object set the specified parameters to this object.

DBAliasExpr - Class in org.apache.empire.db.expr.column

This class allows column renaming in SQL.

DBAliasExpr(DBColumnExpr, String) - Constructor for class org.apache.empire.db.expr.column.DBAliasExpr

Constructs a DBAliasExpr object combine the DBColumnExpr object with the alias name.

DBBlobData - Class in org.apache.empire.db

This class allocates methods to store binary large objects in the database.

DBBlobData(InputStream, int) - Constructor for class org.apache.empire.db.DBBlobData

Constructor to pass LOB data to the setValue methods of a record, consisting of the input stream where the data can be loaded from and the length of the data.

DBBlobData(byte[]) - Constructor for class org.apache.empire.db.DBBlobData

Constructor for LobData from a byte array.

DBBlobData(String, String) - Constructor for class org.apache.empire.db.DBBlobData

Constructor for LobData from a string.

DBBlobData(String) - Constructor for class org.apache.empire.db.DBBlobData

Constructor for LobData from a string.

DBCalcExpr - Class in org.apache.empire.db.expr.column

This class is used for performing calculations in SQL
It handles the mathematical operations ("+", "-", "*", "/") for the current column.

DBCalcExpr(DBColumnExpr, String, Object) - Constructor for class org.apache.empire.db.expr.column.DBCalcExpr

Constructs a DBCalcExpr object Sets the mathematical operations ("+", "-", "*", "/")
for the specified DBColumnExpr object and value.

DBCaseExpr - Class in org.apache.empire.db.expr.column

This class is used to add the "case when ?=A then X else Y end" statement to the SQL-Command.

DBCaseExpr(DBCompareExpr, DBColumnExpr, DBColumnExpr) - Constructor for class org.apache.empire.db.expr.column.DBCaseExpr

Constructs a DBCaseExpr

DBClobData - Class in org.apache.empire.db

This class allocates methods to store binary character objects in the database.

DBClobData(Reader, int) - Constructor for class org.apache.empire.db.DBClobData

Constructor to pass LOB data to the setValue methods of a record, consisting of the input stream where the data can be loaded from and the length of the data.

DBClobData(String) - Constructor for class org.apache.empire.db.DBClobData

Constructor for LobData from a string.

DBCmdParam - Class in org.apache.empire.db

This class defines a parameter for a prepared statement query.

DBCmdParam(DBCommand, DataType, Object) - Constructor for class org.apache.empire.db.DBCmdParam

Protected constructor used e.g.

DBCmdType - Enum in org.apache.empire.db

This enum allocates the available command types.

DBCmpType - Enum in org.apache.empire.db

This enum allocates the available compare types.

DBCOLATTR_DATETIMEPATTERN - Static variable in class org.apache.empire.db.DBColumn

Maximum value (Integer)

DBCOLATTR_MANDATORY - Static variable in class org.apache.empire.db.DBColumn

Mandatory column (Boolean)

DBCOLATTR_MAXVALUE - Static variable in class org.apache.empire.db.DBColumn

Maximum value (Integer)

DBCOLATTR_MINVALUE - Static variable in class org.apache.empire.db.DBColumn

Minimum value (Integer)

DBCOLATTR_READONLY - Static variable in class org.apache.empire.db.DBColumn

Read only column (Boolean)

DBCOLATTR_SINGLEBYTECHARS - Static variable in class org.apache.empire.db.DBColumn

Read only column (Boolean)

DBCOLATTR_TITLE - Static variable in class org.apache.empire.db.DBColumnExpr

DBCOLATTR_TYPE - Static variable in class org.apache.empire.db.DBColumnExpr

DBColumn - Class in org.apache.empire.db

This is the base class for all database columns that have a physical representation.

DBColumn(DBRowSet, String) - Constructor for class org.apache.empire.db.DBColumn

Constructs a DBColumn object and set the specified parameters to this object.

DBColumnExpr - Class in org.apache.empire.db

This class is the base class for all expressions that represent a single value.

DBColumnExpr() - Constructor for class org.apache.empire.db.DBColumnExpr

DBCombinedCmd - Class in org.apache.empire.db

This class is used for building up a partition of a SQL-Command.

DBCombinedCmd(DBCommandExpr, String, DBCommandExpr) - Constructor for class org.apache.empire.db.DBCombinedCmd

Constructs a new DBFuncExpr object and sets the specified parameters to this object.

DBCommand - Class in org.apache.empire.db

This abstract class handles the creation of the SQL-Commands.

DBCommand(DBDatabase) - Constructor for class org.apache.empire.db.DBCommand

Constructs a new DBCommand object and set the specified DBDatabase object.

DBCommandExpr - Class in org.apache.empire.db

This abstract class handles the creation of the SQL-Commands.

DBCommandExpr() - Constructor for class org.apache.empire.db.DBCommandExpr

Constructs an empty DBCommandExpr object

DBCommandExpr.DBCmdColumn - Class in org.apache.empire.db

This class wraps a column of sql command in a special command column object.

DBCommandExpr.DBCmdColumn(DBRowSet, DBColumnExpr) - Constructor for class org.apache.empire.db.DBCommandExpr.DBCmdColumn

Constructs a new DBCmdColumn object

DBCommandExpr.DBCmdQuery - Class in org.apache.empire.db

DBCommandExpr.DBCmdQuery(DBCommandExpr, DBColumnExpr[]) - Constructor for class org.apache.empire.db.DBCommandExpr.DBCmdQuery

Creates a new DBCmdQueryObject

DBCommandOracle - Class in org.apache.empire.db.oracle

This class handles the special features of an oracle database.

DBCommandOracle(DBDatabase) - Constructor for class org.apache.empire.db.oracle.DBCommandOracle

Constructs an oracle command object.

DBCompareAndOrExpr - Class in org.apache.empire.db.expr.compare

This class is used for combining two filter constraints by and / or operator

DBCompareAndOrExpr(DBCompareExpr, DBCompareExpr, boolean) - Constructor for class org.apache.empire.db.expr.compare.DBCompareAndOrExpr

Constructs a DBCompareColExpr object

DBCompareColExpr - Class in org.apache.empire.db.expr.compare

This class is used for defining filter constraints based on a column expression in SQL

DBCompareColExpr(DBColumnExpr, DBCmpType, Object) - Constructor for class org.apache.empire.db.expr.compare.DBCompareColExpr

Constructs a DBCompareColExpr object set the specified parameters to this object.

DBCompareExpr - Class in org.apache.empire.db.expr.compare

This class is a common base class for all SQL filter constraints classes

DBCompareExpr() - Constructor for class org.apache.empire.db.expr.compare.DBCompareExpr

DBCompareNotExpr - Class in org.apache.empire.db.expr.compare

This class is used for defining filter constraints based on a column expression in SQL

DBCompareNotExpr(DBCompareExpr) - Constructor for class org.apache.empire.db.expr.compare.DBCompareNotExpr

Constructs a DBCompareColExpr object

DBConcatExpr - Class in org.apache.empire.db.expr.column

This class is used for performing string concatenation in SQL

DBConcatExpr(DBColumnExpr, Object) - Constructor for class org.apache.empire.db.expr.column.DBConcatExpr

Constructs a new DBConcatExpr object set the specified parameters to this object.

DBConvertExpr - Class in org.apache.empire.db.expr.column

This class is used to convert a value to a different data type.

DBConvertExpr(DBColumnExpr, DataType, Object) - Constructor for class org.apache.empire.db.expr.column.DBConvertExpr

Constructs a DBDecodeExpr

DBCountExpr - Class in org.apache.empire.db.expr.column

This class is used to add the "count" statement to the SQL-Command.

DBCountExpr(DBRowSet) - Constructor for class org.apache.empire.db.expr.column.DBCountExpr

Constructs a DBCountExpr.

DBCountExpr(DBColumnExpr, boolean) - Constructor for class org.apache.empire.db.expr.column.DBCountExpr

Constructs a DBCountExpr.

DBDatabase - Class in org.apache.empire.db

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

DBDatabase(String, String) - Constructor for class org.apache.empire.db.DBDatabase

Constructs a new DBDatabase object and sets the specified schema object.

DBDatabase(String) - Constructor for class org.apache.empire.db.DBDatabase

Constructs a new DBDatabase object and sets the specified schema object.

DBDatabase() - Constructor for class org.apache.empire.db.DBDatabase

Constructs a new DBDatabase object set the variable 'schema' = null.

DBDatabase.DBSystemDate - Class in org.apache.empire.db

This class represents the database systems current date and time.

DBDatabaseDriver - Class in org.apache.empire.db

The DBDatabaseDriver class is an abstract base class for all database drivers.

DBDatabaseDriver() - Constructor for class org.apache.empire.db.DBDatabaseDriver

Constructor

DBDatabaseDriver.DBSeqTable - Class in org.apache.empire.db

This class is used to emulate sequences by using a sequence table.

DBDatabaseDriver.DBSeqTable(String, DBDatabase) - Constructor for class org.apache.empire.db.DBDatabaseDriver.DBSeqTable

Constructor

DBDatabaseDriver.DBSetGenKeys - Interface in org.apache.empire.db

This interface is used to set the auto generated keys when executing insert statements.

DBDatabaseDriverDerby - Class in org.apache.empire.db.derby

This class provides support for the Derby database system.

DBDatabaseDriverDerby() - Constructor for class org.apache.empire.db.derby.DBDatabaseDriverDerby

Constructor for the Derby database driver.

DBDatabaseDriverDerby.DBCommandDerby - Class in org.apache.empire.db.derby

Defines the Derby command type.

DBDatabaseDriverDerby.DBCommandDerby(DBDatabase) - Constructor for class org.apache.empire.db.derby.DBDatabaseDriverDerby.DBCommandDerby

DBDatabaseDriverH2 - Class in org.apache.empire.db.h2

This class provides support for the H2 database system.

DBDatabaseDriverH2() - Constructor for class org.apache.empire.db.h2.DBDatabaseDriverH2

Constructor for the H2 database driver.

DBDatabaseDriverH2.DBCommandH2 - Class in org.apache.empire.db.h2

Defines the H2 command type.

DBDatabaseDriverH2.DBCommandH2(DBDatabase) - Constructor for class org.apache.empire.db.h2.DBDatabaseDriverH2.DBCommandH2

DBDatabaseDriverHSql - Class in org.apache.empire.db.hsql

This class provides support for the HSQLDB database system.

DBDatabaseDriverHSql() - Constructor for class org.apache.empire.db.hsql.DBDatabaseDriverHSql

Constructor for the HSQLDB database driver.

DBDatabaseDriverHSql.DBCommandHSql - Class in org.apache.empire.db.hsql

Defines the HSQLDB command type.

DBDatabaseDriverHSql.DBCommandHSql(DBDatabase) - Constructor for class org.apache.empire.db.hsql.DBDatabaseDriverHSql.DBCommandHSql

DBDatabaseDriverMSSQL - Class in org.apache.empire.db.sqlserver

This class provides support for the Microsoft SQL-Server database system.

DBDatabaseDriverMSSQL() - Constructor for class org.apache.empire.db.sqlserver.DBDatabaseDriverMSSQL

Constructor for the MSSQL database driver.

DBDatabaseDriverMSSQL.DBCommandMSSQL - Class in org.apache.empire.db.sqlserver

Defines the Microsoft SQL-Server command type.

DBDatabaseDriverMSSQL.DBCommandMSSQL(DBDatabase) - Constructor for class org.apache.empire.db.sqlserver.DBDatabaseDriverMSSQL.DBCommandMSSQL

DBDatabaseDriverMySQL - Class in org.apache.empire.db.mysql

This class provides support for the MySQL database system.

DBDatabaseDriverMySQL() - Constructor for class org.apache.empire.db.mysql.DBDatabaseDriverMySQL

Constructor for the MySQL database driver.

DBDatabaseDriverMySQL.DBCommandMySQL - Class in org.apache.empire.db.mysql

Defines the MySQL command type.

DBDatabaseDriverMySQL.DBCommandMySQL(DBDatabase) - Constructor for class org.apache.empire.db.mysql.DBDatabaseDriverMySQL.DBCommandMySQL

DBDatabaseDriverOracle - Class in org.apache.empire.db.oracle

This class provides support for the Oracle database system.
Oracle Version 9 or higher is required.

DBDatabaseDriverOracle() - Constructor for class org.apache.empire.db.oracle.DBDatabaseDriverOracle

Constructor for the Oracle database driver.

DBDatabaseDriverOracle.BooleanType - Enum in org.apache.empire.db.oracle

DBDatabaseDriverPostgreSQL - Class in org.apache.empire.db.postgresql

This class provides support for the PostgreSQL database system.

DBDatabaseDriverPostgreSQL() - Constructor for class org.apache.empire.db.postgresql.DBDatabaseDriverPostgreSQL

Constructor for the PostgreSQL database driver.

DBDatabaseDriverPostgreSQL.DBCommandPostreSQL - Class in org.apache.empire.db.postgresql

Defines the PostgreSQL command type.

DBDatabaseDriverPostgreSQL.DBCommandPostreSQL(DBDatabase) - Constructor for class org.apache.empire.db.postgresql.DBDatabaseDriverPostgreSQL.DBCommandPostreSQL

DBDatabaseDriverSQLite - Class in org.apache.empire.db.sqlite

This class provides support for the SQLite database system.

DBDatabaseDriverSQLite() - Constructor for class org.apache.empire.db.sqlite.DBDatabaseDriverSQLite

Constructor for the SQLite database driver.

DBDatabaseDriverSQLite.DBCommandSQLite - Class in org.apache.empire.db.sqlite

Defines the SQLite command type.

DBDatabaseDriverSQLite.DBCommandSQLite(DBDatabase) - Constructor for class org.apache.empire.db.sqlite.DBDatabaseDriverSQLite.DBCommandSQLite

DBDDLGenerator<T extends DBDatabaseDriver> - Class in org.apache.empire.db

DBDDLGenerator(T) - Constructor for class org.apache.empire.db.DBDDLGenerator

DBDecodeExpr - Class in org.apache.empire.db.expr.column

This class is used to decode a set of keys to the corresponding target values.

DBDecodeExpr(DBColumnExpr, Map<?, ?>, Object, DataType) - Constructor for class org.apache.empire.db.expr.column.DBDecodeExpr

Constructs a DBDecodeExpr

DBDriverFeature - Enum in org.apache.empire.db

This enum is used with the DBDatabaseDriver::isSupported method to query database driver capabilities.

DBExistsExpr - Class in org.apache.empire.db.expr.compare

This class is used for building up the SQL-Command for the EXISTS syntax.

DBExistsExpr(DBCommandExpr) - Constructor for class org.apache.empire.db.expr.compare.DBExistsExpr

Constructs a DBExistsExpr object set the specified parameters to this object.

DBExistsExpr(DBCommandExpr, DBCompareExpr) - Constructor for class org.apache.empire.db.expr.compare.DBExistsExpr

Constructs a DBExistsExpr object set the specified parameters to this object.

DBExpr - Class in org.apache.empire.db

This abstract class is the base class for all database expression classes (e.g.

DBExpr() - Constructor for class org.apache.empire.db.DBExpr

DBExpressionIndex - Class in org.apache.empire.db

This class handles the primary key for the tables.

DBExpressionIndex(String, boolean, DBExpr[]) - Constructor for class org.apache.empire.db.DBExpressionIndex

Constructs a DBExpresionIndex

DBExpressionIndex(String, boolean, DBColumnExpr) - Constructor for class org.apache.empire.db.DBExpressionIndex

Constructs a DBExpresionIndex

DBFuncExpr - Class in org.apache.empire.db.expr.column

This class is used for performing various SQL functions on a column or column expression.

DBFuncExpr(DBColumnExpr, int, Object[], DBColumn, boolean, DataType) - Constructor for class org.apache.empire.db.expr.column.DBFuncExpr

Constructs a new DBFuncExpr object set the specified parameters to this object.

DBFuncExpr(DBColumnExpr, String, Object[], DBColumn, boolean, DataType) - Constructor for class org.apache.empire.db.expr.column.DBFuncExpr

Constructs a new DBFuncExpr object set the specified parameters to this object.

DBIndex - Class in org.apache.empire.db

This class handles the primary key for the tables.

DBIndex(String, int, DBColumn[]) - Constructor for class org.apache.empire.db.DBIndex

Constructs a DBIndex object set the specified parameters to this object.

DBJoinExpr - Class in org.apache.empire.db.expr.join

This class is used for building a join expression of an SQL statement.

DBJoinExpr(DBColumnExpr, DBColumnExpr, DBJoinType) - Constructor for class org.apache.empire.db.expr.join.DBJoinExpr

Constructs a new DBJoinExpr object initialize this object with the left and right column and the data type of the join expression.

DBJoinExprEx - Class in org.apache.empire.db.expr.join

This class is used for building a join expression of an SQL statement.

DBJoinExprEx(DBRowSet, DBCompareExpr, DBJoinType) - Constructor for class org.apache.empire.db.expr.join.DBJoinExprEx

Constructs a new DBJoinExprEx

DBJoinType - Enum in org.apache.empire.db

DBJoinType contains the possibilities to join two database tables.

DBObject - Class in org.apache.empire.db

Base class for all objects that directly or indirectly belong to a database including the database object itself.

DBObject() - Constructor for class org.apache.empire.db.DBObject

DBOrderByExpr - Class in org.apache.empire.db.expr.order

DBOrderByExpr(DBColumnExpr, boolean) - Constructor for class org.apache.empire.db.expr.order.DBOrderByExpr

Construct a new DBOrderByInfo object set the specified parameters to this object.

DBParenthesisExpr - Class in org.apache.empire.db.expr.compare

This class wraps an existing compare expression with parenthesis.

DBParenthesisExpr(DBCompareExpr) - Constructor for class org.apache.empire.db.expr.compare.DBParenthesisExpr

DBQuery - Class in org.apache.empire.db

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.

DBQuery(DBCommandExpr, DBColumn[]) - Constructor for class org.apache.empire.db.DBQuery

Constructor initializes the query object.

DBQuery(DBCommandExpr, DBColumn) - Constructor for class org.apache.empire.db.DBQuery

Constructs a new DBQuery object initialize the query object.

DBQuery(DBCommandExpr) - Constructor for class org.apache.empire.db.DBQuery

Creaes a DBQuery object from a given command object.

DBQuery.DBQueryColumn - Class in org.apache.empire.db

DBQuery.DBQueryColumn(DBQuery, DBColumnExpr) - Constructor for class org.apache.empire.db.DBQuery.DBQueryColumn

Constructs a DBQueryColumn object set the specified parameters to this object.

DBReader - Class in org.apache.empire.db

This 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.

DBReader() - Constructor for class org.apache.empire.db.DBReader

Constructs an empty DBRecordSet object.

DBReader.DBReaderForwardIterator - Class in org.apache.empire.db

This is an iterator for forward only resultsets.

DBReader.DBReaderForwardIterator(int) - Constructor for class org.apache.empire.db.DBReader.DBReaderForwardIterator

DBReader.DBReaderIterator - Class in org.apache.empire.db

DBReader.DBReaderIterator(int) - Constructor for class org.apache.empire.db.DBReader.DBReaderIterator

DBReader.DBReaderScrollableIterator - Class in org.apache.empire.db

This is an iterator for scrolling resultsets.

DBReader.DBReaderScrollableIterator(int) - Constructor for class org.apache.empire.db.DBReader.DBReaderScrollableIterator

DBRecord - Class in org.apache.empire.db

This class handles one record from a database table.

DBRecord() - Constructor for class org.apache.empire.db.DBRecord

Create a new DBRecord object.
The record is not attached to a RowSet and the record's state is initially set to REC_INVALID.

DBRecord(DBRowSet) - Constructor for class org.apache.empire.db.DBRecord

DBRecord.State - Enum in org.apache.empire.db

DBRecordData - Class in org.apache.empire.db

This interface defines for the classes DDRecordSet and DBRecord.

DBRecordData() - Constructor for class org.apache.empire.db.DBRecordData

DBRelation - Class in org.apache.empire.db

This class creates a DBReferene object for a foreing key relation.

DBRelation(DBDatabase, String, DBRelation.DBReference[], DBRelation.DBCascadeAction) - Constructor for class org.apache.empire.db.DBRelation

Creates a DBRelation object for a foreing key relation.

DBRelation(DBDatabase, String, DBRelation.DBReference[]) - Constructor for class org.apache.empire.db.DBRelation

Creates a DBRelation object for a foreing key relation.

DBRelation.DBCascadeAction - Enum in org.apache.empire.db

DBCascadeAction enum

DBRelation.DBReference - Class in org.apache.empire.db

DBRelation.DBReference(DBTableColumn, DBTableColumn) - Constructor for class org.apache.empire.db.DBRelation.DBReference

DBRowSet - Class in org.apache.empire.db

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(DBDatabase) - Constructor for class org.apache.empire.db.DBRowSet

Constructs a DBRecord object set the current database object.

DBSetExpr - Class in org.apache.empire.db.expr.set

This class is used for building a set expression of a SQL update statement.

DBSetExpr(DBColumn, Object) - Constructor for class org.apache.empire.db.expr.set.DBSetExpr

Constructs a new DBSetExpr object.

DBSQLScript - Class in org.apache.empire.db

DBSQLScript
This class is a collection of sql command strings.
The class is used for obtaining and executing DDL commands supplied by the database driver (@see DBDatabaseDriver.getDDLScript(DBCmdType, DBObject, DBSQLScript))

DBSQLScript() - Constructor for class org.apache.empire.db.DBSQLScript

DBSQLScript(String) - Constructor for class org.apache.empire.db.DBSQLScript

DBTable - Class in org.apache.empire.db

This class represent one table of the database.

DBTable(String, DBDatabase) - Constructor for class org.apache.empire.db.DBTable

Construct a new DBTable object set the specified parameters to this object and add this object to the current database.

DBTableColumn - Class in org.apache.empire.db

This class represent one column of a table.

DBTableColumn(DBTable, DataType, String, double, DataMode, Object) - Constructor for class org.apache.empire.db.DBTableColumn

Constructs a DBTableColumn object set the specified parameters to this object.

DBTableColumn(DBTable, DBTableColumn) - Constructor for class org.apache.empire.db.DBTableColumn

Clone Constructor - use clone()

DBValueExpr - Class in org.apache.empire.db.expr.column

This class is used for declaring constant values in SQL.

DBValueExpr(DBDatabase, Object, DataType) - Constructor for class org.apache.empire.db.expr.column.DBValueExpr

Constructs a new DBValueExpr object.

DBValueExpr(DBColumnExpr, Object) - Constructor for class org.apache.empire.db.expr.column.DBValueExpr

Construct a new DBValueExpr object set the specified parameters to this object.

DBView - Class in org.apache.empire.db

This class represents a database view.

DBView(String, DBDatabase, boolean) - Constructor for class org.apache.empire.db.DBView

Creates a view object for a given view in the database.

DBView(String, DBDatabase) - Constructor for class org.apache.empire.db.DBView

Creates a view object for a given view in the database.

DBView.DBViewColumn - Class in org.apache.empire.db

DBView.DBViewColumn(DBView, String, DBColumnExpr) - Constructor for class org.apache.empire.db.DBView.DBViewColumn

Constructs a DBViewColumn object set the specified parameters to this object.

DBXmlDictionary - Class in org.apache.empire.db

This class is used to configure XML generation as performed by the getXmlDocument Document function on DBReader and DBRecord.

DBXmlDictionary() - Constructor for class org.apache.empire.db.DBXmlDictionary

ddlColumnDefaults - Variable in class org.apache.empire.db.DBDatabaseDriver

debug(Document) - Static method in class org.apache.empire.xml.XMLWriter

Prints out the DOM-Tree on System.out for debugging purposes.

debugToFile(Document, String) - Static method in class org.apache.empire.xml.XMLWriter

Prints out the DOM-Tree to a file for debugging purposes.

decode(Map<?, ?>, Object) - Method in class org.apache.empire.db.DBColumnExpr

Creates and returns a sql-expression that compares the current column expression with a list of values and returns the corresponding alternative value.

decode(Object, Object, Object) - Method in class org.apache.empire.db.DBColumnExpr

decode(Object, Object, Object, Object, Object) - Method in class org.apache.empire.db.DBColumnExpr

decode(Object, Object, Object, Object, Object, Object, Object) - Method in class org.apache.empire.db.DBColumnExpr

decode(Options, Object) - Method in class org.apache.empire.db.DBColumnExpr

decode(Options) - Method in class org.apache.empire.db.DBColumnExpr

DEFAULT - Static variable in class org.apache.empire.db.DBTable

defValue - Variable in class org.apache.empire.db.DBTableColumn

delete(Connection) - Method in class org.apache.empire.db.DBRecord

This helper function calls the DBRowset.deleteRecord method to delete the record.

deleteAllReferences(Object[], Connection) - Method in class org.apache.empire.db.DBRowSet

Deletes all records which reference this table.

deleteRecord(Object[], Connection) - Method in class org.apache.empire.db.DBCommandExpr.DBCmdQuery

Returns the error message: ERR_NOTSUPPORTED

deleteRecord(Object[], Connection) - Method in class org.apache.empire.db.DBQuery

Deletes a record identified by its primary key from the database.

deleteRecord(Object[], Connection) - Method in class org.apache.empire.db.DBRowSet

deleteRecord(Object, Connection) - Method in class org.apache.empire.db.DBRowSet

Deletes a single record from the database.

deleteRecord(Object[], Connection) - Method in class org.apache.empire.db.DBTable

Creates a delete SQL-Command by using the DBCommand getDelete method execute the the SQL-Command with the DBDatabase executeSQL method.

deleteRecord(Object[], Connection) - Method in class org.apache.empire.db.DBView

deleteReferenceRecords(DBRelation.DBReference[], Object[], Connection) - Method in class org.apache.empire.db.DBRowSet

Deletes all records which are referenced by a particular relation.

DerbyDDLGenerator - Class in org.apache.empire.db.derby

DerbyDDLGenerator(DBDatabaseDriverDerby) - Constructor for class org.apache.empire.db.derby.DerbyDDLGenerator

desc() - Method in class org.apache.empire.db.DBColumnExpr

creates a new DBOrderByExpr for descending order

desc - Variable in class org.apache.empire.db.expr.order.DBOrderByExpr

detachDatabase(DBDatabase, Connection) - Method in class org.apache.empire.db.DBDatabaseDriver

Called when a database is closed

detectDataType(Object) - Method in class org.apache.empire.db.DBColumnExpr

Detects the DataType of a given value.

detectQuoteName(String) - Method in class org.apache.empire.db.DBDatabaseDriver

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"

detectQuoteName(String) - Method in class org.apache.empire.db.DBDDLGenerator

dispose() - Method in class org.apache.empire.db.DBReader.DBReaderIterator

Disposes the iterator.

divideBy(Object) - Method in class org.apache.empire.db.DBColumnExpr

Creates and returns a new calculation object for the SQL "/" (divide) operator.

domain - Variable in class org.apache.empire.data.bean.BeanClass

driver - Variable in class org.apache.empire.db.DBDatabase

driver - Variable in class org.apache.empire.db.DBDDLGenerator

driverFromObject(DBObject) - Static method in exception org.apache.empire.db.exceptions.EmpireSQLException

dropDatabase(DBDatabase, DBSQLScript) - Method in class org.apache.empire.db.DBDDLGenerator

Appends the DDL-Script for dropping a database to the given script object

dropDatabase(DBDatabase, DBSQLScript) - Method in class org.apache.empire.db.oracle.OracleDDLGenerator

dropObject(String, String, DBSQLScript) - Method in class org.apache.empire.db.DBDDLGenerator

Appends the DDL-Script for dropping a database object to an SQL-Script

E

EmpireException - Exception in org.apache.empire.exceptions

This exception type is used for all empire errors.
Exceptions will only be thrown if exceptions are enabled in the ErrorObject.

EmpireException(ErrorType, String[], Throwable) - Constructor for exception org.apache.empire.exceptions.EmpireException

Constructor for derived classes

EmpireException(ErrorType, String[]) - Constructor for exception org.apache.empire.exceptions.EmpireException

Constructor for derived classes

EmpireFileException - Exception in org.apache.empire.exceptions

This exception type is used for all empire errors.
Exceptions will only be thrown if exceptions are enabled in the ErrorObject.

EmpireFileException(ErrorType, String[], Throwable) - Constructor for exception org.apache.empire.exceptions.EmpireFileException

EmpireSQLException - Exception in org.apache.empire.db.exceptions

EmpireSQLException(DBDatabaseDriver, SQLException) - Constructor for exception org.apache.empire.db.exceptions.EmpireSQLException

EmpireSQLException(DBObject, SQLException) - Constructor for exception org.apache.empire.db.exceptions.EmpireSQLException

EmpireSQLException(ErrorType, String[], int, SQLException) - Constructor for exception org.apache.empire.db.exceptions.EmpireSQLException

EMPTY_STRING - Static variable in class org.apache.empire.db.DBDatabase

equals(Object) - Method in class org.apache.empire.commons.Attributes.Attribute

equals(Object) - Method in class org.apache.empire.db.DBColumn

equals(Object) - Method in class org.apache.empire.db.DBRowSet

equals(Object) - Method in class org.apache.empire.db.expr.column.DBAliasExpr

Overrides the equals method

equals(Object) - Method in class org.apache.empire.db.expr.column.DBConcatExpr

equals(Object) - Method in class org.apache.empire.db.expr.join.DBJoinExpr

Compares two DBJoinExpr objects.

equals(Object) - Method in class org.apache.empire.db.oracle.OracleRowNumExpr

ErrorType - Class in org.apache.empire.commons

The ErrorType class defines a type of error.

ErrorType(String, String) - Constructor for class org.apache.empire.commons.ErrorType

Defines an error type.

errorType - Static variable in exception org.apache.empire.db.exceptions.DatabaseNotOpenException

errorType - Static variable in exception org.apache.empire.db.exceptions.EmpireSQLException

errorType - Static variable in exception org.apache.empire.db.exceptions.FieldIllegalValueException

errorType - Static variable in exception org.apache.empire.db.exceptions.FieldIsReadOnlyException

errorType - Static variable in exception org.apache.empire.db.exceptions.FieldNotNullException

errorType - Static variable in exception org.apache.empire.db.exceptions.FieldValueTooLongException

errorType - Static variable in exception org.apache.empire.db.exceptions.InvalidKeyException

errorType - Static variable in exception org.apache.empire.db.exceptions.NoPrimaryKeyException

errorType - Static variable in exception org.apache.empire.db.exceptions.QueryFailedException

errorType - Static variable in exception org.apache.empire.db.exceptions.QueryNoResultException

errorType - Static variable in exception org.apache.empire.db.exceptions.RecordDeleteFailedException

errorType - Static variable in exception org.apache.empire.db.exceptions.RecordNotFoundException

errorType - Static variable in exception org.apache.empire.db.exceptions.RecordUpdateFailedException

errorType - Static variable in exception org.apache.empire.db.exceptions.RecordUpdateInvalidException

errorType - Static variable in exception org.apache.empire.db.exceptions.StatementFailedException

errorType - Static variable in exception org.apache.empire.exceptions.BeanIncompatibleException

errorType - Static variable in exception org.apache.empire.exceptions.BeanInstantiationException

errorType - Static variable in exception org.apache.empire.exceptions.BeanPropertyGetException

errorType - Static variable in exception org.apache.empire.exceptions.BeanPropertySetException

errorType - Static variable in exception org.apache.empire.exceptions.FileParseException

errorType - Static variable in exception org.apache.empire.exceptions.FileReadException

errorType - Static variable in exception org.apache.empire.exceptions.FileWriteException

errorType - Static variable in exception org.apache.empire.exceptions.InternalException

errorType - Static variable in exception org.apache.empire.exceptions.InvalidArgumentException

errorType - Static variable in exception org.apache.empire.exceptions.InvalidPropertyException

errorType - Static variable in exception org.apache.empire.exceptions.ItemExistsException

errorType - Static variable in exception org.apache.empire.exceptions.ItemNotFoundException

errorType - Static variable in exception org.apache.empire.exceptions.MiscellaneousErrorException

errorType - Static variable in exception org.apache.empire.exceptions.NotImplementedException

errorType - Static variable in exception org.apache.empire.exceptions.NotSupportedException

errorType - Static variable in exception org.apache.empire.exceptions.ObjectNotValidException

errorType - Static variable in exception org.apache.empire.exceptions.PropertyReadOnlyException

errorType - Static variable in exception org.apache.empire.exceptions.UnexpectedReturnValueException

executeDelete(DBTable, DBCommand, Connection) - Method in class org.apache.empire.db.DBDatabase

Executes a Delete statement from a command object

executeInsert(DBCommand, Connection) - Method in class org.apache.empire.db.DBDatabase

Executes an Insert statement from a command object

executeQuery(String, Object[], boolean, Connection) - Method in class org.apache.empire.db.DBDatabase

Executes a select SQL-Statement and returns a ResultSet containing the query results.
This function returns a JDBC ResultSet.
Instead of using this function directly you should use a DBReader object instead.

executeQuery(String, Object[], boolean, Connection) - Method in class org.apache.empire.db.DBDatabaseDriver

executeSQL(String, Object[], Connection, DBDatabaseDriver.DBSetGenKeys) - Method in class org.apache.empire.db.DBDatabase

Executes an update, insert or delete SQL-Statement.
We recommend to use a DBCommand object in order to build the sqlCmd.

executeSQL(String, Object[], Connection) - Method in class org.apache.empire.db.DBDatabase

executeSQL(String, Connection) - Method in class org.apache.empire.db.DBDatabase

Deprecated. This method has be deprecated in order to avoid missing command parameters for prepared statements

 Instead of using this method signature please use any of the following:
      executeInsert(...)
      executeUpdate(...)
      executeDelete(...)
 or use  
      executeSQL(String sqlCmd, Object[] sqlParams, Connection conn)
 

executeSQL(String, Object[], Connection, DBDatabaseDriver.DBSetGenKeys) - Method in class org.apache.empire.db.DBDatabaseDriver

Executes the select, update or delete SQL-Command with a Statement object.

executeSQL(String, Object[], Connection, DBDatabaseDriver.DBSetGenKeys) - Method in class org.apache.empire.db.sqlite.DBDatabaseDriverSQLite

executeUpdate(DBCommand, Connection) - Method in class org.apache.empire.db.DBDatabase

Executes an Update statement from a command object

expr - Variable in class org.apache.empire.db.DBQuery.DBQueryColumn

expr - Variable in class org.apache.empire.db.DBView.DBViewColumn

expr - Variable in class org.apache.empire.db.expr.column.DBAbstractFuncExpr

expr - Variable in class org.apache.empire.db.expr.compare.DBCompareColExpr

expr - Variable in class org.apache.empire.db.expr.compare.DBCompareNotExpr

expr - Variable in class org.apache.empire.db.expr.order.DBOrderByExpr

extractErrorMessage(SQLException) - Method in class org.apache.empire.db.DBDatabaseDriver

Extracts native error message of an sqlExeption.

extractErrorMessage(SQLException) - Method in class org.apache.empire.db.oracle.DBDatabaseDriverOracle

Extracts native error message of an sqlExeption.

F

fetch(Connection, int) - Method in class org.apache.empire.data.bean.BeanResult

fetch(Connection) - Method in class org.apache.empire.data.bean.BeanResult

FieldIllegalValueException - Exception in org.apache.empire.db.exceptions

FieldIllegalValueException(Column, String, Throwable) - Constructor for exception org.apache.empire.db.exceptions.FieldIllegalValueException

FieldIllegalValueException(Column, String) - Constructor for exception org.apache.empire.db.exceptions.FieldIllegalValueException

FieldIsReadOnlyException - Exception in org.apache.empire.db.exceptions

FieldIsReadOnlyException(Column) - Constructor for exception org.apache.empire.db.exceptions.FieldIsReadOnlyException

FieldNotNullException - Exception in org.apache.empire.db.exceptions

FieldNotNullException(Column) - Constructor for exception org.apache.empire.db.exceptions.FieldNotNullException

FieldValueException - Exception in org.apache.empire.db.exceptions

FieldValueException(Column, ErrorType, String[], Throwable) - Constructor for exception org.apache.empire.db.exceptions.FieldValueException

FieldValueException(Column, ErrorType, String[]) - Constructor for exception org.apache.empire.db.exceptions.FieldValueException

FieldValueOutOfRangeException - Exception in org.apache.empire.db.exceptions

FieldValueOutOfRangeException(Column) - Constructor for exception org.apache.empire.db.exceptions.FieldValueOutOfRangeException

FieldValueOutOfRangeException(Column, Number, Number) - Constructor for exception org.apache.empire.db.exceptions.FieldValueOutOfRangeException

FieldValueOutOfRangeException(Column, Number, boolean) - Constructor for exception org.apache.empire.db.exceptions.FieldValueOutOfRangeException

FieldValueTooLongException - Exception in org.apache.empire.db.exceptions

FieldValueTooLongException(Column) - Constructor for exception org.apache.empire.db.exceptions.FieldValueTooLongException

FileParseException - Exception in org.apache.empire.exceptions

FileParseException(String, Exception) - Constructor for exception org.apache.empire.exceptions.FileParseException

FileParseException(String) - Constructor for exception org.apache.empire.exceptions.FileParseException

FileReadException - Exception in org.apache.empire.exceptions

FileReadException(String, IOException) - Constructor for exception org.apache.empire.exceptions.FileReadException

FileWriteException - Exception in org.apache.empire.exceptions

FileWriteException(String, IOException) - Constructor for exception org.apache.empire.exceptions.FileWriteException

fillDataDictionnary(String, String, String, int, int, int, int, String) - Method in class org.apache.empire.db.oracle.OracleDataDictionnary

fillMissingDefaults(Connection) - Method in class org.apache.empire.db.DBRecord

Set the record default value for the fields with the value ObjectUtils.NO_VALUE

findByClass(Class<? extends DBDatabase>) - Static method in class org.apache.empire.db.DBDatabase

find a database by id

findById(String) - Static method in class org.apache.empire.db.DBColumn

returns a rowset by its identifier

findById(String) - Static method in class org.apache.empire.db.DBDatabase

find a database by id

findById(String) - Static method in class org.apache.empire.db.DBRowSet

returns a rowset by its identifier

findFirstChild(Node, String) - Static method in class org.apache.empire.xml.XMLUtil

Finds the first (direct) child Element with a given tag name.

findFirstChildDeep(Element, String) - Static method in class org.apache.empire.xml.XMLUtil

Finds the first element which name matchtes a given tag name that is locacted anywhere below the given parent.

findFirstChildDeep(Document, String) - Static method in class org.apache.empire.xml.XMLUtil

Returns the first element which name matchtes a given tag name.

findFirstChildWithAttrib(Node, String, String, Object) - Static method in class org.apache.empire.xml.XMLUtil

Finds the first (direct) child element with a given tag name and attribute.

findQueryColumn(DBColumnExpr) - Method in class org.apache.empire.db.DBQuery

This function searchs for equal columns given by the specified DBColumnExpr object.

findViewColumn(DBColumnExpr) - Method in class org.apache.empire.db.DBView

This function searchs for equal columns given by the specified DBColumnExpr object.

formatDate(Date, Locale) - Static method in class org.apache.empire.commons.DateUtils

formatDate(Date, boolean) - Static method in class org.apache.empire.commons.ObjectUtils

Formats a given date object to a standard date string.

formatDayOfWeek(Date, Locale, boolean) - Static method in class org.apache.empire.commons.DateUtils

formatErrorMessage(ErrorType, String, String[]) - Static method in exception org.apache.empire.exceptions.EmpireException

formatMonth(Date, Locale, boolean) - Static method in class org.apache.empire.commons.DateUtils

formatMonth(int, Locale, boolean) - Static method in class org.apache.empire.commons.DateUtils

formatTime(Date, Locale, boolean) - Static method in class org.apache.empire.commons.DateUtils

formatYear(Date, Locale) - Static method in class org.apache.empire.commons.DateUtils

G

GENERAL_SQL_KEYWORDS - Static variable in class org.apache.empire.db.DBDatabaseDriver

get(String) - Method in class org.apache.empire.commons.Attributes

get(Object) - Method in class org.apache.empire.commons.Options

getAlias() - Method in class org.apache.empire.db.DBCommandExpr.DBCmdQuery

Not applicable - returns null

getAlias() - Method in class org.apache.empire.db.DBQuery

not applicable - returns null

getAlias() - Method in class org.apache.empire.db.DBRowSet

getAlias() - Method in class org.apache.empire.db.DBTable

Returns the table alias name of this object.

getAlias() - Method in class org.apache.empire.db.DBView

Returns the alias name of this object.

getAttribute(String) - Method in class org.apache.empire.data.bean.BeanProperty

Returns the value of a column attribute.

getAttribute(String) - Method in interface org.apache.empire.data.ColumnExpr

Returns futher metadata attributes.

getAttribute(String) - Method in class org.apache.empire.db.DBColumn

getAttribute(String) - Method in class org.apache.empire.db.DBColumnExpr

Returns the value of a column attribute.

getAttribute(String) - Method in class org.apache.empire.db.DBCommandExpr.DBCmdColumn

Get Attributes of underlying table column.

getAttribute(String) - Method in class org.apache.empire.db.DBQuery.DBQueryColumn

getAttribute(String) - Method in class org.apache.empire.db.DBView.DBViewColumn

getBean() - Method in class org.apache.empire.data.bean.BeanRecordProxy

getBeanClass() - Method in class org.apache.empire.data.bean.BeanProperty

returns the bean class of this property.

getBeanList(C, Class<T>, int) - Method in class org.apache.empire.db.DBReader

Returns the result of a query as a list of objects restricted to a maximum number of objects (unless maxCount is -1).

getBeanList(Class<T>, int) - Method in class org.apache.empire.db.DBReader

Returns the result of a query as a list of objects.

getBeanList(Class<T>) - Method in class org.apache.empire.db.DBReader

Returns the result of a query as a list of objects.

getBeanProperties(Object) - Method in class org.apache.empire.data.bean.BeanRecordProxy

getBeanProperties(Object, Collection<ColumnExpr>) - Method in class org.apache.empire.data.bean.BeanRecordProxy

getBeanProperties(Object, Collection<ColumnExpr>) - Method in interface org.apache.empire.data.RecordData

copies all field values into a static Java Bean.

getBeanProperties(Object) - Method in interface org.apache.empire.data.RecordData

copies all field values into a static Java Bean.

getBeanProperties(Object, Collection<ColumnExpr>) - Method in class org.apache.empire.db.DBRecordData

Injects the current field values into a java bean.

getBeanProperties(Object) - Method in class org.apache.empire.db.DBRecordData

Injects the current field values into a java bean.

getBeanProperty(Object, String, Object) - Method in class org.apache.empire.db.DBRecordData

Set a single property value of a java bean object used by readProperties.

getBeanPropertyName() - Method in class org.apache.empire.data.bean.BeanProperty

Gets the Java bean property name.

getBeanPropertyName() - Method in interface org.apache.empire.data.ColumnExpr

Returns the name of a Java bean property to which this column is mapped.

getBeanPropertyName() - Method in class org.apache.empire.db.DBColumnExpr

Gets the Java bean property name for this column i.e.

getBeanPropertyValue(Object, ColumnExpr) - Method in class org.apache.empire.data.bean.BeanRecordProxy

getBeanPropertyValue(Object, String) - Method in class org.apache.empire.data.bean.BeanRecordProxy

getBoolean(Object) - Static method in class org.apache.empire.commons.ObjectUtils

Converts an object value to a boolean.

getBoolean(int) - Method in class org.apache.empire.db.DBRecordData

Returns a data value identified by the column index.

getBoolean(ColumnExpr) - Method in class org.apache.empire.db.DBRecordData

Returns a data value for the desired column.

getBooleanType() - Method in class org.apache.empire.db.oracle.DBDatabaseDriverOracle

getCharacterSet() - Method in class org.apache.empire.db.mysql.DBDatabaseDriverMySQL

getCharLength() - Method in class org.apache.empire.db.oracle.OracleDataDictionnary.ColumnInfo

getChildText(Node, String) - Static method in class org.apache.empire.xml.XMLUtil

Returns the text value of a given child element.

getClasses() - Method in class org.apache.empire.data.bean.BeanDomain

getCmdColumn(DBColumnExpr) - Method in class org.apache.empire.db.DBCommandExpr

returns column expression that is specific for to this command and detached from its source.

getCmdParamValue(Object) - Method in class org.apache.empire.db.DBCmdParam

Returns the internal parameter value for a given "real" value.

getCmpop() - Method in class org.apache.empire.db.expr.compare.DBCompareColExpr

Gets the comparison operator

getColumn(int) - Method in class org.apache.empire.data.bean.BeanRecordProxy

getColumn(int) - Method in interface org.apache.empire.data.Record

returns the column at the specified index.

getColumn(int) - Method in class org.apache.empire.db.DBRecord

Implements the Record Interface getColumn method.
Internally calls getDBColumn()

getColumn(int) - Method in class org.apache.empire.db.DBRowSet

Returns a DBColumn object by a specified index value.

getColumn(String) - Method in class org.apache.empire.db.DBRowSet

Gets the column Expression with a particular name.

getColumn() - Method in exception org.apache.empire.db.exceptions.FieldValueException

getColumn() - Method in class org.apache.empire.db.expr.order.DBOrderByExpr

getColumn() - Method in class org.apache.empire.db.expr.set.DBSetExpr

getColumnAutoValue(DBDatabase, DBTableColumn, Connection) - Method in class org.apache.empire.db.DBDatabaseDriver

Returns an auto-generated value for a particular column

getColumnAutoValue(DBDatabase, DBTableColumn, Connection) - Method in class org.apache.empire.db.sqlserver.DBDatabaseDriverMSSQL

Returns an auto-generated value for a particular column

getColumnExpr(int) - Method in class org.apache.empire.data.bean.BeanRecordProxy

getColumnExpr(int) - Method in interface org.apache.empire.data.RecordData

returns the column expression for a given column This is the reverse operation of getFieldIndex()

getColumnExpr(int) - Method in class org.apache.empire.db.DBReader

Get the column Expression at position

getColumnExpr(int) - Method in class org.apache.empire.db.DBRecord

Returns a DBColumnExpr object by a specified index value.

getColumnExpr(int) - Method in class org.apache.empire.db.DBRecordData

getColumnExpr() - Method in class org.apache.empire.db.expr.compare.DBCompareColExpr

Gets the DBColumnExpr object

getColumnExpr() - Method in class org.apache.empire.db.expr.order.DBOrderByExpr

getColumnIndex(DBColumn) - Method in class org.apache.empire.db.DBRowSet

Gets the index of a particular column expression.

getColumnIndex(Column) - Method in class org.apache.empire.db.DBRowSet

Gets the index of a particular column expression.

getColumnPos(DBColumn) - Method in class org.apache.empire.db.DBExpressionIndex

Gets the position of a specified DBColumn object.

getColumnPos(DBColumn) - Method in class org.apache.empire.db.DBIndex

Gets the position of a specified DBColumn object.

getColumnReferences() - Method in class org.apache.empire.db.DBRowSet

Returns the a list of column references.

getColumns() - Method in class org.apache.empire.db.DBIndex

Returns the columns belonging to this index.

getColumns() - Method in class org.apache.empire.db.DBRowSet

Gets all columns of this rowset (e.g.

getColumnTitle(Column) - Static method in exception org.apache.empire.db.exceptions.FieldValueException

getCommand() - Method in class org.apache.empire.data.bean.BeanResult

getCommandExpr() - Method in class org.apache.empire.db.DBQuery

returns the underlying command expression

getComment() - Method in class org.apache.empire.db.DBColumn

Returns a comment describing the column in the data scheme.

getComment() - Method in class org.apache.empire.db.DBRowSet

getControlType() - Method in class org.apache.empire.data.bean.BeanProperty

Returns the columns control type.

getControlType() - Method in interface org.apache.empire.data.ColumnExpr

Returns the column's control type used for displaying and entering data.

getControlType() - Method in class org.apache.empire.db.DBColumnExpr

Returns the column control type.

getConvertPhrase(DataType, DataType, Object) - Method in class org.apache.empire.db.DBDatabaseDriver

Returns a data type convertion phrase template for this driver
The returned template must contain a '?' which will be replaced by a column expression.

getConvertPhrase(DataType, DataType, Object) - Method in class org.apache.empire.db.derby.DBDatabaseDriverDerby

getConvertPhrase(DataType, DataType, Object) - Method in class org.apache.empire.db.h2.DBDatabaseDriverH2

getConvertPhrase(DataType, DataType, Object) - Method in class org.apache.empire.db.hsql.DBDatabaseDriverHSql

getConvertPhrase(DataType, DataType, Object) - Method in class org.apache.empire.db.mysql.DBDatabaseDriverMySQL

getConvertPhrase(DataType, DataType, Object) - Method in class org.apache.empire.db.oracle.DBDatabaseDriverOracle

getConvertPhrase(DataType, DataType, Object) - Method in class org.apache.empire.db.postgresql.DBDatabaseDriverPostgreSQL

getConvertPhrase(DataType, DataType, Object) - Method in class org.apache.empire.db.sqlite.DBDatabaseDriverSQLite

getConvertPhrase(DataType, DataType, Object) - Method in class org.apache.empire.db.sqlserver.DBDatabaseDriverMSSQL

getCount() - Method in class org.apache.empire.db.DBSQLScript

Returns the number of statements in this script

getCreateDDLScript(DBDatabaseDriver, DBSQLScript) - Method in class org.apache.empire.db.DBDatabase

Creates a DDL Script for creating all database objects on the target database.
This function may be called even if the database has not been previously opened.

getDatabase() - Method in class org.apache.empire.db.DBCmdParam

getDatabase() - Method in class org.apache.empire.db.DBColumn

getDatabase() - Method in class org.apache.empire.db.DBCombinedCmd

Returns the current DBDatabase object.

getDatabase() - Method in class org.apache.empire.db.DBCommand

Returns the current DBDatabase object.

getDatabase() - Method in class org.apache.empire.db.DBDatabase

getDatabase() - Method in class org.apache.empire.db.DBExpressionIndex

getDatabase() - Method in class org.apache.empire.db.DBIndex

getDatabase() - Method in class org.apache.empire.db.DBObject

Returns the database object to which this object belongs to.

getDatabase() - Method in class org.apache.empire.db.DBReader

Returns the current DBDatabase object.

getDatabase() - Method in class org.apache.empire.db.DBRecord

Returns the current DBDatabase object.

getDatabase() - Method in class org.apache.empire.db.DBRelation

getDatabase() - Method in class org.apache.empire.db.DBRowSet

Returns the current DBDatabase object.

getDatabase() - Method in class org.apache.empire.db.expr.column.DBAbstractFuncExpr

Returns the current DBDatabase object.

getDatabase() - Method in class org.apache.empire.db.expr.column.DBAliasExpr

Returns the current DBDatabase object.

getDatabase() - Method in class org.apache.empire.db.expr.column.DBCalcExpr

Returns the current DBDatabase object.

getDatabase() - Method in class org.apache.empire.db.expr.column.DBCaseExpr

getDatabase() - Method in class org.apache.empire.db.expr.column.DBConcatExpr

getDatabase() - Method in class org.apache.empire.db.expr.column.DBCountExpr

Returns the current DBDatabase object.

getDatabase() - Method in class org.apache.empire.db.expr.column.DBValueExpr

Returns the current DBDatabase object.

getDatabase() - Method in class org.apache.empire.db.expr.compare.DBCompareAndOrExpr

Returns the current DBDatabase object.

getDatabase() - Method in class org.apache.empire.db.expr.compare.DBCompareColExpr

Returns the current DBDatabase object.

getDatabase() - Method in class org.apache.empire.db.expr.compare.DBCompareNotExpr

Returns the current DBDatabase object.

getDatabase() - Method in class org.apache.empire.db.expr.compare.DBExistsExpr

Returns the current DBDatabase object.

getDatabase() - Method in class org.apache.empire.db.expr.compare.DBParenthesisExpr

getDatabase() - Method in class org.apache.empire.db.expr.join.DBJoinExpr

Returns the current DBDatabase object.

getDatabase() - Method in class org.apache.empire.db.expr.order.DBOrderByExpr

getDatabase() - Method in class org.apache.empire.db.expr.set.DBSetExpr

Returns the current DBDatabase object.

getDatabase() - Method in class org.apache.empire.db.oracle.OracleRowNumExpr

Returns the current DBDatabase object.

getDatabaseDriver() - Method in class org.apache.empire.db.expr.column.DBAbstractFuncExpr

returns the Database driver or null if the Expression is not attached to an open database
This function is intended for convenience only.

getDatabaseName() - Method in class org.apache.empire.db.derby.DBDatabaseDriverDerby

returns the name for the database / schema

getDatabaseName() - Method in class org.apache.empire.db.h2.DBDatabaseDriverH2

returns the name for the database / schema

getDatabaseName() - Method in class org.apache.empire.db.mysql.DBDatabaseDriverMySQL

returns the name for the database / schema

getDatabaseName() - Method in class org.apache.empire.db.postgresql.DBDatabaseDriverPostgreSQL

returns the name for the database / schema

getDatabaseName() - Method in class org.apache.empire.db.sqlserver.DBDatabaseDriverMSSQL

getDataLength() - Method in class org.apache.empire.db.oracle.OracleDataDictionnary.ColumnInfo

getDataPrecision() - Method in class org.apache.empire.db.oracle.OracleDataDictionnary.ColumnInfo

getDataScale() - Method in class org.apache.empire.db.oracle.OracleDataDictionnary.ColumnInfo

getDataType() - Method in class org.apache.empire.data.bean.BeanProperty

Returns the data type of the bean property.

getDataType() - Method in interface org.apache.empire.data.ColumnExpr

Returns the column's data type.

getDataType() - Method in class org.apache.empire.db.DBCmdParam

Returns the data type of the command parameter

getDataType() - Method in class org.apache.empire.db.DBColumnExpr

Returns the data type of this column expression.

getDataType() - Method in class org.apache.empire.db.DBCommandExpr.DBCmdColumn

Returns the data type of the DBColumnExpr object.

getDataType() - Method in class org.apache.empire.db.DBQuery.DBQueryColumn

getDataType() - Method in class org.apache.empire.db.DBTableColumn

Returns the data type.

getDataType() - Method in class org.apache.empire.db.DBView.DBViewColumn

getDataType() - Method in class org.apache.empire.db.expr.column.DBAbstractFuncExpr

Returns the data type of the DBColumnExpr object.

getDataType() - Method in class org.apache.empire.db.expr.column.DBAliasExpr

Returns the data type of the DBColumnExpr object.

getDataType() - Method in class org.apache.empire.db.expr.column.DBCalcExpr

Returns the data type: DBDataType.DECIMAL.

getDataType() - Method in class org.apache.empire.db.expr.column.DBCaseExpr

getDataType() - Method in class org.apache.empire.db.expr.column.DBConcatExpr

Returns the data type: DataType.TEXT

getDataType() - Method in class org.apache.empire.db.expr.column.DBCountExpr

Returns the data type: DT_INTEGER.

getDataType() - Method in class org.apache.empire.db.expr.column.DBValueExpr

Returns the data type of the DBColumnExpr object.

getDataType() - Method in class org.apache.empire.db.oracle.OracleDataDictionnary.ColumnInfo

getDataType() - Method in class org.apache.empire.db.oracle.OracleRowNumExpr

Returns the data type of the DBColumnExpr object.

getDate(int, int, int) - Static method in class org.apache.empire.commons.DateUtils

getDate(Object, Locale) - Static method in class org.apache.empire.commons.ObjectUtils

Converts an object value to a Date.

getDate(Object) - Static method in class org.apache.empire.commons.ObjectUtils

Converts an object value to a Date.

getDateNow() - Static method in class org.apache.empire.commons.DateUtils

Returns the current date without time

getDateOnly(Date) - Static method in class org.apache.empire.commons.DateUtils

getDateTime(int) - Method in class org.apache.empire.db.DBRecordData

Returns a data value identified by the column index.

getDateTime(ColumnExpr) - Method in class org.apache.empire.db.DBRecordData

Returns a data value for the desired column.

getDateTimeFromNow(boolean, int, int, int) - Static method in class org.apache.empire.commons.DateUtils

returns a date relative from the current date.

getDBColumn(int) - Method in class org.apache.empire.db.DBRecord

Returns the DBColumn for the field at the given index.

getDDLScript(DBCmdType, DBObject, DBSQLScript) - Method in class org.apache.empire.db.DBDatabaseDriver

Gets a SQL command for creating, modifying or deleting objects in the database (tables, columns, constraints, etc.)

getDDLScript(DBCmdType, DBObject, DBSQLScript) - Method in class org.apache.empire.db.DBDDLGenerator

getDDLScript(DBCmdType, DBObject, DBSQLScript) - Method in class org.apache.empire.db.derby.DBDatabaseDriverDerby

getDDLScript(DBCmdType, DBObject, DBSQLScript) - Method in class org.apache.empire.db.h2.DBDatabaseDriverH2

getDDLScript(DBCmdType, DBObject, DBSQLScript) - Method in class org.apache.empire.db.hsql.DBDatabaseDriverHSql

getDDLScript(DBCmdType, DBObject, DBSQLScript) - Method in class org.apache.empire.db.mysql.DBDatabaseDriverMySQL

getDDLScript(DBCmdType, DBObject, DBSQLScript) - Method in class org.apache.empire.db.oracle.DBDatabaseDriverOracle

getDDLScript(DBCmdType, DBObject, DBSQLScript) - Method in class org.apache.empire.db.postgresql.DBDatabaseDriverPostgreSQL

getDDLScript(DBCmdType, DBObject, DBSQLScript) - Method in class org.apache.empire.db.sqlite.DBDatabaseDriverSQLite

getDDLScript(DBCmdType, DBObject, DBSQLScript) - Method in class org.apache.empire.db.sqlserver.DBDatabaseDriverMSSQL

getDecimal(Object, BigDecimal) - Static method in class org.apache.empire.commons.ObjectUtils

Converts an object value to a BigDecimal.

getDecimal(Object) - Static method in class org.apache.empire.commons.ObjectUtils

Converts an object value to a BigDecimal.

getDecimal(int) - Method in class org.apache.empire.db.DBRecordData

Returns a data value identified by the column index.

getDecimal(ColumnExpr) - Method in class org.apache.empire.db.DBRecordData

Returns a data value for the desired column.

getDefaultValue() - Method in class org.apache.empire.db.DBTableColumn

Returns the default column value.

getDelete(DBTable) - Method in class org.apache.empire.db.DBCommand

Creates the delete SQL-Command.

getDelete(DBTable) - Method in class org.apache.empire.db.oracle.DBCommandOracle

Creates an Oracle specific delete statement.

getDictionnary() - Method in class org.apache.empire.db.oracle.OracleDataDictionnary

getDocumentBuilder() - Static method in class org.apache.empire.xml.XMLUtil

Returns an initialzed, namespace aware DocumentBuilder.

getDomain() - Method in class org.apache.empire.data.bean.BeanClass

returns the domain this class belongs to (if any)

getDouble(Object, double) - Static method in class org.apache.empire.commons.ObjectUtils

Converts an object value to a double.

getDouble(Object) - Static method in class org.apache.empire.commons.ObjectUtils

Converts an object value to a double.

getDouble(int) - Method in class org.apache.empire.db.DBRecordData

Returns a data value identified by the column index.

getDouble(ColumnExpr) - Method in class org.apache.empire.db.DBRecordData

Returns a data value for the desired column.

getDriver() - Method in class org.apache.empire.db.DBDatabase

Returns the driver for this database.

getElementText(Node) - Static method in class org.apache.empire.xml.XMLUtil

Retrieves the text of a given element.

getEngine() - Method in class org.apache.empire.db.mysql.DBDatabaseDriverMySQL

Get the table engine that is used when creating new tables

getEntry(Object) - Method in class org.apache.empire.commons.Options

getErrorParams() - Method in exception org.apache.empire.exceptions.EmpireException

The message parameters for the message.

getErrorType() - Method in exception org.apache.empire.exceptions.EmpireException

The type of error that occurred

getExpr() - Method in class org.apache.empire.db.expr.column.DBAliasExpr

This helper function returns the underlying column expression.

getExpressions() - Method in class org.apache.empire.db.DBExpressionIndex

Returns the columnExpressions belonging to this index.

getExpressions() - Method in class org.apache.empire.db.DBIndex

Returns the columnExpressions belonging to this index.

getExprFromPhrase(int, Object[], DBColumn, boolean, DataType) - Method in class org.apache.empire.db.DBColumnExpr

Creates a new DBFuncExpr from a given SQL-PRHASE and optional additional parameters.

getExprFromPhrase(int, Object[], DBColumn, boolean) - Method in class org.apache.empire.db.DBColumnExpr

getFieldCount() - Method in class org.apache.empire.data.bean.BeanRecordProxy

getFieldCount() - Method in interface org.apache.empire.data.RecordData

returns the number of field available

getFieldCount() - Method in class org.apache.empire.db.DBReader

returns the number of the elements of the colList array

getFieldCount() - Method in class org.apache.empire.db.DBRecord

Returns the number of the columns.

getFieldCount() - Method in class org.apache.empire.db.DBRecordData

getFieldIndex(ColumnExpr) - Method in class org.apache.empire.data.bean.BeanRecordProxy

getFieldIndex(String) - Method in class org.apache.empire.data.bean.BeanRecordProxy

getFieldIndex(ColumnExpr) - Method in interface org.apache.empire.data.RecordData

returns the index of the given column expression Indexed operations provide better performance for bulk processing

getFieldIndex(String) - Method in interface org.apache.empire.data.RecordData

returns the index of the column expression with the given name

getFieldIndex(ColumnExpr) - Method in class org.apache.empire.db.DBReader

Returns the index value by a specified DBColumnExpr object.

getFieldIndex(String) - Method in class org.apache.empire.db.DBReader

Returns the index value by a specified column name.

getFieldIndex(ColumnExpr) - Method in class org.apache.empire.db.DBRecord

Returns the index value by a specified DBColumnExpr object.

getFieldIndex(String) - Method in class org.apache.empire.db.DBRecord

Returns the index value by a specified column name.

getFieldIndex(ColumnExpr) - Method in class org.apache.empire.db.DBRecordData

getFieldIndex(String) - Method in class org.apache.empire.db.DBRecordData

getFieldOptions(Column) - Method in class org.apache.empire.data.bean.BeanRecordProxy

getFieldOptions(Column) - Method in interface org.apache.empire.data.Record

returns the Options list for the given record field.

getFieldOptions(DBColumn) - Method in class org.apache.empire.db.DBRecord

Gets the possbile Options for a field in the context of the current record.

getFieldOptions(Column) - Method in class org.apache.empire.db.DBRecord

Gets the possbile Options for a field in the context of the current record.
Same as getFieldOptions(DBColumn)

getFields() - Method in class org.apache.empire.db.DBRecord

This function provides direct access to the record fields.
This method is used internally be the RowSet to fill the data.

getFirstChild(Node) - Static method in class org.apache.empire.xml.XMLUtil

Gets the first (direct) child Element.

getForeignKeyRelations() - Method in class org.apache.empire.db.DBTable

Returns a list of all foreign key relations for this table

getForeignKeyTable() - Method in class org.apache.empire.db.DBRelation

Returns the table that is containing the foreign key (source table)

getFullName() - Method in class org.apache.empire.db.DBColumn

Returns the full qualified column name.

getFullName() - Method in class org.apache.empire.db.DBIndex

Returns the full qualified table name.

getFullName() - Method in class org.apache.empire.db.DBRelation

Returns the full qualified table name.

getFullName() - Method in class org.apache.empire.db.DBRowSet

Returns the full qualified name of the rowset.

getFullName() - Method in class org.apache.empire.db.DBView

Returns the full qualified table name.

getFunctionName() - Method in class org.apache.empire.db.expr.column.DBAbstractFuncExpr

returns the name of the function

getFunctionName() - Method in class org.apache.empire.db.expr.column.DBConvertExpr

getFunctionName() - Method in class org.apache.empire.db.expr.column.DBDecodeExpr

getFunctionName() - Method in class org.apache.empire.db.expr.column.DBFuncExpr

getId() - Method in class org.apache.empire.db.DBColumn

Gets an identifier for this RowSet Object

getId() - Method in class org.apache.empire.db.DBDatabase

Returns the database instance id

getId() - Method in class org.apache.empire.db.DBRowSet

Gets an identifier for this RowSet Object

getIndex(Object) - Method in class org.apache.empire.commons.Options

getIndexes() - Method in class org.apache.empire.db.DBTable

Returns the list of indexes (except the primary key).

getInputStream() - Method in class org.apache.empire.db.DBBlobData

Returns the inputStream with the binary data for the BLOB.

getInsert() - Method in class org.apache.empire.db.DBCommand

Creates the insert SQL-Command.

getInsertInto(DBTable, DBColumnExpr[], List<DBColumnExpr>) - Method in class org.apache.empire.db.DBCommandExpr

Create the insert into SQL-Command which copies data from a select statement to a destination table.

getInsertInto(DBTable, List<DBColumnExpr>) - Method in class org.apache.empire.db.DBCommandExpr

Create the insert into SQL-Command which copies data from a select statement to a destination table.

getInsertInto(DBTable) - Method in class org.apache.empire.db.DBCommandExpr

Create the insert into SQL-Command which copies data from a select statement to a destination table.

getInstance() - Static method in class org.apache.empire.db.DBXmlDictionary

getInt(int) - Method in class org.apache.empire.db.DBRecordData

Returns a data value identified by the column index.

getInt(ColumnExpr) - Method in class org.apache.empire.db.DBRecordData

Returns a data value for the desired column.

getInteger(Object, int) - Static method in class org.apache.empire.commons.ObjectUtils

Converts an object value to an integer.

getInteger(Object) - Static method in class org.apache.empire.commons.ObjectUtils

Converts an object value to an integer.

getJoinConstraint() - Method in class org.apache.empire.db.expr.join.DBJoinExprEx

getJoins() - Method in class org.apache.empire.db.DBCommand

Returns a copy of the defined joins.

getKey() - Method in class org.apache.empire.commons.ErrorType

Returns the error type key (might be used for internationalization).

getKeyColumns() - Method in class org.apache.empire.data.bean.BeanClass

returns the list of key columns (if any)

getKeyColumns() - Method in class org.apache.empire.data.bean.BeanRecordProxy

getKeyColumns() - Method in interface org.apache.empire.data.Record

returns an array of key columns which uniquely identify the record.

getKeyColumns() - Method in class org.apache.empire.db.DBCommandExpr.DBCmdQuery

Prints the error message: ERR_NOTSUPPORTED.

getKeyColumns() - Method in class org.apache.empire.db.DBQuery

return query key columns

getKeyColumns() - Method in class org.apache.empire.db.DBRecord

returns an array of key columns which uniquely identify the record.

getKeyColumns() - Method in class org.apache.empire.db.DBRowSet

Returns an array of all primary key columns.

getKeyValues() - Method in class org.apache.empire.data.bean.BeanRecordProxy

Returns the array of primary key columns.

getKeyValues() - Method in class org.apache.empire.db.DBRecord

Returns the array of primary key columns.

getLeft() - Method in class org.apache.empire.db.expr.compare.DBCompareAndOrExpr

getLeft() - Method in class org.apache.empire.db.expr.join.DBJoinExpr

returns the left join expression

getLength() - Method in class org.apache.empire.db.DBBlobData

Returns the length of the BLOB data in bytes.

getLength() - Method in class org.apache.empire.db.DBClobData

Returns the length of the CLOB data in characters.

getLinkName() - Method in class org.apache.empire.db.DBDatabase

Returns the database link name.

getLong(Object, long) - Static method in class org.apache.empire.commons.ObjectUtils

Converts an object value to a long.

getLong(Object) - Static method in class org.apache.empire.commons.ObjectUtils

Converts an object value to a long.

getLong(int) - Method in class org.apache.empire.db.DBRecordData

Returns a data value identified by the column index.

getLong(ColumnExpr) - Method in class org.apache.empire.db.DBRecordData

Returns a data value for the desired column.

getMessagePattern() - Method in class org.apache.empire.commons.ErrorType

Returns the message pattern.

getName() - Method in class org.apache.empire.commons.Attributes.Attribute

getName() - Method in class org.apache.empire.data.bean.BeanClass

returns the name of this class

getName() - Method in class org.apache.empire.data.bean.BeanDomain

getName() - Method in class org.apache.empire.data.bean.BeanProperty

Returns the name of the property.

getName() - Method in interface org.apache.empire.data.ColumnExpr

Returns the physical column name.

getName() - Method in class org.apache.empire.db.DBColumn

Returns the column name.

getName() - Method in class org.apache.empire.db.DBColumnExpr

Returns the column name for this column expression.

getName() - Method in class org.apache.empire.db.DBCommandExpr.DBCmdQuery

Not applicable - returns null

getName() - Method in class org.apache.empire.db.DBIndex

Returns the primary key name.

getName() - Method in class org.apache.empire.db.DBQuery

not applicable - returns null

getName() - Method in class org.apache.empire.db.DBRelation

Returns the name.

getName() - Method in class org.apache.empire.db.DBRowSet

getName() - Method in class org.apache.empire.db.DBTable

Returns the table name of this object.

getName() - Method in class org.apache.empire.db.DBView

Returns the view name of this object.

getName() - Method in class org.apache.empire.db.expr.column.DBAbstractFuncExpr

Returns the column name.

getName() - Method in class org.apache.empire.db.expr.column.DBAliasExpr

This helper function returns the alias name.

getName() - Method in class org.apache.empire.db.expr.column.DBCalcExpr

Returns the given expression name.

getName() - Method in class org.apache.empire.db.expr.column.DBCaseExpr

getName() - Method in class org.apache.empire.db.expr.column.DBConcatExpr

getName() - Method in class org.apache.empire.db.expr.column.DBCountExpr

Returns the String "count".

getName() - Method in class org.apache.empire.db.expr.column.DBValueExpr

Returns the column name.

getName() - Method in class org.apache.empire.db.oracle.OracleRowNumExpr

Returns the column name.

getNamespace() - Method in class org.apache.empire.commons.Attributes.Attribute

getNamespaceURI(Document, String) - Static method in class org.apache.empire.xml.XMLUtil

getNativeErrorMessage() - Method in exception org.apache.empire.db.exceptions.EmpireSQLException

getNextSequenceValue(String, Connection) - Method in class org.apache.empire.db.DBDatabase

getNextSequenceValue(DBDatabase, String, int, Connection) - Method in class org.apache.empire.db.DBDatabaseDriver

Returns the next value of a named sequence The numbers are used for fields of type DBExpr.DT_AUTOINC.
If a driver supports this function it must return true for isSupported(DBDriverFeature.SEQUENCES).

getNextSequenceValue(DBDatabase, String, int, Connection) - Method in class org.apache.empire.db.derby.DBDatabaseDriverDerby

getNextSequenceValue(DBDatabase, String, int, Connection) - Method in class org.apache.empire.db.h2.DBDatabaseDriverH2

getNextSequenceValue(DBDatabase, String, int, Connection) - Method in class org.apache.empire.db.hsql.DBDatabaseDriverHSql

getNextSequenceValue(DBDatabase, String, int, Connection) - Method in class org.apache.empire.db.mysql.DBDatabaseDriverMySQL

getNextSequenceValue(DBDatabase, String, int, Connection) - Method in class org.apache.empire.db.oracle.DBDatabaseDriverOracle

getNextSequenceValue(DBDatabase, String, int, Connection) - Method in class org.apache.empire.db.postgresql.DBDatabaseDriverPostgreSQL

getNextSequenceValue(DBDatabase, String, int, Connection) - Method in class org.apache.empire.db.sqlite.DBDatabaseDriverSQLite

getNextSequenceValue(DBDatabase, String, int, Connection) - Method in class org.apache.empire.db.sqlserver.DBDatabaseDriverMSSQL

getNextSiblingElement(Element, boolean) - Static method in class org.apache.empire.xml.XMLUtil

Returns the next sibling Element for an element, optionally matching tag names.

getNextValue(String, long, Connection) - Method in class org.apache.empire.db.DBDatabaseDriver.DBSeqTable

getNullable() - Method in class org.apache.empire.db.oracle.OracleDataDictionnary.ColumnInfo

getNullType(DBCmpType) - Static method in enum org.apache.empire.db.DBCmpType

getNumParams() - Method in class org.apache.empire.commons.ErrorType

Returns the number of parameters required for the message pattern.

getObjectOwner() - Method in class org.apache.empire.db.sqlserver.DBDatabaseDriverMSSQL

getObjectValue(DataType, Object, long, String) - Method in class org.apache.empire.db.DBExpr

Returns the sql representation of a value.

getOnDeleteAction() - Method in class org.apache.empire.db.DBRelation

return the action to perform when deleting affected records.

getOptimizerHint() - Method in class org.apache.empire.db.oracle.DBCommandOracle

getOptions() - Method in class org.apache.empire.data.bean.BeanProperty

Returns the list of options for this column containing all allowed field values.

getOptions() - Method in interface org.apache.empire.data.ColumnExpr

Returns an option set with possible column values and their corresponding display text.

getOptions() - Method in class org.apache.empire.db.DBColumn

getOptions() - Method in class org.apache.empire.db.DBColumnExpr

Returns the list of options for this column containing all possible field values.

getOptions() - Method in class org.apache.empire.db.DBCommandExpr.DBCmdColumn

Get Options of underlying table column.

getOptions() - Method in class org.apache.empire.db.DBQuery.DBQueryColumn

getOptions() - Method in class org.apache.empire.db.DBView.DBViewColumn

getOuterTable() - Method in class org.apache.empire.db.expr.join.DBJoinExpr

Returns the left table name if the data type= JOIN_LEFT and returns the right table if the data type= JOIN_RIGHT.

getParamValues() - Method in class org.apache.empire.db.DBCombinedCmd

Returns the list of parameter values for a prepared statement.

getParamValues() - Method in class org.apache.empire.db.DBCommand

Returns an array of parameter values for a prepared statement.

getParamValues() - Method in class org.apache.empire.db.DBCommandExpr

returns an array holding all parameter values in the order of their occurrence.

getPrimaryKey() - Method in class org.apache.empire.db.DBTable

Returns the primary key.

getProperties() - Method in class org.apache.empire.data.bean.BeanClass

returns the list of properties for this class.

getQualifiedName(String) - Method in class org.apache.empire.db.DBDatabase

Deprecated.

getQueryColumns() - Method in class org.apache.empire.db.DBQuery

Gets all columns of this rowset (e.g.

getReader() - Method in class org.apache.empire.db.DBClobData

Set the defaultEncoding used in a constructor.

getRecordData(DBCommandExpr, Connection) - Method in class org.apache.empire.db.DBReader

Opens the reader by executing the given SQL command and moves to the first row.
If true is returned data of the row can be accessed through the functions on the RecordData interface.
This function is intended for single row queries and provided for convenience.
However it behaves exacly as calling reader.open() and reader.moveNext()

getRecordDefaultValue(Connection) - Method in class org.apache.empire.db.DBTableColumn

Returns the default column value.

getRecordKey(DBRecord) - Method in class org.apache.empire.db.DBCommandExpr.DBCmdQuery

Prints the error message: ERR_NOTSUPPORTED.

getRecordKey(DBRecord) - Method in class org.apache.empire.db.DBQuery

Returns a array of primary key columns by a specified DBRecord object.

getRecordKey(DBRecord) - Method in class org.apache.empire.db.DBRowSet

Returns a array of primary key columns by a specified DBRecord object.

getReferencedTable() - Method in class org.apache.empire.db.DBRelation

Returns the table that is referenced by this foreign key relation (target table)

getReferences() - Method in class org.apache.empire.db.DBRelation

Returns the references.

getRelation(String) - Method in class org.apache.empire.db.DBDatabase

Returns the relation of a given name

getRelations() - Method in class org.apache.empire.db.DBDatabase

Returns the relations which have been defined in the database.

getRenameTablePhrase() - Method in class org.apache.empire.db.DBRowSet

Returns the sql phrase for renaming tables.

getResultValue(ResultSet, int, DataType) - Method in class org.apache.empire.db.DBDatabaseDriver

Reads a single column value from the given JDBC ResultSet and returns a value object of desired data type.
See DBExpr.getValueClass(DataType) for java class type mapping.

getResultValue(ResultSet, int, DataType) - Method in class org.apache.empire.db.oracle.DBDatabaseDriverOracle

Gets the value of a sql ResultSet.

getResultValue(ResultSet, int, DataType) - Method in class org.apache.empire.db.postgresql.DBDatabaseDriverPostgreSQL

Postgre needs special handling for CLOBs and BLOB's

getResultValue(ResultSet, int, DataType) - Method in class org.apache.empire.db.sqlite.DBDatabaseDriverSQLite

getRight() - Method in class org.apache.empire.db.expr.compare.DBCompareAndOrExpr

getRight() - Method in class org.apache.empire.db.expr.join.DBJoinExpr

returns the right join expression

getRootNode() - Method in class org.apache.empire.xml.XMLConfiguration

returns the configuration root element or null if init() has not been called.

getRowElementName() - Method in class org.apache.empire.db.DBXmlDictionary

getRowIdColumnAttribute() - Method in class org.apache.empire.db.DBXmlDictionary

getRowSet() - Method in class org.apache.empire.db.DBColumn

Returns DBTable, DBQuery or DBView object.

getRowSet(String) - Method in class org.apache.empire.db.DBDatabase

Finds a DBRowSet object (DBTable or DBView) by name.

getRowSet() - Method in class org.apache.empire.db.DBRecord

Returns the DBRowSet object.

getRowSetData() - Method in class org.apache.empire.db.DBRecord

Returns the DBRowSet object.

getRowSetElementName() - Method in class org.apache.empire.db.DBXmlDictionary

getSchema() - Method in class org.apache.empire.db.DBDatabase

Returns the schema for SQL statements.

getSchemaPrefix() - Method in class org.apache.empire.db.DBDatabase

Returns the schema-prefix for SQL statements e.g.

getScrollable() - Method in class org.apache.empire.db.DBReader

getSelect(StringBuilder) - Method in class org.apache.empire.db.DBCombinedCmd

Creates the SQL-Command.

getSelect(StringBuilder) - Method in class org.apache.empire.db.DBCommand

getSelect(StringBuilder) - Method in class org.apache.empire.db.DBCommandExpr

getSelect() - Method in class org.apache.empire.db.DBCommandExpr

returns an SQL select command for querying records.

getSelect(StringBuilder) - Method in class org.apache.empire.db.mysql.DBDatabaseDriverMySQL.DBCommandMySQL

getSelect(StringBuilder) - Method in class org.apache.empire.db.oracle.DBCommandOracle

Creates an Oracle specific select statement that supports special features of the Oracle DBMS like e.g.

getSelect(StringBuilder) - Method in class org.apache.empire.db.postgresql.DBDatabaseDriverPostgreSQL.DBCommandPostreSQL

getSelectExprList() - Method in class org.apache.empire.db.DBCombinedCmd

Calls the method dbDBCommandExpr.getSelectExprList from the private variable 'left'.

getSelectExprList() - Method in class org.apache.empire.db.DBCommand

Returns a array of all select DBColumnExpr for this command

getSelectExprList() - Method in class org.apache.empire.db.DBCommandExpr

getSequenceName() - Method in class org.apache.empire.db.DBTableColumn

Gets the sequence name for this table's sequence (if it has one) This is derived form the default value or auto generated if no default value is set

getSequenceTableName() - Method in class org.apache.empire.db.derby.DBDatabaseDriverDerby

returns the name of the sequence table

getSequenceTableName() - Method in class org.apache.empire.db.h2.DBDatabaseDriverH2

returns the name of the sequence table

getSequenceTableName() - Method in class org.apache.empire.db.mysql.DBDatabaseDriverMySQL

returns the name of the sequence table

getSequenceTableName() - Method in class org.apache.empire.db.sqlserver.DBDatabaseDriverMSSQL

returns the name of the sequence table

getSimpleUpdate() - Method in class org.apache.empire.db.oracle.DBCommandOracle

getSize() - Method in class org.apache.empire.data.bean.BeanProperty

getSize() - Method in interface org.apache.empire.data.Column

Returns the maximum size a value for this column is allowed to have.

getSize() - Method in class org.apache.empire.db.DBColumn

Returns the size of the column.

getSize() - Method in class org.apache.empire.db.DBCommandExpr.DBCmdColumn

Not applicable - always returns 0.

getSize() - Method in class org.apache.empire.db.DBQuery.DBQueryColumn

getSize() - Method in class org.apache.empire.db.DBTableColumn

Gets the the column width.

getSize() - Method in class org.apache.empire.db.DBView.DBViewColumn

getSourceColumn() - Method in class org.apache.empire.data.bean.BeanProperty

Returns the column This function should return the same string as getName()

getSourceColumn() - Method in interface org.apache.empire.data.ColumnExpr

Returns the underlying source column (if any).

getSourceColumn() - Method in class org.apache.empire.db.DBColumnExpr

Returns the source column.

getSourceColumn() - Method in class org.apache.empire.db.DBRelation.DBReference

getSourceColumnExpr() - Method in class org.apache.empire.db.DBView.DBViewColumn

getSQLDateTimeString(Object, int, int, int) - Method in class org.apache.empire.db.DBDatabaseDriver

encodes a Date value for an SQL command string.

getSQLNumberString(Object, DataType) - Method in class org.apache.empire.db.DBDatabaseDriver

encodes a numeric value for an SQL command string.

getSQLPhrase(int) - Method in class org.apache.empire.db.DBDatabaseDriver

Returns an sql phrase template for this database system.
Templates for sql function expressions must contain a '?' character which will be replaced by the current column expression.
If other parameters are necessary the template must contain placeholders like {0}, {1} etc.

getSQLPhrase(int) - Method in class org.apache.empire.db.derby.DBDatabaseDriverDerby

Gets an sql phrase template for this database system.

getSQLPhrase(int) - Method in class org.apache.empire.db.h2.DBDatabaseDriverH2

Gets an sql phrase template for this database system.

getSQLPhrase(int) - Method in class org.apache.empire.db.hsql.DBDatabaseDriverHSql

Gets an sql phrase template for this database system.

getSQLPhrase(int) - Method in class org.apache.empire.db.mysql.DBDatabaseDriverMySQL

Gets an sql phrase template for this database system.

getSQLPhrase(int) - Method in class org.apache.empire.db.oracle.DBDatabaseDriverOracle

Gets an sql phrase template for this database system.

getSQLPhrase(int) - Method in class org.apache.empire.db.postgresql.DBDatabaseDriverPostgreSQL

Gets an sql phrase template for this database system.

getSQLPhrase(int) - Method in class org.apache.empire.db.sqlite.DBDatabaseDriverSQLite

Gets an sql phrase template for this database system.

getSQLPhrase(int) - Method in class org.apache.empire.db.sqlserver.DBDatabaseDriverMSSQL

Gets an sql phrase template for this database system.

getSQLTextString(DataType, Object) - Method in class org.apache.empire.db.DBDatabaseDriver

encodes Text values for an SQL command string.

getSQLTextString(DataType, Object) - Method in class org.apache.empire.db.sqlserver.DBDatabaseDriverMSSQL

getState() - Method in class org.apache.empire.db.DBRecord

Returns the record state.

getStmt(int) - Method in class org.apache.empire.db.DBSQLScript

Returns the statement at the given index

getString(int) - Method in class org.apache.empire.db.DBRecordData

Returns a data value identified by the column index.

getString(ColumnExpr) - Method in class org.apache.empire.db.DBRecordData

Returns a data value for the desired column.

getSystemDateExpr() - Method in class org.apache.empire.db.DBDatabase

Creates and returns a value object for the database systems current date and time.

getTable(String) - Method in class org.apache.empire.db.DBDatabase

Finds a DBTable object by name.

getTable() - Method in class org.apache.empire.db.DBIndex

returns the table this index belongs to.

getTable() - Method in class org.apache.empire.db.expr.set.DBSetExpr

Returns the current Table object.

getTableList() - Method in class org.apache.empire.db.DBCommand

Gets a list of all tables referenced by the query.

getTables() - Method in class org.apache.empire.db.DBDatabase

Returns the tables which have been defined in the database.

getTargetColumn() - Method in class org.apache.empire.db.DBRelation.DBReference

getText() - Method in class org.apache.empire.commons.OptionEntry

getTextAt(int) - Method in class org.apache.empire.commons.Options

Gets the text of the entry at index i

getTimeNow() - Static method in class org.apache.empire.commons.DateUtils

Returns the current date and time

getTimestampColumn() - Method in class org.apache.empire.db.DBRowSet

getTitle() - Method in class org.apache.empire.data.bean.BeanProperty

Returns the title attribute.

getTitle() - Method in interface org.apache.empire.data.ColumnExpr

Returns the column's display title.

getTitle() - Method in class org.apache.empire.db.DBColumnExpr

Returns the title attribute.

getType() - Method in class org.apache.empire.db.DBIndex

Returns the index type.

getType() - Method in class org.apache.empire.db.expr.join.DBJoinExpr

returns the join type for this join

getUpdate() - Method in class org.apache.empire.db.DBCommand

Creates the update SQL-Command.

getUpdate() - Method in class org.apache.empire.db.oracle.DBCommandOracle

Creates an Oracle specific update statement.

getUpdateColumn() - Method in class org.apache.empire.db.DBColumn

Returns this object.

getUpdateColumn() - Method in class org.apache.empire.db.DBColumnExpr

Returns the underlying physical column which may be used for updates.

getUpdateColumn() - Method in class org.apache.empire.db.expr.column.DBAbstractFuncExpr

Returns the DBColunm object.

getUpdateColumn() - Method in class org.apache.empire.db.expr.column.DBAliasExpr

Returns the DBColunm object.

getUpdateColumn() - Method in class org.apache.empire.db.expr.column.DBCalcExpr

returns null

getUpdateColumn() - Method in class org.apache.empire.db.expr.column.DBCaseExpr

getUpdateColumn() - Method in class org.apache.empire.db.expr.column.DBConcatExpr

getUpdateColumn() - Method in class org.apache.empire.db.expr.column.DBCountExpr

Returns null.

getUpdateColumn() - Method in class org.apache.empire.db.expr.column.DBValueExpr

Returns null.

getUpdateColumn() - Method in class org.apache.empire.db.oracle.OracleRowNumExpr

Returns null.

getUpdateTimestamp(Connection) - Method in class org.apache.empire.db.DBDatabase

Returns a timestamp that is used for record updates.

getUpdateTimestamp(Connection) - Method in class org.apache.empire.db.DBDatabaseDriver

Returns a timestamp that is used for record updates.

getUpdateTimestamp(Connection) - Method in class org.apache.empire.db.derby.DBDatabaseDriverDerby

Overridden.

getUpdateTimestamp(Connection) - Method in class org.apache.empire.db.h2.DBDatabaseDriverH2

Overridden.

getUpdateTimestamp(Connection) - Method in class org.apache.empire.db.hsql.DBDatabaseDriverHSql

Overridden.

getUpdateTimestamp(Connection) - Method in class org.apache.empire.db.mysql.DBDatabaseDriverMySQL

Overridden.

getUpdateTimestamp(Connection) - Method in class org.apache.empire.db.oracle.DBDatabaseDriverOracle

Overridden.

getUpdateTimestamp(Connection) - Method in class org.apache.empire.db.postgresql.DBDatabaseDriverPostgreSQL

Overridden.

getUpdateTimestamp(Connection) - Method in class org.apache.empire.db.sqlite.DBDatabaseDriverSQLite

Overridden.

getUpdateTimestamp(Connection) - Method in class org.apache.empire.db.sqlserver.DBDatabaseDriverMSSQL

Overridden.

getUpdateWithJoins() - Method in class org.apache.empire.db.oracle.DBCommandOracle

getValue() - Method in class org.apache.empire.commons.Attributes.Attribute

getValue() - Method in class org.apache.empire.commons.OptionEntry

getValue(ColumnExpr) - Method in class org.apache.empire.data.bean.BeanRecordProxy

getValue(int) - Method in class org.apache.empire.data.bean.BeanRecordProxy

getValue(int) - Method in interface org.apache.empire.data.RecordData

returns the value of the field at the given index position Indexed operations provide better performance for bulk processing compared to getValue(ColumnExpr)

getValue(ColumnExpr) - Method in interface org.apache.empire.data.RecordData

returns the record value for a particular column

getValue() - Method in class org.apache.empire.db.DBCmdParam

Returns the current value of the parameter.

getValue(int) - Method in class org.apache.empire.db.DBReader

Returns a data value identified by the column index.

getValue(int) - Method in class org.apache.empire.db.DBRecord

Returns the value for the given column or null if either the index is out of range or the value is not valid (see DBRecord.isValueValid(int))

getValue(int) - Method in class org.apache.empire.db.DBRecordData

Returns a value based on an index.

getValue(ColumnExpr) - Method in class org.apache.empire.db.DBRecordData

Returns a data value for the desired column .

getValue() - Method in class org.apache.empire.db.expr.compare.DBCompareColExpr

Gets the value to compare the column expression with

getValue() - Method in class org.apache.empire.db.expr.set.DBSetExpr

getValueAt(int) - Method in class org.apache.empire.commons.Options

Gets the value of the entry at index i

getValueClass(DataType) - Static method in class org.apache.empire.db.DBExpr

Returns the java class type for a given dataType

getValueExpr(String) - Method in class org.apache.empire.db.DBDatabase

Creates and returns a value object for the given string value.

getValueExpr(boolean) - Method in class org.apache.empire.db.DBDatabase

Creates and returns a value object for the given boolean value.

getValueExpr(int) - Method in class org.apache.empire.db.DBDatabase

Creates and returns a value object for the given integer value.

getValueExpr(long) - Method in class org.apache.empire.db.DBDatabase

Creates and returns a value object for the given long value.

getValueExpr(Object, DataType) - Method in class org.apache.empire.db.DBDatabase

Creates and returns a value object for the given value.

getValues() - Method in class org.apache.empire.commons.Options

getValueString() - Method in class org.apache.empire.commons.OptionEntry

Gets the value as string

getValueString(Object, DataType) - Method in class org.apache.empire.db.DBDatabaseDriver

Creates a sql string for a given value.

getView(String) - Method in class org.apache.empire.db.DBDatabase

Finds a DBView object by name.

getView() - Method in class org.apache.empire.db.DBView.DBViewColumn

getViews() - Method in class org.apache.empire.db.DBDatabase

Returns the views which have been defined in the database.

getWeekOfYear(Date, Locale) - Static method in class org.apache.empire.commons.DateUtils

getWhere() - Method in class org.apache.empire.db.expr.join.DBJoinExpr

Returns any additional constraints to the join

getWhereConstraints() - Method in class org.apache.empire.db.DBCommand

Returns a copy of the defined where clauses.

getXmlDictionary() - Method in class org.apache.empire.db.DBReader

returns the DBXmlDictionary that should used to generate XMLDocuments

getXmlDictionary() - Method in class org.apache.empire.db.DBRecord

returns the DBXmlDictionary that should used to generate XMLDocuments

getXmlDocument() - Method in class org.apache.empire.db.DBReader

Returns a XML document with the field description an values of this record.

getXmlDocument() - Method in class org.apache.empire.db.DBRecord

Returns a XML document with the field description an values of this record.

getXmlDocument() - Method in class org.apache.empire.db.DBRecordData

groupBy - Variable in class org.apache.empire.db.DBCommand

groupBy(DBColumnExpr...) - Method in class org.apache.empire.db.DBCommand

Adds a list of columns to the group by phrase of an sql statement.

H

H2DDLGenerator - Class in org.apache.empire.db.h2

H2DDLGenerator(DBDatabaseDriverH2) - Constructor for class org.apache.empire.db.h2.H2DDLGenerator

hasJoinOn(DBRowSet) - Method in class org.apache.empire.db.DBCommand

Returns true if the command has a join on the given table or false otherwise.

hasJoinOn(DBColumn) - Method in class org.apache.empire.db.DBCommand

Returns true if the command has a join on the given column or false otherwise.

hasNext() - Method in class org.apache.empire.db.DBReader.DBReaderForwardIterator

Implements the Iterator Interface.

hasNext() - Method in class org.apache.empire.db.DBReader.DBReaderScrollableIterator

Implements the Iterator Interface.

hasSelectExpr() - Method in class org.apache.empire.db.DBCommand

hasSetExprOn(DBColumn) - Method in class org.apache.empire.db.DBCommand

Checks whether a column is in the list of set expressions

hasWhereConstraints() - Method in class org.apache.empire.db.DBCommand

Returns true if the command has constraints or false if not.

having - Variable in class org.apache.empire.db.DBCommand

having(DBCompareExpr) - Method in class org.apache.empire.db.DBCommand

adds a constraint to the having clause.

HSqlDDLGenerator - Class in org.apache.empire.db.hsql

HSqlDDLGenerator(DBDatabaseDriverHSql) - Constructor for class org.apache.empire.db.hsql.HSqlDDLGenerator

I

ILLEGAL_NAME_CHARS - Static variable in class org.apache.empire.db.DBDatabaseDriver

in(Object) - Method in class org.apache.empire.db.DBColumnExpr

Creates and returns a new comparison object for the SQL "in" operator.

indexOf(String) - Method in class org.apache.empire.commons.Attributes

indexOf(Object) - Method in class org.apache.empire.db.DBColumnExpr

Creates and returns a sql-expression that returns the position of a string in the current column expression.

indexOf(Object, DBExpr) - Method in class org.apache.empire.db.DBColumnExpr

Creates and returns a sql-expression that returns the position of a string in the current column expression.

indexOf(Object, int) - Method in class org.apache.empire.db.DBColumnExpr

Overloaded.

init(DBRowSet, Object[], boolean) - Method in class org.apache.empire.db.DBRecord

Initializes this record object by attaching it to a rowset, setting its primary key values and setting the record state.
This function is useful for updating a record without prior reading.

init(String, boolean) - Method in class org.apache.empire.xml.XMLConfiguration

Initialize the configuration.

initData(DBRowSet, Object, boolean) - Method in class org.apache.empire.db.DBRecord

This method is used internally by the RowSet to initialize the record's properties

initRecord(DBRecord, Object[], boolean) - Method in class org.apache.empire.db.DBCommandExpr.DBCmdQuery

Returns the error message: ERR_NOTSUPPORTED

initRecord(DBRecord, Object[], boolean) - Method in class org.apache.empire.db.DBQuery

Initialize specified DBRecord object with primary key columns (the Object[] keyValues).

initRecord(DBRowSet, DBRecord) - Method in class org.apache.empire.db.DBReader

initializes a DBRecord object with the values of the current row.

initRecord(DBRecord, Object[], boolean) - Method in class org.apache.empire.db.DBRowSet

Initializes a DBRecord for this RowSet and sets primary key values (the Object[] keyValues).

initRecord(DBRecord, DBRecordData) - Method in class org.apache.empire.db.DBRowSet

Initializes a DBRecord for this rowset using the record data provided (i.e.

insertElement(Node, String, String, Element) - Static method in class org.apache.empire.xml.XMLUtil

Inserts a new child element to a parent.

insertElement(Node, String, Element) - Static method in class org.apache.empire.xml.XMLUtil

insertElementNS(Node, String, String, String, Element) - Static method in class org.apache.empire.xml.XMLUtil

Inserts a new child element to a parent.

insertElementNS(Node, String, String, Element) - Static method in class org.apache.empire.xml.XMLUtil

instanceId - Variable in class org.apache.empire.db.DBDatabase

InternalException - Exception in org.apache.empire.exceptions

InternalException(Throwable) - Constructor for exception org.apache.empire.exceptions.InternalException

InternalException(EmpireException) - Constructor for exception org.apache.empire.exceptions.InternalException

intersect(DBCommandExpr) - Method in class org.apache.empire.db.DBCommandExpr

Constructs a new DBCombinedCmd object with this object, the key word= "INTERSECT" and the selected DBCommandExpr.

InvalidArgumentException - Exception in org.apache.empire.exceptions

InvalidArgumentException(String, Object) - Constructor for exception org.apache.empire.exceptions.InvalidArgumentException

InvalidArgumentException(String, Object[]) - Constructor for exception org.apache.empire.exceptions.InvalidArgumentException

InvalidKeyException - Exception in org.apache.empire.db.exceptions

InvalidKeyException(DBRowSet, Object[]) - Constructor for exception org.apache.empire.db.exceptions.InvalidKeyException

InvalidPropertyException - Exception in org.apache.empire.exceptions

InvalidPropertyException(String, Object) - Constructor for exception org.apache.empire.exceptions.InvalidPropertyException

is(Object) - Method in class org.apache.empire.db.DBColumnExpr

Creates and returns a new comparison object for the SQL "=" (equal) operator.

isAggregate() - Method in class org.apache.empire.db.DBColumn

Always returns false since DBColumns cannot be aggregates.

isAggregate() - Method in class org.apache.empire.db.DBColumnExpr

Indicates wheter this function is an aggregate (sum, min, max, avg, ...) or not

isAggregate - Variable in class org.apache.empire.db.expr.column.DBAbstractFuncExpr

isAggregate() - Method in class org.apache.empire.db.expr.column.DBAbstractFuncExpr

Returns whether the function is an aggegation function
that combines multiple rows to one result row.

isAggregate() - Method in class org.apache.empire.db.expr.column.DBAliasExpr

Always returns false since an alias expression cannot be an aggregate.

isAggregate() - Method in class org.apache.empire.db.expr.column.DBCalcExpr

Always returns false since CalcExpressions cannot be aggregates.

isAggregate() - Method in class org.apache.empire.db.expr.column.DBCaseExpr

isAggregate() - Method in class org.apache.empire.db.expr.column.DBConcatExpr

Always returns false since a concat expression cannot be an aggregate.

isAggregate() - Method in class org.apache.empire.db.expr.column.DBCountExpr

Returns true since the count function is an aggregate function.

isAggregate() - Method in class org.apache.empire.db.expr.column.DBValueExpr

Always returns false since value expressions cannot be an aggregate.

isAggregate() - Method in class org.apache.empire.db.oracle.OracleRowNumExpr

Always returns false

isAssignmentCompatible(Class<?>, Class<?>) - Static method in class org.apache.empire.commons.ObjectUtils

isAutoGenerated() - Method in class org.apache.empire.data.bean.BeanProperty

isAutoGenerated() - Method in interface org.apache.empire.data.Column

Returns whether or not the value for this column is auto-generated

isAutoGenerated() - Method in class org.apache.empire.db.DBColumn

Returns true if column is a columns value is an automatically generated value

isAutoGenerated() - Method in class org.apache.empire.db.DBCommandExpr.DBCmdColumn

Not applicable - always returns false

isAutoGenerated() - Method in class org.apache.empire.db.DBQuery.DBQueryColumn

isAutoGenerated() - Method in class org.apache.empire.db.DBTableColumn

Returns true if column is a numeric sequence or otherwise generated value

isAutoGenerated() - Method in class org.apache.empire.db.DBView.DBViewColumn

isBetween(Object, Object) - Method in class org.apache.empire.db.DBColumnExpr

Creates and returns a new comparison object for the SQL "between" operator.

isBoolean() - Method in enum org.apache.empire.data.DataType

Returns true if the data type is a boolean type

isCascadeDelete() - Method in class org.apache.empire.db.DBTable

Deprecated. Deprecated flag that indicates whether cascaded deletes are enabled on this table. This property will be removed in future releases. Use DBRelation.getOnDeleteAction() instead.

isColumnReadOnly(DBColumn) - Method in class org.apache.empire.db.DBRowSet

Checks whether a column is read only or writable.

isDate() - Method in enum org.apache.empire.data.DataType

Returns true if the data type is a date based data type (date or datetime)

isDDLColumnDefaults() - Method in class org.apache.empire.db.DBDatabaseDriver

isDescending() - Method in class org.apache.empire.db.expr.order.DBOrderByExpr

isEmpty(Object) - Static method in class org.apache.empire.commons.ObjectUtils

Checks whether an object has no value.

isEmpty() - Method in class org.apache.empire.commons.Options

isEmpty(String) - Static method in class org.apache.empire.commons.StringUtils

Checks if a string is empty

isFieldReadOnly(Column) - Method in class org.apache.empire.data.bean.BeanRecordProxy

isFieldReadOnly(Column) - Method in interface org.apache.empire.data.Record

returns true if the field is read-only.

isFieldReadOnly(Column) - Method in class org.apache.empire.db.DBRecord

returns whether a field is read only or not

isFieldRequired(Column) - Method in class org.apache.empire.data.bean.BeanRecordProxy

isFieldRequired(Column) - Method in interface org.apache.empire.data.Record

returns true if the field is required.

isFieldRequired(Column) - Method in class org.apache.empire.db.DBRecord

returns whether a field is required or not

isFieldVisible(Column) - Method in class org.apache.empire.data.bean.BeanRecordProxy

isFieldVisible(Column) - Method in interface org.apache.empire.data.Record

returns true if the field is visible to the client.

isFieldVisible(Column) - Method in class org.apache.empire.db.DBRecord

returns whether a field is visible to the client or not

isGreaterThan(Object) - Method in class org.apache.empire.db.DBColumnExpr

Creates and returns a new comparison object for the SQL ">" (greater than) operator.

isJoinOn(DBRowSet) - Method in class org.apache.empire.db.expr.join.DBJoinExpr

returns true if this join is using the given table or view or false otherwise

isJoinOn(DBColumn) - Method in class org.apache.empire.db.expr.join.DBJoinExpr

returns true if this join is using the given column or false otherwise

isKeyColumn(DBColumn) - Method in class org.apache.empire.db.DBRowSet

Checks whether a given column is part of the primary key for this RowSet

isLessOrEqual(Object) - Method in class org.apache.empire.db.DBColumnExpr

Creates and returns a new comparison object for the SQL "<=" (less or equal) operator.

isModified() - Method in class org.apache.empire.data.bean.BeanRecordProxy

isModified() - Method in interface org.apache.empire.data.Record

returns true if the record has been modified.

isModified() - Method in class org.apache.empire.db.DBRecord

Returns true if the record is modified.

isMoreOrEqual(Object) - Method in class org.apache.empire.db.DBColumnExpr

Creates and returns a new comparison object for the SQL ">=" (greater or equal) operator.

isMutuallyExclusive(DBCompareExpr) - Method in class org.apache.empire.db.expr.compare.DBCompareAndOrExpr

Returns wheter the constraint should replace another one or not.

isMutuallyExclusive(DBCompareExpr) - Method in class org.apache.empire.db.expr.compare.DBCompareColExpr

Returns whether the constraint should replace another one or not.

isMutuallyExclusive(DBCompareExpr) - Method in class org.apache.empire.db.expr.compare.DBCompareExpr

isMutuallyExclusive(DBCompareExpr) - Method in class org.apache.empire.db.expr.compare.DBCompareNotExpr

Returns wheter the constraint should replace another one or not.

isMutuallyExclusive(DBCompareExpr) - Method in class org.apache.empire.db.expr.compare.DBExistsExpr

Returns wheter the constraint should replace another one or not.

isMutuallyExclusive(DBCompareExpr) - Method in class org.apache.empire.db.expr.compare.DBParenthesisExpr

isNew() - Method in class org.apache.empire.data.bean.BeanRecordProxy

isNew() - Method in interface org.apache.empire.data.Record

returns true if this record is a new record.

isNew() - Method in class org.apache.empire.db.DBRecord

Returns true if this record is a new record.

isNot(Object) - Method in class org.apache.empire.db.DBColumnExpr

Creates and returns a new comparison object for the SQL "<>" (not equal) operator.

isNotBetween(Object, Object) - Method in class org.apache.empire.db.DBColumnExpr

Creates and returns a new comparison object for the SQL "not between" operator.

isNotEmpty(String) - Static method in class org.apache.empire.commons.StringUtils

Checks if a string is not null or empty

isNull(ColumnExpr) - Method in class org.apache.empire.data.bean.BeanRecordProxy

isNull(int) - Method in class org.apache.empire.data.bean.BeanRecordProxy

isNull(int) - Method in interface org.apache.empire.data.RecordData

checks if the field at the given index position contains no value (null) Indexed operations provide better performance for bulk processing compared to isNull(ColumnExpr)

isNull(ColumnExpr) - Method in interface org.apache.empire.data.RecordData

checks if the record contains no value (null) for the given column

isNull(int) - Method in class org.apache.empire.db.DBReader

Checks wehter a column value is null Unlike the base class implementation, this class directly check the value fromt the resultset.

isNull(int) - Method in class org.apache.empire.db.DBRecordData

Checks whether or not the value for the given column is null.

isNull(ColumnExpr) - Method in class org.apache.empire.db.DBRecordData

Checks whether or not the value for the given column is null.

isNumeric() - Method in enum org.apache.empire.data.DataType

Returns true if the data type is a numeric data type (integer, decimal, float)

isOpen() - Method in class org.apache.empire.db.DBDatabase

Indicates whether the database has been opened.

isOpen() - Method in class org.apache.empire.db.DBReader

Checks if the rowset is open

isOr() - Method in class org.apache.empire.db.expr.compare.DBCompareAndOrExpr

isOracle8Compatibilty() - Method in class org.apache.empire.db.oracle.DBDatabaseDriverOracle

isPreparedStatementsEnabled() - Method in class org.apache.empire.db.DBDatabase

return whether prepared statements are preferred over normal statements (Default is false) Note: This will only apply for update and insert commands as well as for read operations on a DBRecord.

isReadOnly() - Method in class org.apache.empire.data.bean.BeanProperty

isReadOnly() - Method in class org.apache.empire.data.bean.BeanRecordProxy

isReadOnly() - Method in interface org.apache.empire.data.Column

Returns true if the values for this column are generally read only (like i.e.

isReadOnly() - Method in interface org.apache.empire.data.Record

returns true if this record is readOnly.

isReadOnly() - Method in class org.apache.empire.db.DBColumn

Returns true if the column is read-only.

isReadOnly() - Method in class org.apache.empire.db.DBCommandExpr.DBCmdColumn

Not applicable - always returns true

isReadOnly() - Method in class org.apache.empire.db.DBQuery.DBQueryColumn

isReadOnly() - Method in class org.apache.empire.db.DBRecord

Returns true if the record is valid.

isReadOnly() - Method in class org.apache.empire.db.DBTableColumn

Checks whether the column is read only.

isReadOnly() - Method in class org.apache.empire.db.DBView.DBViewColumn

isRequired() - Method in class org.apache.empire.data.bean.BeanProperty

isRequired() - Method in interface org.apache.empire.data.Column

Returns whether or not the value for this column must be supplied (i.e.

isRequired() - Method in class org.apache.empire.db.DBColumn

Returns true if the column is required.

isRequired() - Method in class org.apache.empire.db.DBCommandExpr.DBCmdColumn

Checks whether the column is mandatory.

isRequired() - Method in class org.apache.empire.db.DBQuery.DBQueryColumn

isRequired() - Method in class org.apache.empire.db.DBTableColumn

Returns true if column is mandatory.

isRequired() - Method in class org.apache.empire.db.DBView.DBViewColumn

isSelectDistinct() - Method in class org.apache.empire.db.DBCommand

Returns whether or not the select statement will be distinct or not.

isSingleByteChars() - Method in class org.apache.empire.db.DBTableColumn

Returns true if column the column is a single byte text or character column or false otherwise

isSmallerThan(Object) - Method in class org.apache.empire.db.DBColumnExpr

Creates and returns a new comparison object for the SQL "<" (less than) operator.

isSupported(DBDriverFeature) - Method in class org.apache.empire.db.DBDatabaseDriver

Returns whether or not a particular feature is supported by this driver

isSupported(DBDriverFeature) - Method in class org.apache.empire.db.derby.DBDatabaseDriverDerby

Returns whether or not a particular feature is supported by this driver

isSupported(DBDriverFeature) - Method in class org.apache.empire.db.h2.DBDatabaseDriverH2

Returns whether or not a particular feature is supported by this driver

isSupported(DBDriverFeature) - Method in class org.apache.empire.db.hsql.DBDatabaseDriverHSql

Returns whether or not a particular feature is supported by this driver

isSupported(DBDriverFeature) - Method in class org.apache.empire.db.mysql.DBDatabaseDriverMySQL

Returns whether or not a particular feature is supported by this driver

isSupported(DBDriverFeature) - Method in class org.apache.empire.db.oracle.DBDatabaseDriverOracle

Returns whether or not a particular feature is supported by this driver

isSupported(DBDriverFeature) - Method in class org.apache.empire.db.postgresql.DBDatabaseDriverPostgreSQL

Returns whether or not a particular feature is supported by this driver

isSupported(DBDriverFeature) - Method in class org.apache.empire.db.sqlite.DBDatabaseDriverSQLite

Returns whether or not a particular feature is supported by this driver

isSupported(DBDriverFeature) - Method in class org.apache.empire.db.sqlserver.DBDatabaseDriverMSSQL

Returns whether or not a particular feature is supported by this driver

isText() - Method in enum org.apache.empire.data.DataType

Returns true if the data type is a text based data type (char, text or clob)

isUpdateable() - Method in class org.apache.empire.db.DBCommandExpr.DBCmdQuery

Not applicable - returns false

isUpdateable() - Method in class org.apache.empire.db.DBQuery

Returns whether or not the table supports record updates.

isUpdateable() - Method in class org.apache.empire.db.DBRowSet

isUpdateable() - Method in class org.apache.empire.db.DBTable

Returns whether or not the table supports record updates.

isUpdateable() - Method in class org.apache.empire.db.DBView

Returns whether or not the view is updateable

isUseSequenceTable() - Method in class org.apache.empire.db.derby.DBDatabaseDriverDerby

returns whether a sequence table is used for record identiy management.
Default is false.

isUseSequenceTable() - Method in class org.apache.empire.db.h2.DBDatabaseDriverH2

returns whether a sequence table is used for record identiy management.
Default is false.

isUseSequenceTable() - Method in class org.apache.empire.db.mysql.DBDatabaseDriverMySQL

returns whether a sequence table is used for record identity management.
Default is false.

isUseSequenceTable() - Method in class org.apache.empire.db.sqlserver.DBDatabaseDriverMSSQL

returns whether a sequence table is used for record identiy management.
Default is false.

isUseUnicodePrefix() - Method in class org.apache.empire.db.sqlserver.DBDatabaseDriverMSSQL

Indicates whether or not a Unicode Prefix (N) is prepended to all text values

isValid(String) - Static method in class org.apache.empire.commons.StringUtils

Deprecated. this has been renamed to isNotEmpty

isValid() - Method in class org.apache.empire.data.bean.BeanRecordProxy

isValid() - Method in interface org.apache.empire.data.Record

returns true if the record is valid.

isValid() - Method in class org.apache.empire.db.DBCombinedCmd

isValid() - Method in class org.apache.empire.db.DBCommand

isValid() - Method in class org.apache.empire.db.DBCommandExpr

isValid() - Method in class org.apache.empire.db.DBRecord

Returns true if the record is valid.

isValidateFieldValues() - Method in class org.apache.empire.db.DBRecord

Returns whether or not values are checked for validity when calling setValue().

isValidQuery() - Method in class org.apache.empire.db.DBCommand

Returns whether the command object can produce a select sql-statement.

isValidUpdate() - Method in class org.apache.empire.db.DBCommand

Returns whether the command object can produce a update sql-statement.

isValueValid(int) - Method in class org.apache.empire.db.DBRecord

Returns whether a field value is provided i.e.

ItemExistsException - Exception in org.apache.empire.exceptions

ItemExistsException(Object) - Constructor for exception org.apache.empire.exceptions.ItemExistsException

ItemNotFoundException - Exception in org.apache.empire.exceptions

ItemNotFoundException(Object) - Constructor for exception org.apache.empire.exceptions.ItemNotFoundException

iterator() - Method in class org.apache.empire.commons.Attributes

iterator() - Method in class org.apache.empire.commons.Options

iterator(int) - Method in class org.apache.empire.db.DBReader

Returns an row iterator for this reader.
There can only be one iterator at a time.

iterator() - Method in class org.apache.empire.db.DBReader

Returns an row iterator for this reader.

iterator() - Method in class org.apache.empire.db.DBSQLScript

Returns an iterator

J

join(DBJoinExpr) - Method in class org.apache.empire.db.DBCommand

Adds a join to the list of join expressions.

join(DBColumnExpr, DBColumn, DBJoinType) - Method in class org.apache.empire.db.DBCommand

Adds a join based on two columns to the list of join expressions.

join(DBColumnExpr, DBColumn) - Method in class org.apache.empire.db.DBCommand

Adds an inner join based on two columns to the list of join expressions.

join(DBRowSet, DBCompareExpr, DBJoinType) - Method in class org.apache.empire.db.DBCommand

Adds a join based on a compare expression to the command.

join(DBRowSet, DBCompareExpr) - Method in class org.apache.empire.db.DBCommand

Adds an inner join based on a compare expression to the command.

join(DBColumnExpr, DBColumn, DBJoinType) - Method in class org.apache.empire.db.sqlite.DBDatabaseDriverSQLite.DBCommandSQLite

joins - Variable in class org.apache.empire.db.DBCommand

K

keyColumns - Variable in class org.apache.empire.data.bean.BeanRecordProxy

keyColumns - Variable in class org.apache.empire.db.DBQuery

keyWord - Variable in class org.apache.empire.db.DBCombinedCmd

L

left - Variable in class org.apache.empire.db.DBCombinedCmd

left - Variable in class org.apache.empire.db.expr.column.DBConcatExpr

left - Variable in class org.apache.empire.db.expr.compare.DBCompareAndOrExpr

left - Variable in class org.apache.empire.db.expr.join.DBJoinExpr

length() - Method in class org.apache.empire.db.DBColumnExpr

Creates and returns a sql-expression that returns the string length of this expression.

like(Object) - Method in class org.apache.empire.db.DBColumnExpr

Creates and returns a new comparison object for the SQL "like" operator.

like(String, char) - Method in class org.apache.empire.db.DBColumnExpr

Creates and returns a new comparison object for the SQL "like" operator.

likeLower(String) - Method in class org.apache.empire.db.DBColumnExpr

Creates and returns a new comparison object for the SQL "like" operator.

likeUpper(String) - Method in class org.apache.empire.db.DBColumnExpr

Creates and returns a new comparison object for the SQL "like" operator.

limit - Variable in class org.apache.empire.db.mysql.DBDatabaseDriverMySQL.DBCommandMySQL

limit - Variable in class org.apache.empire.db.postgresql.DBDatabaseDriverPostgreSQL.DBCommandPostreSQL

limit - Variable in class org.apache.empire.db.sqlserver.DBDatabaseDriverMSSQL.DBCommandMSSQL

limitRows(int) - Method in class org.apache.empire.db.DBCommandExpr

set the maximum number of rows to return when executing a query command A negative value will remove the limit.

limitRows(int) - Method in class org.apache.empire.db.mysql.DBDatabaseDriverMySQL.DBCommandMySQL

limitRows(int) - Method in class org.apache.empire.db.oracle.DBCommandOracle

limitRows(int) - Method in class org.apache.empire.db.postgresql.DBDatabaseDriverPostgreSQL.DBCommandPostreSQL

limitRows(int) - Method in class org.apache.empire.db.sqlserver.DBDatabaseDriverMSSQL.DBCommandMSSQL

linkName - Variable in class org.apache.empire.db.DBDatabase

list() - Method in class org.apache.empire.commons.Attributes

log - Static variable in class org.apache.empire.data.bean.BeanRecordProxy

log - Static variable in class org.apache.empire.db.DBCommand

log - Static variable in class org.apache.empire.db.DBReader

log - Static variable in class org.apache.empire.db.DBRecord

log - Static variable in class org.apache.empire.db.DBRowSet

log() - Method in exception org.apache.empire.db.exceptions.QueryFailedException

log the error

log() - Method in exception org.apache.empire.db.exceptions.StatementFailedException

log the error

log - Static variable in class org.apache.empire.db.oracle.OracleDataDictionnary

log() - Method in exception org.apache.empire.exceptions.BeanInstantiationException

log the error

log() - Method in exception org.apache.empire.exceptions.BeanPropertyGetException

log the error

log() - Method in exception org.apache.empire.exceptions.BeanPropertySetException

log the error

log() - Method in exception org.apache.empire.exceptions.EmpireException

log the error (info must be enabled)

log - Static variable in class org.apache.empire.xml.XMLUtil

log - Static variable in class org.apache.empire.xml.XMLWriter

longRunndingStmtThreshold - Variable in class org.apache.empire.db.DBDatabase

lower() - Method in class org.apache.empire.db.DBColumnExpr

Creates and returns a function object which converts the current expression to lower case.

M

max() - Method in class org.apache.empire.db.DBColumnExpr

Creates and returns an aggregation function object which returns the maximum value for the current expression over a group of rows.

maxCount - Variable in class org.apache.empire.db.DBReader.DBReaderIterator

MEDIUMINT - Static variable in class org.apache.empire.db.DBTable

messageFromSQLException(DBDatabaseDriver, SQLException) - Static method in exception org.apache.empire.db.exceptions.EmpireSQLException

min() - Method in class org.apache.empire.db.DBColumnExpr

Creates and returns an aggregation function object which returns the minimum value for the current expression over a group of rows.

minus(Object) - Method in class org.apache.empire.db.DBColumnExpr

Creates and returns a new calculation object for the SQL "-" (minus) operator.

minus(int) - Method in class org.apache.empire.db.DBColumnExpr

Creates and returns a new calculation object for either the SQL "+" (plus) or "-" (minus) operator depending on whether the supplied integer value is negative or positive.

MiscellaneousErrorException - Exception in org.apache.empire.exceptions

MiscellaneousErrorException(String) - Constructor for exception org.apache.empire.exceptions.MiscellaneousErrorException

modified - Variable in class org.apache.empire.data.bean.BeanRecordProxy

modifyValue(int, Object, boolean) - Method in class org.apache.empire.db.DBRecord

Modifies a column value bypassing all checks made by setValue.

month() - Method in class org.apache.empire.db.DBColumnExpr

Creates and returns an function object that calculates the month of a date value.

moveNext() - Method in class org.apache.empire.db.DBReader

Moves the cursor down one row from its current position.

MSSQL_SQL_KEYWORDS - Static variable in class org.apache.empire.db.sqlserver.DBDatabaseDriverMSSQL

MSSqlDDLGenerator - Class in org.apache.empire.db.sqlserver

MSSqlDDLGenerator(DBDatabaseDriverMSSQL) - Constructor for class org.apache.empire.db.sqlserver.MSSqlDDLGenerator

multiplyWith(Object) - Method in class org.apache.empire.db.DBColumnExpr

Creates and returns a new calculation object for the SQL "*" (multiply) operator.

MySQLDDLGenerator - Class in org.apache.empire.db.mysql

MySQLDDLGenerator(DBDatabaseDriverMySQL) - Constructor for class org.apache.empire.db.mysql.MySQLDDLGenerator

N

name - Variable in class org.apache.empire.db.DBColumn

namePrimaryKeyConstraint - Variable in class org.apache.empire.db.DBDDLGenerator

next() - Method in class org.apache.empire.db.DBReader.DBReaderForwardIterator

Implements the Iterator Interface.

next() - Method in class org.apache.empire.db.DBReader.DBReaderScrollableIterator

Implements the Iterator Interface.

NO_VALUE - Static variable in class org.apache.empire.commons.ObjectUtils

Constant that defines a object of type NoValue.

NoPrimaryKeyException - Exception in org.apache.empire.db.exceptions

NoPrimaryKeyException(DBRowSet) - Constructor for exception org.apache.empire.db.exceptions.NoPrimaryKeyException

normalize(String) - Method in class org.apache.empire.xml.XMLWriter

Converts a string to valid XML-Syntax replacing XML entities.

normalize(String, boolean) - Static method in class org.apache.empire.xml.XMLWriter

not() - Method in class org.apache.empire.db.expr.compare.DBCompareExpr

Creates a sql-expression for the not() function.

notifyParamUsage(DBCmdParam) - Method in class org.apache.empire.db.DBCommand

internally used to reorder the command params to match their order of occurance

NotImplementedException - Exception in org.apache.empire.exceptions

NotImplementedException(Object, String) - Constructor for exception org.apache.empire.exceptions.NotImplementedException

notIn(Object) - Method in class org.apache.empire.db.DBColumnExpr

Creates and returns a new comparison object for the SQL "not in" operator.

notInRangeErrorType - Static variable in exception org.apache.empire.db.exceptions.FieldValueOutOfRangeException

notLike(Object) - Method in class org.apache.empire.db.DBColumnExpr

Creates and returns a new comparison object for the SQL "not like" operator.

NotSupportedException - Exception in org.apache.empire.exceptions

NotSupportedException(Object, String) - Constructor for exception org.apache.empire.exceptions.NotSupportedException

nullIfEmpty(Object) - Static method in class org.apache.empire.commons.StringUtils

Returns null if the value supplied is null or an empty String.

nvl(Object) - Method in class org.apache.empire.db.DBColumnExpr

Deprecated. Outdated oracle syntax - use coalesce instead

O

ObjectNotValidException - Exception in org.apache.empire.exceptions

ObjectNotValidException(Object) - Constructor for exception org.apache.empire.exceptions.ObjectNotValidException

ObjectUtils - Class in org.apache.empire.commons

This class contains common functions for comparing and converting values of type Object.

onDeleteCascade() - Method in class org.apache.empire.db.DBRelation

short for

onDeleteCascadeRecords() - Method in class org.apache.empire.db.DBRelation

short for

onFieldChanged(int) - Method in class org.apache.empire.db.DBRecord

Override this to get notified when a field value changes

onRecordChanged() - Method in class org.apache.empire.db.DBRecord

Override this to do extra handling when the record changes

onRowSetChanged() - Method in class org.apache.empire.db.DBRecord

Override this to do extra handling when the rowset for this record changes

open(DBDatabaseDriver, Connection) - Method in class org.apache.empire.db.DBDatabase

Sets the database driver for this database.

open(DBCommandExpr, boolean, Connection) - Method in class org.apache.empire.db.DBReader

Opens the reader by executing the given SQL command.
After the reader is open, the reader's position is before the first record.
Use moveNext or iterator() to step through the rows.
Data of the current row can be accessed through the functions on the RecordData interface.

open(DBCommandExpr, Connection) - Method in class org.apache.empire.db.DBReader

Opens the reader by executing the given SQL command.

optimizerHint - Variable in class org.apache.empire.db.oracle.DBCommandOracle

OptionEntry - Class in org.apache.empire.commons

This class defines one possible value of a field and it's description
This class is used by the Options class to implement a set of options where the option value us used as the key for the set.
The text should only be used for display purposes e.g.

OptionEntry(Object, String) - Constructor for class org.apache.empire.commons.OptionEntry

Options - Class in org.apache.empire.commons

This class represents a list of possible values that are valid for a particular field.
Additionally the class provides a text string describing the value for display purposes.
The class is implemented as a set of OptionEntry objects where the entry value is used as the key for the set and thus must be unique.

Options() - Constructor for class org.apache.empire.commons.Options

Options(Options) - Constructor for class org.apache.empire.commons.Options

Options(OptionEntry[]) - Constructor for class org.apache.empire.commons.Options

options - Variable in class org.apache.empire.db.DBColumnExpr

Options.InsertPos - Enum in org.apache.empire.commons

or - Variable in class org.apache.empire.db.expr.compare.DBCompareAndOrExpr

or(DBCompareExpr) - Method in class org.apache.empire.db.expr.compare.DBCompareExpr

Create a new DBCompareAndOrExpr object.

OracleDataDictionnary - Class in org.apache.empire.db.oracle

OracleDataDictionnary() - Constructor for class org.apache.empire.db.oracle.OracleDataDictionnary

Defines mapping of the Empire-db data types with the oracle data types.

OracleDataDictionnary.ColumnInfo - Class in org.apache.empire.db.oracle

Immutable column info helper class

OracleDataDictionnary.ColumnInfo(String, int, int, int, int, String) - Constructor for class org.apache.empire.db.oracle.OracleDataDictionnary.ColumnInfo

OracleDDLGenerator - Class in org.apache.empire.db.oracle

OracleDDLGenerator(DBDatabaseDriverOracle) - Constructor for class org.apache.empire.db.oracle.OracleDDLGenerator

OracleRowNumExpr - Class in org.apache.empire.db.oracle

implements a column expression for the Oracle rownum function

OracleRowNumExpr(DBDatabase) - Constructor for class org.apache.empire.db.oracle.OracleRowNumExpr

Constructs a new OracleRowNumExpr object.

OracleSYSDatabase - Class in org.apache.empire.db.oracle

Represents the data model of the system tables.

OracleSYSDatabase(DBDatabaseDriverOracle) - Constructor for class org.apache.empire.db.oracle.OracleSYSDatabase

OracleSYSDatabase.DBColComments - Class in org.apache.empire.db.oracle

OracleSYSDatabase.DBColComments(DBDatabase) - Constructor for class org.apache.empire.db.oracle.OracleSYSDatabase.DBColComments

OracleSYSDatabase.DBColInfo - Class in org.apache.empire.db.oracle

OracleSYSDatabase.DBColInfo(DBDatabase) - Constructor for class org.apache.empire.db.oracle.OracleSYSDatabase.DBColInfo

OracleSYSDatabase.DBConstraints - Class in org.apache.empire.db.oracle

OracleSYSDatabase.DBConstraints(DBDatabase) - Constructor for class org.apache.empire.db.oracle.OracleSYSDatabase.DBConstraints

OracleSYSDatabase.DBTabComments - Class in org.apache.empire.db.oracle

OracleSYSDatabase.DBTabComments(DBDatabase) - Constructor for class org.apache.empire.db.oracle.OracleSYSDatabase.DBTabComments

OracleSYSDatabase.DBUserConCol - Class in org.apache.empire.db.oracle

OracleSYSDatabase.DBUserConCol(DBDatabase) - Constructor for class org.apache.empire.db.oracle.OracleSYSDatabase.DBUserConCol

orderBy(DBOrderByExpr...) - Method in class org.apache.empire.db.DBCombinedCmd

orderBy - Variable in class org.apache.empire.db.DBCommandExpr

orderBy(DBOrderByExpr...) - Method in class org.apache.empire.db.DBCommandExpr

Adds an order by expression the command

orderBy(DBColumnExpr...) - Method in class org.apache.empire.db.DBCommandExpr

Adds a list of columns to the orderBy clause in ascending order

orderBy(DBColumnExpr, boolean) - Method in class org.apache.empire.db.DBCommandExpr

Adds an order by with ascending or descending order

org.apache.empire.commons - package org.apache.empire.commons

This package contains various common classes for error handling, specific data types and data type conversion.

org.apache.empire.data - package org.apache.empire.data

This package contains interfaces for data and metadata handling.

org.apache.empire.data.bean - package 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.db - package org.apache.empire.db

This package contains the core Empire-DB implementation classes.

org.apache.empire.db.derby - package org.apache.empire.db.derby

This package contains classes necessary to support the Apache Derby database system.

org.apache.empire.db.exceptions - package org.apache.empire.db.exceptions

This package contains classes for exception handling of database related errors.

org.apache.empire.db.expr.column - package org.apache.empire.db.expr.column

This package contains SQL-generator classes for column expressions.

org.apache.empire.db.expr.compare - package 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 - package 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 - package org.apache.empire.db.expr.order

org.apache.empire.db.expr.set - package org.apache.empire.db.expr.set

This package contains SQL-generator classes for set expressions used in the set clause.

org.apache.empire.db.h2 - package org.apache.empire.db.h2

This package contains classes necessary to support the H2 database system.

org.apache.empire.db.hsql - package org.apache.empire.db.hsql

This package contains classes necessary to support the HSQLDB database system.

org.apache.empire.db.mysql - package org.apache.empire.db.mysql

This package contains classes necessary to support the MySQL database system.

org.apache.empire.db.oracle - package org.apache.empire.db.oracle

This package contains classes necessary to support the Oracle database system.

org.apache.empire.db.postgresql - package org.apache.empire.db.postgresql

This package contains classes necessary to support the PostgreSQL database system.

org.apache.empire.db.sqlite - package org.apache.empire.db.sqlite

org.apache.empire.db.sqlserver - package org.apache.empire.db.sqlserver

This package contains classes necessary to support the Microsoft SQL-Server database system.

org.apache.empire.exceptions - package org.apache.empire.exceptions

This package contains classes for exception handling of general errors.

org.apache.empire.xml - package org.apache.empire.xml

This package contains classes for XML generation and configuration.

out - Variable in class org.apache.empire.xml.XMLWriter

Print writer.

outOfRangeErrorType - Static variable in exception org.apache.empire.db.exceptions.FieldValueOutOfRangeException

P

params - Variable in class org.apache.empire.db.expr.column.DBFuncExpr

parenthesis() - Method in class org.apache.empire.db.DBColumnExpr

Creates and returns a function object which encloses the current expression in parenthesis.

parenthesis() - Method in class org.apache.empire.db.expr.compare.DBCompareAndOrExpr

wraps the current expression with parenthesis.

parseDate(String, Locale) - Static method in class org.apache.empire.commons.DateUtils

phrase - Variable in class org.apache.empire.db.expr.column.DBFuncExpr

plus(Object) - Method in class org.apache.empire.db.DBColumnExpr

Creates and returns a new calculation object for the SQL "+" (plus) operator.

plus(int) - Method in class org.apache.empire.db.DBColumnExpr

Creates and returns a new calculation object for either the SQL "+" (plus) or "-" (minus) operator depending on whether the supplied integer value is positive or negative.

PostgreDDLGenerator - Class in org.apache.empire.db.postgresql

PostgreDDLGenerator(DBDatabaseDriverPostgreSQL) - Constructor for class org.apache.empire.db.postgresql.PostgreDDLGenerator

prepareInitRecord(DBRecord, Object, boolean) - Method in class org.apache.empire.db.DBRowSet

Initialize this DBRowSet object and sets it's initial state.

prepareStatement(PreparedStatement, Object[], Connection) - Method in class org.apache.empire.db.DBDatabaseDriver

Prepares an sql statement by setting the supplied objects as parameters.

PRIMARYKEY - Static variable in class org.apache.empire.db.DBIndex

SQL Primary key index

primaryKey - Variable in class org.apache.empire.db.DBRowSet

print(Node, int) - Method in class org.apache.empire.xml.XMLWriter

Prints the specified node recursively

print(Document) - Method in class org.apache.empire.xml.XMLWriter

Prints the specified document.

print(Document, String) - Method in class org.apache.empire.xml.XMLWriter

Prints the specified document.

PropertyReadOnlyException - Exception in org.apache.empire.exceptions

PropertyReadOnlyException(String) - Constructor for exception org.apache.empire.exceptions.PropertyReadOnlyException

Q

queryColumns - Variable in class org.apache.empire.db.DBQuery

QueryFailedException - Exception in org.apache.empire.db.exceptions

QueryFailedException(DBObject, String, SQLException) - Constructor for exception org.apache.empire.db.exceptions.QueryFailedException

QueryNoResultException - Exception in org.apache.empire.db.exceptions

QueryNoResultException(String) - Constructor for exception org.apache.empire.db.exceptions.QueryNoResultException

queryObjectList(String, Object[], Connection, Collection<Object[]>, int) - Method in class org.apache.empire.db.DBDatabase

Adds the result of a query to a given collection.
The individual rows will be added as an array of objects (object[])

queryObjectList(DBCommand, Connection, Collection<Object[]>) - Method in class org.apache.empire.db.DBDatabase

Adds the result of a query to a given collection.
The individual rows will be added as an array of objects (object[])

queryObjectList(DBCommand, Connection) - Method in class org.apache.empire.db.DBDatabase

Returns the result of a query as a list Object-Arrays This function should only be used for small lists.

queryOptionList(String, Object[], Connection, Options) - Method in class org.apache.empire.db.DBDatabase

Fills an option list provided with the result from a query.

queryOptionList(DBCommand, Connection, Options) - Method in class org.apache.empire.db.DBDatabase

Fills an option list provided with the result from a query.

queryOptionList(DBCommand, Connection) - Method in class org.apache.empire.db.DBDatabase

Returns a list of key value pairs from an sql query.

querySimpleList(Class<T>, String, Object[], DataType, Connection, Collection<T>, int) - Method in class org.apache.empire.db.DBDatabase

Adds the first column of a query result to a collection.

querySimpleList(Class<T>, DBCommand, Connection, Collection<T>) - Method in class org.apache.empire.db.DBDatabase

Adds the first column of a query result to a collection.

querySimpleList(Class<T>, DBCommand, Connection) - Method in class org.apache.empire.db.DBDatabase

Returns a one dimensional array from an sql query.

querySimpleList(DBCommand, Connection) - Method in class org.apache.empire.db.DBDatabase

Returns a one dimensional array from an sql query.

querySingleInt(String, Object[], int, Connection) - Method in class org.apache.empire.db.DBDatabase

Returns the value of the first row/column of a sql-query as an int.

querySingleInt(DBCommand, int, Connection) - Method in class org.apache.empire.db.DBDatabase

Returns the value of the first row/column of a sql-query as an int.

querySingleInt(DBCommand, Connection) - Method in class org.apache.empire.db.DBDatabase

Returns the value of the first row/column of a sql-query as an int.

querySingleLong(String, Object[], long, Connection) - Method in class org.apache.empire.db.DBDatabase

Returns the value of the first row/column of a sql-query as a long.

querySingleLong(DBCommand, long, Connection) - Method in class org.apache.empire.db.DBDatabase

Returns the value of the first row/column of a sql-query as a long.

querySingleLong(DBCommand, Connection) - Method in class org.apache.empire.db.DBDatabase

Returns the value of the first row/column of a sql-query as a long.

querySingleRow(String, Object[], Connection) - Method in class org.apache.empire.db.DBDatabase

Returns all values of the first row of a sql-query as an array.

querySingleRow(DBCommand, Connection) - Method in class org.apache.empire.db.DBDatabase

Returns all values of the first row of a sql-query as an array.

querySingleString(String, Object[], String, Connection) - Method in class org.apache.empire.db.DBDatabase

Returns the value of the first row/column of a sql-query as a string.

querySingleString(DBCommand, String, Connection) - Method in class org.apache.empire.db.DBDatabase

Returns the value of the first row/column of a sql-query as a string.

querySingleString(DBCommand, Connection) - Method in class org.apache.empire.db.DBDatabase

Returns the value of the first row/column of a sql-query as a string.

querySingleValue(String, Object[], DataType, Connection) - Method in class org.apache.empire.db.DBDatabase

Returns the value of the first row/column of a sql-query as an object.

querySingleValue(String, Object[], Connection) - Method in class org.apache.empire.db.DBDatabase

Returns the value of the first row/column of a sql-query as an object.

querySingleValue(DBCommand, Connection) - Method in class org.apache.empire.db.DBDatabase

Returns the value of the first row/column of a sql-query as an object.

R

read(DBRowSet, Object[], Connection) - Method in class org.apache.empire.db.DBRecord

Loads a record from the database identified by it's primary key.

read(DBRowSet, Object, Connection) - Method in class org.apache.empire.db.DBRecord

Loads a record from the database identified by it's primary key.

readConfiguration(String, boolean) - Method in class org.apache.empire.xml.XMLConfiguration

Reads the configuration file and parses the XML Configuration.

readProperties(Object, String...) - Method in class org.apache.empire.xml.XMLConfiguration

reads all properties from a given properties node and applies them to the given bean

readProperties(Object, Element) - Method in class org.apache.empire.xml.XMLConfiguration

reads all properties from a given properties node and applies them to the given bean

readRecord(DBRecord, Object[], Connection) - Method in class org.apache.empire.db.DBCommandExpr.DBCmdQuery

Returns the error message: ERR_NOTSUPPORTED

readRecord(DBRecord, Object[], Connection) - Method in class org.apache.empire.db.DBQuery

Creates a select SQL-Command of the query call the InitRecord method to execute the SQL-Command.

readRecord(DBRecord, DBCommand, Connection) - Method in class org.apache.empire.db.DBRowSet

Reads a single record from the database using the given command object.
If a record is found the DBRecord object will hold all record data.

readRecord(DBRecord, Object[], Connection) - Method in class org.apache.empire.db.DBRowSet

Reads the record with the given primary key from the database.

Record - Interface in org.apache.empire.data

The record interface provides methods used for updating data.

RecordData - Interface in org.apache.empire.data

The RecordData interface provides methods for accessing data and context specific metadata.

RecordDeleteFailedException - Exception in org.apache.empire.db.exceptions

RecordDeleteFailedException(DBRowSet, Object[]) - Constructor for exception org.apache.empire.db.exceptions.RecordDeleteFailedException

recordExists(Object[], Connection) - Method in class org.apache.empire.db.DBRowSet

Returns true if the record exists in the database or false otherwise.

recordExists(Object, Connection) - Method in class org.apache.empire.db.DBRowSet

Returns true if the record exists in the database or false otherwise.

RecordNotFoundException - Exception in org.apache.empire.db.exceptions

RecordNotFoundException(DBRowSet, Object[]) - Constructor for exception org.apache.empire.db.exceptions.RecordNotFoundException

RecordUpdateFailedException - Exception in org.apache.empire.db.exceptions

RecordUpdateFailedException(DBRowSet, Object[]) - Constructor for exception org.apache.empire.db.exceptions.RecordUpdateFailedException

RecordUpdateInvalidException - Exception in org.apache.empire.db.exceptions

RecordUpdateInvalidException(DBRowSet, Object[]) - Constructor for exception org.apache.empire.db.exceptions.RecordUpdateInvalidException

referenceOn(DBTableColumn) - Method in class org.apache.empire.db.DBTableColumn

Creates a foreign key relation for this column.

register(String) - Method in class org.apache.empire.db.DBDatabase

registers the database in the global list of databases

relations - Variable in class org.apache.empire.db.DBDatabase

remove(Object) - Method in class org.apache.empire.commons.Attributes

remove(Object) - Method in class org.apache.empire.commons.Options

remove() - Method in class org.apache.empire.db.DBReader.DBReaderIterator

Implements the Iterator Interface Method remove not implemented and not applicable.

removeConstraintOn(List<DBCompareExpr>, DBColumnExpr) - Method in class org.apache.empire.db.DBCommand

removes a constraint on a particular column to the 'where' or 'having' collections

removeHavingConstraintOn(DBColumnExpr) - Method in class org.apache.empire.db.DBCommand

removes a constraint on a particular column from the where clause

removeJoinsOn(DBRowSet) - Method in class org.apache.empire.db.DBCommand

removes all joins to a given table or view

removeJoinsOn(DBColumn) - Method in class org.apache.empire.db.DBCommand

removes all joins to a given column

removeWhereConstraintOn(DBColumnExpr) - Method in class org.apache.empire.db.DBCommand

removes a constraint on a particular column from the where clause

replace(String, String, String) - Static method in class org.apache.empire.commons.StringUtils

Replaces all occurences of find in source by replace.

replace(Object, Object) - Method in class org.apache.empire.db.DBColumnExpr

Creates and returns a sql-expression for the replace(...) function.

replaceAll(String, String, String) - Static method in class org.apache.empire.commons.StringUtils

Returns a String with all occurrences of from within orig replaced with to.

reservedSQLKeywords - Variable in class org.apache.empire.db.DBDatabaseDriver

resetParamUsage() - Method in class org.apache.empire.db.DBCommand

internally used to reset the command param usage count.

reverse() - Method in class org.apache.empire.db.DBColumnExpr

Creates and returns a sql-expression for the reverse(...) function.

reverse() - Method in class org.apache.empire.db.expr.join.DBJoinExpr

This function swaps the left and the right statements of the join expression.

reversed(DBJoinType) - Static method in enum org.apache.empire.db.DBJoinType

right - Variable in class org.apache.empire.db.DBCombinedCmd

right - Variable in class org.apache.empire.db.expr.column.DBConcatExpr

right - Variable in class org.apache.empire.db.expr.compare.DBCompareAndOrExpr

right - Variable in class org.apache.empire.db.expr.join.DBJoinExpr

rollback(Connection) - Method in class org.apache.empire.db.DBDatabase

Discards all changes made since the previous commit/rollback and releases any database locks currently held by this Connection.

round(int) - Method in class org.apache.empire.db.DBColumnExpr

Creates and returns an function object that rounds a number espression with the given decimals.

rowNumExpr - Variable in class org.apache.empire.db.oracle.DBCommandOracle

rowset - Variable in class org.apache.empire.db.DBColumn

rset - Variable in class org.apache.empire.db.DBReader

run(DBDatabaseDriver, Connection, boolean) - Method in class org.apache.empire.db.DBSQLScript

Runs all SQL Statements using the supplied driver and connection.

run(DBDatabaseDriver, Connection) - Method in class org.apache.empire.db.DBSQLScript

Runs all SQL Statements using the supplied driver and connection.

S

saveAsFile(Document, String) - Static method in class org.apache.empire.xml.XMLWriter

Prints out the DOM-Tree.

schema - Variable in class org.apache.empire.db.DBDatabase

the database schema *

select - Variable in class org.apache.empire.db.DBCommand

select(DBColumnExpr) - Method in class org.apache.empire.db.DBCommand

Adds a DBColumnExpr object to the Vector: 'select'.

select(DBColumnExpr...) - Method in class org.apache.empire.db.DBCommand

Adds a list of columns to the select phrase of an sql statement.

select(Collection<? extends DBColumnExpr>) - Method in class org.apache.empire.db.DBCommand

Adds a collection of columns to the select phrase of an sql statement.

selectDistinct - Variable in class org.apache.empire.db.DBCommand

selectDistinct() - Method in class org.apache.empire.db.DBCommand

Sets whether or not the select statement should contain the distinct directive .

set(String, Object) - Method in class org.apache.empire.commons.Attributes

set(Object, String, Options.InsertPos) - Method in class org.apache.empire.commons.Options

Sets or Adds an option at a certain position

set(Object, String) - Method in class org.apache.empire.commons.Options

Sets or adds Adds an option at the bottom

set - Variable in class org.apache.empire.db.DBCommand

set(DBSetExpr) - Method in class org.apache.empire.db.DBCommand

Inserts DBSetExpr objects to the Vector 'set'.

set(Object) - Method in interface org.apache.empire.db.DBDatabaseDriver.DBSetGenKeys

set(DBXmlDictionary) - Static method in class org.apache.empire.db.DBXmlDictionary

setAttribute(String, Object) - Method in class org.apache.empire.data.bean.BeanProperty

setAttribute(String, Object) - Method in class org.apache.empire.db.DBColumnExpr

Sets the value of a column attribute.

setBean(T) - Method in class org.apache.empire.data.bean.BeanRecordProxy

setBeanPropertyName(String) - Method in class org.apache.empire.db.DBColumnExpr

Sets the Java bean property name for this column.

setBeanPropertyValue(Object, Column, Object) - Method in class org.apache.empire.data.bean.BeanRecordProxy

setBeanValue(Object, String, Column) - Method in class org.apache.empire.db.DBRecord

set a record value from a particular bean property.

setBeanValues(Object, Collection<Column>) - Method in class org.apache.empire.data.bean.BeanRecordProxy

setBeanValues(Object) - Method in class org.apache.empire.data.bean.BeanRecordProxy

setBeanValues(Object, Collection<Column>) - Method in interface org.apache.empire.data.Record

sets all record values from a particular bean.

setBeanValues(Object) - Method in interface org.apache.empire.data.Record

sets all record values from a particular bean.

setBeanValues(Object, Collection<Column>) - Method in class org.apache.empire.db.DBRecord

Sets record values from the supplied java bean.

setBeanValues(Object) - Method in class org.apache.empire.db.DBRecord

Sets record values from the suppied java bean.

setBooleanType(DBDatabaseDriverOracle.BooleanType) - Method in class org.apache.empire.db.oracle.DBDatabaseDriverOracle

setCascadeDelete(boolean) - Method in class org.apache.empire.db.DBTable

Deprecated. Deprecated flag that enables cascaded deletes on foreign key relations. WARING: The flag only affects newly created relations referring to this table. This property will be removed in future releases. Use DBRelation.setOnDeleteAction() instead.

setCharacterSet(String) - Method in class org.apache.empire.db.mysql.DBDatabaseDriverMySQL

setComment(String) - Method in class org.apache.empire.db.DBColumn

Sets a comment describing the current column.

setComment(String) - Method in class org.apache.empire.db.DBRowSet

setConstraint(List<DBCompareExpr>, DBCompareExpr) - Method in class org.apache.empire.db.DBCommand

adds a constraint to the 'where' or 'having' collections

setControlType(String) - Method in class org.apache.empire.data.bean.BeanProperty

setControlType(String) - Method in class org.apache.empire.db.DBColumnExpr

Sets the controlType attribute.

setDatabaseName(String) - Method in class org.apache.empire.db.derby.DBDatabaseDriverDerby

Sets the name for the database / schema
This names is required for creating a database.
When a name is set, the driver will automatically execute 'USE dbname' when the database is opened.

setDatabaseName(String) - Method in class org.apache.empire.db.h2.DBDatabaseDriverH2

Sets the name for the database / schema
This names is required for creating a database.
When a name is set, the driver will automatically execute 'USE dbname' when the database is opened.

setDatabaseName(String) - Method in class org.apache.empire.db.mysql.DBDatabaseDriverMySQL

Sets the name for the database / schema
This names is required for creating a database.
When a name is set, the driver will automatically execute 'USE dbname' when the database is opened.

setDatabaseName(String) - Method in class org.apache.empire.db.postgresql.DBDatabaseDriverPostgreSQL

Sets the name for the database / schema
This names is required for creating a database.
When a name is set, the driver will automatically execute 'USE dbname' when the database is opened.

setDatabaseName(String) - Method in class org.apache.empire.db.sqlserver.DBDatabaseDriverMSSQL

setDate(Date, int, int, int) - Static method in class org.apache.empire.commons.DateUtils

setDDLColumnDefaults(boolean) - Method in class org.apache.empire.db.DBDatabaseDriver

Set true if column default values should be included in DDL Statements

setDefaultEncoding(String) - Static method in class org.apache.empire.db.DBBlobData

Sets the defaultEncoding used in a constructor.

setDefaultValue(Object) - Method in class org.apache.empire.db.DBTableColumn

Sets the default column value.

setDescending(boolean) - Method in class org.apache.empire.db.expr.order.DBOrderByExpr

setElementText(Node, Object) - Static method in class org.apache.empire.xml.XMLUtil

Sets the text value of an Element.

setEngine(String) - Method in class org.apache.empire.db.mysql.DBDatabaseDriverMySQL

Set the table engine that is used when creating new tables

setKeyColumn(Column) - Method in class org.apache.empire.data.bean.BeanClass

Sets the key to a single column

setKeyColumn(DBView.DBViewColumn) - Method in class org.apache.empire.db.DBView

identifies the column that uniquely identifies a row in the view

setKeyColumns(Column[]) - Method in class org.apache.empire.data.bean.BeanClass

Sets the list of key columns.

setKeyColumns(DBView.DBViewColumn[]) - Method in class org.apache.empire.db.DBView

identifies the columns that uniquely identify a row in the view

setKeyConstraints(DBCommand, Object[]) - Method in class org.apache.empire.db.DBRowSet

Set the constraints for a single record from a supplied key

setLinkName(String) - Method in class org.apache.empire.db.DBDatabase

Sets the name of the database link used to identify objects.

setModified(DBColumn, boolean) - Method in class org.apache.empire.db.DBRecord

Sets the modified state of a column.
This will force the field to be updated in the database, if set to TRUE.

setObjectOwner(String) - Method in class org.apache.empire.db.sqlserver.DBDatabaseDriverMSSQL

setOnDeleteAction(DBRelation.DBCascadeAction) - Method in class org.apache.empire.db.DBRelation

sets the action taken when deleting records that affect this foreign key relation See DBCascadeAction enum for details.

setOptimizerHint(String) - Method in class org.apache.empire.db.oracle.DBCommandOracle

setOptimizerIndexHint(DBIndex) - Method in class org.apache.empire.db.oracle.DBCommandOracle

setOptions(Options) - Method in class org.apache.empire.data.bean.BeanProperty

setOptions(Options) - Method in class org.apache.empire.db.DBColumnExpr

Sets the options for this column indicating all valid values.

setOracle8Compatibilty(boolean) - Method in class org.apache.empire.db.oracle.DBDatabaseDriverOracle

setPreparedStatementsEnabled(boolean) - Method in class org.apache.empire.db.DBDatabase

enables or disables the use of prepared statements for update and insert commands as well as for read operations on a DBRecord.

setPrimaryKey(DBColumn[]) - Method in class org.apache.empire.db.DBTable

Sets the primary keys.

setPrimaryKey(DBColumn) - Method in class org.apache.empire.db.DBTable

Sets the primary key to a single column.

setPrimaryKey(DBColumn, DBColumn) - Method in class org.apache.empire.db.DBTable

Adds two columns to the primary key list.

setPrimaryKey(DBColumn, DBColumn, DBColumn) - Method in class org.apache.empire.db.DBTable

Adds three columns to the primary key list.

setPropertyValue(Object, Node) - Method in class org.apache.empire.xml.XMLConfiguration

setReadOnly(boolean) - Method in class org.apache.empire.db.DBTableColumn

Sets the read only attribute of the column.

setRequired(boolean) - Method in class org.apache.empire.db.DBTableColumn

Changes the required property of the table column
Use for dynamic data model changes only.

setSchema(String) - Method in class org.apache.empire.db.DBDatabase

Sets the schema for SQL statements.

setSequenceTableName(String) - Method in class org.apache.empire.db.derby.DBDatabaseDriverDerby

Sets the name of the sequence table.

setSequenceTableName(String) - Method in class org.apache.empire.db.h2.DBDatabaseDriverH2

Sets the name of the sequence table.

setSequenceTableName(String) - Method in class org.apache.empire.db.mysql.DBDatabaseDriverMySQL

Sets the name of the sequence table.

setSequenceTableName(String) - Method in class org.apache.empire.db.sqlserver.DBDatabaseDriverMSSQL

Sets the name of the sequence table.

setSingleByteChars(boolean) - Method in class org.apache.empire.db.DBTableColumn

sets whether this column is a single byte character or text column

setSize(double) - Method in class org.apache.empire.db.DBTableColumn

Changes the size of the table column
Use for dynamic data model changes only.

setText(String) - Method in class org.apache.empire.commons.OptionEntry

setTime(Date, int, int, int, int) - Static method in class org.apache.empire.commons.DateUtils

setTimestampColumn(DBColumn) - Method in class org.apache.empire.db.DBRowSet

setTitle(String) - Method in class org.apache.empire.data.bean.BeanProperty

setTitle(String) - Method in class org.apache.empire.db.DBColumnExpr

Sets the title attribute.

setUseSequenceTable(boolean) - Method in class org.apache.empire.db.derby.DBDatabaseDriverDerby

If set to true a special table is used for sequence number generation.
Otherwise the AutoIncrement feature of Derby is used identiy fields.

setUseSequenceTable(boolean) - Method in class org.apache.empire.db.h2.DBDatabaseDriverH2

If set to true a special table is used for sequence number generation.
Otherwise the AutoIncrement feature of H2 is used identiy fields.

setUseSequenceTable(boolean) - Method in class org.apache.empire.db.mysql.DBDatabaseDriverMySQL

If set to true a special table is used for sequence number generation.
Otherwise the AutoIncrement feature of MySQL is used identity fields.

setUseSequenceTable(boolean) - Method in class org.apache.empire.db.sqlserver.DBDatabaseDriverMSSQL

If set to true a special table is used for sequence number generation.
Otherwise the AutoIncrement feature of MySQL is used identiy fields.

setUseUnicodePrefix(boolean) - Method in class org.apache.empire.db.sqlserver.DBDatabaseDriverMSSQL

Sets whether or not to use a Unicode Prefix (N) for all text values Default is true

setValidateFieldValues(boolean) - Method in class org.apache.empire.db.DBRecord

Set whether or not values are checked for validity when calling setValue().

setValue(Object) - Method in class org.apache.empire.commons.Attributes.Attribute

setValue(Column, Object) - Method in class org.apache.empire.data.bean.BeanRecordProxy

sets the value of a field.

setValue(int, Object) - Method in class org.apache.empire.data.bean.BeanRecordProxy

sets the value of a field.

setValue(int, Object) - Method in interface org.apache.empire.data.Record

sets a record value based on the field index.

setValue(Column, Object) - Method in interface org.apache.empire.data.Record

sets a record value based on a column.

setValue(Object) - Method in class org.apache.empire.db.DBCmdParam

Sets the current value of the parameter

setValue(int, Object) - Method in class org.apache.empire.db.DBRecord

Sets the value of the column in the record.

setValue(Column, Object) - Method in class org.apache.empire.db.DBRecord

Sets the value of the column in the record.

setValue(Object) - Method in class org.apache.empire.db.expr.compare.DBCompareColExpr

The value to compare the column expression with

setValue(Object) - Method in class org.apache.empire.db.expr.set.DBSetExpr

The value to which to set the column

setXmlWriterDebugPath(String) - Static method in class org.apache.empire.xml.XMLWriter

size() - Method in class org.apache.empire.commons.Attributes

size() - Method in class org.apache.empire.commons.Options

size - Variable in class org.apache.empire.db.DBTableColumn

skip - Variable in class org.apache.empire.db.mysql.DBDatabaseDriverMySQL.DBCommandMySQL

skip - Variable in class org.apache.empire.db.postgresql.DBDatabaseDriverPostgreSQL.DBCommandPostreSQL

skipRows(int) - Method in class org.apache.empire.db.DBCommandExpr

sets the offset of the first row to return when executing a query command.

skipRows(int) - Method in class org.apache.empire.db.DBReader

Moves the cursor down the given number of rows.

skipRows(int) - Method in class org.apache.empire.db.mysql.DBDatabaseDriverMySQL.DBCommandMySQL

skipRows(int) - Method in class org.apache.empire.db.postgresql.DBDatabaseDriverPostgreSQL.DBCommandPostreSQL

SMALLINT - Static variable in class org.apache.empire.db.DBTable

sortAttributes(NamedNodeMap) - Method in class org.apache.empire.xml.XMLWriter

Sorts attributes by name.

SQL_BOOLEAN_FALSE - Static variable in class org.apache.empire.db.DBDatabaseDriver

SQL_BOOLEAN_TRUE - Static variable in class org.apache.empire.db.DBDatabaseDriver

SQL_CONCAT_EXPR - Static variable in class org.apache.empire.db.DBDatabaseDriver

SQL_CURRENT_DATE - Static variable in class org.apache.empire.db.DBDatabaseDriver

SQL_CURRENT_DATETIME - Static variable in class org.apache.empire.db.DBDatabaseDriver

SQL_DATABASE_LINK - Static variable in class org.apache.empire.db.DBDatabaseDriver

SQL_DATE_PATTERN - Static variable in class org.apache.empire.db.DBDatabaseDriver

SQL_DATE_TEMPLATE - Static variable in class org.apache.empire.db.DBDatabaseDriver

SQL_DATETIME_PATTERN - Static variable in class org.apache.empire.db.DBDatabaseDriver

SQL_DATETIME_TEMPLATE - Static variable in class org.apache.empire.db.DBDatabaseDriver

SQL_FUNC_ABS - Static variable in class org.apache.empire.db.DBDatabaseDriver

SQL_FUNC_AVG - Static variable in class org.apache.empire.db.DBDatabaseDriver

SQL_FUNC_CEILING - Static variable in class org.apache.empire.db.DBDatabaseDriver

SQL_FUNC_COALESCE - Static variable in class org.apache.empire.db.DBDatabaseDriver

SQL_FUNC_DAY - Static variable in class org.apache.empire.db.DBDatabaseDriver

SQL_FUNC_DECODE - Static variable in class org.apache.empire.db.DBDatabaseDriver

SQL_FUNC_DECODE_ELSE - Static variable in class org.apache.empire.db.DBDatabaseDriver

SQL_FUNC_DECODE_PART - Static variable in class org.apache.empire.db.DBDatabaseDriver

SQL_FUNC_DECODE_SEP - Static variable in class org.apache.empire.db.DBDatabaseDriver

SQL_FUNC_ESCAPE - Static variable in class org.apache.empire.db.DBDatabaseDriver

SQL_FUNC_FLOOR - Static variable in class org.apache.empire.db.DBDatabaseDriver

SQL_FUNC_LENGTH - Static variable in class org.apache.empire.db.DBDatabaseDriver

SQL_FUNC_LOWER - Static variable in class org.apache.empire.db.DBDatabaseDriver

SQL_FUNC_LTRIM - Static variable in class org.apache.empire.db.DBDatabaseDriver

SQL_FUNC_MAX - Static variable in class org.apache.empire.db.DBDatabaseDriver

SQL_FUNC_MIN - Static variable in class org.apache.empire.db.DBDatabaseDriver

SQL_FUNC_MONTH - Static variable in class org.apache.empire.db.DBDatabaseDriver

SQL_FUNC_REPLACE - Static variable in class org.apache.empire.db.DBDatabaseDriver

SQL_FUNC_REVERSE - Static variable in class org.apache.empire.db.DBDatabaseDriver

SQL_FUNC_ROUND - Static variable in class org.apache.empire.db.DBDatabaseDriver

SQL_FUNC_RTRIM - Static variable in class org.apache.empire.db.DBDatabaseDriver

SQL_FUNC_STRINDEX - Static variable in class org.apache.empire.db.DBDatabaseDriver

SQL_FUNC_STRINDEXFROM - Static variable in class org.apache.empire.db.DBDatabaseDriver

SQL_FUNC_SUBSTRING - Static variable in class org.apache.empire.db.DBDatabaseDriver

SQL_FUNC_SUBSTRINGEX - Static variable in class org.apache.empire.db.DBDatabaseDriver

SQL_FUNC_SUM - Static variable in class org.apache.empire.db.DBDatabaseDriver

SQL_FUNC_TRIM - Static variable in class org.apache.empire.db.DBDatabaseDriver

SQL_FUNC_TRUNC - Static variable in class org.apache.empire.db.DBDatabaseDriver

SQL_FUNC_UPPER - Static variable in class org.apache.empire.db.DBDatabaseDriver

SQL_FUNC_YEAR - Static variable in class org.apache.empire.db.DBDatabaseDriver

SQL_NULL_VALUE - Static variable in class org.apache.empire.db.DBDatabaseDriver

SQL_PARAMETER - Static variable in class org.apache.empire.db.DBDatabaseDriver

SQL_QUOTES_CLOSE - Static variable in class org.apache.empire.db.DBDatabaseDriver

SQL_QUOTES_OPEN - Static variable in class org.apache.empire.db.DBDatabaseDriver

SQL_RENAME_COLUMN - Static variable in class org.apache.empire.db.DBDatabaseDriver

SQL_RENAME_TABLE - Static variable in class org.apache.empire.db.DBDatabaseDriver

sqlCmdList - Variable in class org.apache.empire.db.DBSQLScript

SQLiteDDLGenerator - Class in org.apache.empire.db.sqlite

SQLiteDDLGenerator(DBDatabaseDriverSQLite) - Constructor for class org.apache.empire.db.sqlite.SQLiteDDLGenerator

STANDARD - Static variable in class org.apache.empire.db.DBIndex

SQL Standard index

startWith - Variable in class org.apache.empire.db.oracle.DBCommandOracle

startWith(DBCompareExpr) - Method in class org.apache.empire.db.oracle.DBCommandOracle

StatementFailedException - Exception in org.apache.empire.db.exceptions

StatementFailedException(DBObject, String, SQLException) - Constructor for exception org.apache.empire.db.exceptions.StatementFailedException

stringToBoolean(String) - Method in class org.apache.empire.db.DBDatabaseDriver

this function converts a string containing a boolean expression to a boolean.

StringUtils - Class in org.apache.empire.commons

This class contains common functions for comparing and converting values of type String.

substring(DBExpr) - Method in class org.apache.empire.db.DBColumnExpr

Creates and returns a sql-expression for the substring(...) function.

substring(int) - Method in class org.apache.empire.db.DBColumnExpr

Overloaded.

substring(DBExpr, DBExpr) - Method in class org.apache.empire.db.DBColumnExpr

Creates and returns a sql-expression for the substring(...) function.

substring(DBExpr, int) - Method in class org.apache.empire.db.DBColumnExpr

Overloaded.

substring(int, DBExpr) - Method in class org.apache.empire.db.DBColumnExpr

Overloaded.

substring(int, int) - Method in class org.apache.empire.db.DBColumnExpr

Overloaded.

sum() - Method in class org.apache.empire.db.DBColumnExpr

Creates and returns an aggregation function object which calculates the sum for the current expression over a group of rows.

SYSDATE - Static variable in class org.apache.empire.db.DBDatabase

T

tables - Variable in class org.apache.empire.db.DBDatabase

TC - Variable in class org.apache.empire.db.oracle.OracleSYSDatabase

template - Variable in class org.apache.empire.db.expr.column.DBFuncExpr

timestampColumn - Variable in class org.apache.empire.db.DBRowSet

to(Object) - Method in class org.apache.empire.db.DBColumn

Creates and returns a new DBSetExpr object.

toArray() - Method in class org.apache.empire.commons.Attributes

toArray() - Method in class org.apache.empire.commons.Options

toChar() - Method in class org.apache.empire.db.DBColumnExpr

Creates a new DBFuncExpr object (to_char SQL statement) with the parameters prefix = "to_char(" and postfix = ")"

toChar(String) - Method in class org.apache.empire.db.DBColumnExpr

Creates a new DBFuncExpr object (to_char SQL statement) with the parameters prefix = "to_char(" and postfix = ", * '"+format+"')"

toDecimal(Object) - Static method in class org.apache.empire.commons.ObjectUtils

converts an object to a decimal.

toDouble(Object) - Static method in class org.apache.empire.commons.ObjectUtils

converts an object to a double.

toInteger(Object) - Static method in class org.apache.empire.commons.ObjectUtils

converts an object to an integer.

toLong(Object) - Static method in class org.apache.empire.commons.ObjectUtils

converts an object to a long.

toString() - Method in class org.apache.empire.commons.Attributes

toString() - Method in class org.apache.empire.commons.Options

toString(Object, String) - Static method in class org.apache.empire.commons.StringUtils

Converts a value to a string.

toString(Object) - Static method in class org.apache.empire.commons.StringUtils

Converts a value to a string.

toString(Object[], String) - Static method in class org.apache.empire.commons.StringUtils

Converts an array of objects to a string.

toString(Object[]) - Static method in class org.apache.empire.commons.StringUtils

Converts an array of objects to a string.

toString() - Method in class org.apache.empire.db.DBClobData

Returns a CLOB String.

toString() - Method in class org.apache.empire.db.DBColumn

Override the toString method.

toString() - Method in class org.apache.empire.db.DBDatabase.DBSystemDate

toString() - Method in class org.apache.empire.db.DBRelation

toString() - Method in class org.apache.empire.db.DBSQLScript

Returns the sql script as a string

toString() - Method in class org.apache.empire.db.expr.column.DBAliasExpr

Overrides the toString method.

toString() - Method in class org.apache.empire.db.expr.column.DBCalcExpr

toStringArray(Object[], String) - Static method in class org.apache.empire.commons.ObjectUtils

Converts an Object array to a String array.

trim() - Method in class org.apache.empire.db.DBColumnExpr

Creates and returns a sql-expression for the trim() function.

trimLeft() - Method in class org.apache.empire.db.DBColumnExpr

Creates and returns a sql-expression for the ltrim() function.

trimRight() - Method in class org.apache.empire.db.DBColumnExpr

Creates and returns a sql-expression for the rtrim() function.

trunc(int) - Method in class org.apache.empire.db.DBColumnExpr

Creates and returns an function object that truncates a number espression with the given decimals.

type - Variable in class org.apache.empire.db.DBCmdParam

type - Variable in class org.apache.empire.db.DBTableColumn

type - Variable in class org.apache.empire.db.expr.column.DBValueExpr

type - Variable in class org.apache.empire.db.expr.join.DBJoinExpr

U

UC - Variable in class org.apache.empire.db.oracle.OracleSYSDatabase

UnexpectedReturnValueException - Exception in org.apache.empire.exceptions

UnexpectedReturnValueException(Object, String) - Constructor for exception org.apache.empire.exceptions.UnexpectedReturnValueException

union(DBCommandExpr) - Method in class org.apache.empire.db.DBCommandExpr

Constructs a new DBCombinedCmd object with this object, the key word= "UNION" and the selected DBCommandExpr.

UNIQUE - Static variable in class org.apache.empire.db.DBIndex

SQL Unique index

update(Connection) - Method in class org.apache.empire.db.DBRecord

Updates the record and saves all changes in the database.

updateColumn - Variable in class org.apache.empire.db.DBView.DBViewColumn

updateColumn - Variable in class org.apache.empire.db.expr.column.DBAbstractFuncExpr

updateComplete(Object) - Method in class org.apache.empire.db.DBRecord

This method is used internally to indicate that the record update has completed
This will set change the record's state to Valid

updateRecord(DBRecord, Connection) - Method in class org.apache.empire.db.DBCommandExpr.DBCmdQuery

Returns the error message: ERR_NOTSUPPORTED

updateRecord(DBRecord, Connection) - Method in class org.apache.empire.db.DBQuery

Updates a query record by creating individual update commands for each table.

updateRecord(DBRecord, Connection) - Method in class org.apache.empire.db.DBRowSet

Updates or Inserts a record in the database.
Whether an update or insert is performed depends on the record state.
Only modified fields will be inserted or updated in the database.

updateRecord(DBRecord, Connection) - Method in class org.apache.empire.db.DBView

upper() - Method in class org.apache.empire.db.DBColumnExpr

Creates and returns a function object which converts the current expression to upper case.

useCmdParam(DBColumn, Object) - Method in class org.apache.empire.db.DBCommand

V

validate(String) - Static method in class org.apache.empire.commons.StringUtils

Validates a given string.

validate(Object) - Method in class org.apache.empire.data.bean.BeanProperty

validate(Object) - Method in interface org.apache.empire.data.Column

Checks if the given value is a valid value for this column If not, an exception is thrown

validate(Object) - Method in class org.apache.empire.db.DBColumn

Checks if the given value is a valid value for this column If not, an exception is thrown

validate(Object) - Method in class org.apache.empire.db.DBCommandExpr.DBCmdColumn

Not applicable - always return the value.

validate(Object) - Method in class org.apache.empire.db.DBQuery.DBQueryColumn

validate(Object) - Method in class org.apache.empire.db.DBTableColumn

Checks whether the supplied value is valid for this column.

validate(Object) - Method in class org.apache.empire.db.DBView.DBViewColumn

validateNumber(DataType, Number) - Method in class org.apache.empire.db.DBTableColumn

validateValue(Column, Object) - Method in class org.apache.empire.data.bean.BeanRecordProxy

Validates a value before it is set in the record.

validateValue(Column, Object) - Method in interface org.apache.empire.data.Record

Validates a value before it is set in the record.

validateValue(Column, Object) - Method in class org.apache.empire.db.DBRecord

Validates a value before it is set in the record.

value - Variable in class org.apache.empire.db.DBCmdParam

value - Variable in class org.apache.empire.db.expr.column.DBValueExpr

value - Variable in class org.apache.empire.db.expr.compare.DBCompareColExpr

value - Variable in class org.apache.empire.db.expr.set.DBSetExpr

valueOf(String) - Static method in enum org.apache.empire.commons.Options.InsertPos

Returns the enum constant of this type with the specified name.

valueOf(Object) - Static method in class org.apache.empire.commons.StringUtils

Converts a value to a string.

valueOf(Object[]) - Static method in class org.apache.empire.commons.StringUtils

Converts an objects to a string.

valueOf(String) - Static method in enum org.apache.empire.data.DataMode

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum org.apache.empire.data.DataType

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum org.apache.empire.db.DBCmdType

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum org.apache.empire.db.DBCmpType

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum org.apache.empire.db.DBDriverFeature

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum org.apache.empire.db.DBJoinType

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum org.apache.empire.db.DBRecord.State

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum org.apache.empire.db.DBRelation.DBCascadeAction

Returns the enum constant of this type with the specified name.

valueOf(String) - Static method in enum org.apache.empire.db.oracle.DBDatabaseDriverOracle.BooleanType

Returns the enum constant of this type with the specified name.

values() - Static method in enum org.apache.empire.commons.Options.InsertPos

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum org.apache.empire.data.DataMode

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum org.apache.empire.data.DataType

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum org.apache.empire.db.DBCmdType

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum org.apache.empire.db.DBCmpType

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum org.apache.empire.db.DBDriverFeature

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum org.apache.empire.db.DBJoinType

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum org.apache.empire.db.DBRecord.State

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum org.apache.empire.db.DBRelation.DBCascadeAction

Returns an array containing the constants of this enum type, in the order they are declared.

values() - Static method in enum org.apache.empire.db.oracle.DBDatabaseDriverOracle.BooleanType

Returns an array containing the constants of this enum type, in the order they are declared.

valueTooBigErrorType - Static variable in exception org.apache.empire.db.exceptions.FieldValueOutOfRangeException

valueTooSmallErrorType - Static variable in exception org.apache.empire.db.exceptions.FieldValueOutOfRangeException

views - Variable in class org.apache.empire.db.DBDatabase

W

wasModified(Column) - Method in class org.apache.empire.data.bean.BeanRecordProxy

Detects whether or not a particular field has been modified.

wasModified(Column) - Method in interface org.apache.empire.data.Record

checks whether or not the field for the given column has been modified since it has been loaded.

wasModified(int) - Method in class org.apache.empire.db.DBRecord

Returns true if the field was modified.

wasModified(Column) - Method in class org.apache.empire.db.DBRecord

Returns true if the field was modified.

when(DBCompareExpr, Object) - Method in class org.apache.empire.db.DBColumnExpr

Creates and returns a sql-expression for the SQL case-phrase.
The result will be in the form:
"case when [compExpr] then [this] else [otherwise] end"

where - Variable in class org.apache.empire.db.DBCommand

where(DBCompareExpr) - Method in class org.apache.empire.db.DBCommand

Adds a compare expression to the list of constraints.

where(DBCompareExpr) - Method in class org.apache.empire.db.expr.join.DBJoinExpr

This function adds an additional constraint to the join.

X

XMLConfiguration - Class in org.apache.empire.xml

This class manages the configuration of a Java Bean by an xml configuration file.

XMLConfiguration() - Constructor for class org.apache.empire.xml.XMLConfiguration

XMLUtil - Class in org.apache.empire.xml

This class provides a collection of static helper functions for common XML tasks.

XMLWriter - Class in org.apache.empire.xml

This class prints out a XML-DOM-Tree to an output stream.

XMLWriter(Writer, String) - Constructor for class org.apache.empire.xml.XMLWriter

Creates a XML Writer object.

XMLWriter(OutputStream, String) - Constructor for class org.apache.empire.xml.XMLWriter

Creates a XML Writer object.

XMLWriter(OutputStream) - Constructor for class org.apache.empire.xml.XMLWriter

Constructor

Y

year() - Method in class org.apache.empire.db.DBColumnExpr

Creates and returns an function object that calculates the year of a date value.

A B C D E F G H I J K L M N O P Q R S T U V W X Y