Package org.apache.empire.dbms.oracle

Class DBCommandOracle

java.lang.Object

org.apache.empire.db.DBObject

org.apache.empire.db.DBExpr

org.apache.empire.db.DBCommandExpr

org.apache.empire.db.DBCommand

org.apache.empire.dbms.oracle.DBCommandOracle

All Implemented Interfaces:

Cloneable

public class DBCommandOracle
extends DBCommand

This class handles the special features of an oracle database.

Nested Class Summary

Nested classes/interfaces inherited from class org.apache.empire.db.DBCommandExpr

DBCommandExpr.DBCmdColumn, DBCommandExpr.DBCmdQuery

Field Summary

Fields

Modifier and Type	Field	Description
protected DBCompareExpr	connectBy
protected int	limitRows
protected String	optimizerHint
protected int	skipRows
protected DBCompareExpr	startWith

Fields inherited from class org.apache.empire.db.DBCommand

autoPrepareStmt, cmdParams, groupBy, having, joins, log, parentTables, select, selectDistinct, set, where

Fields inherited from class org.apache.empire.db.DBCommandExpr

cmdQuery, orderBy, SF_DEFAULT, SF_SKIP_FROM, SF_SKIP_GROUP, SF_SKIP_LIMIT, SF_SKIP_ORDER, SF_SKIP_SELECT, SF_SKIP_WHERE

Fields inherited from class org.apache.empire.db.DBExpr

CTX_ALIAS, CTX_ALL, CTX_DEFAULT, CTX_FULLNAME, CTX_NAME, CTX_NOPARENTHESIS, CTX_VALUE

Constructor Summary

Constructors

Constructor	Description
DBCommandOracle(DBMSHandlerOracle dbms, boolean autoPrepareStmt)	Constructs an oracle command object.

Method Summary

Modifier and Type	Method	Description
protected void	addDeleteForTable(DBSQLBuilder sql, DBRowSet table)
protected void	addDeleteWithJoins(DBSQLBuilder sql, DBRowSet table)
protected void	addUpdateForTable(DBSQLBuilder sql, DBRowSet table)
protected void	addUpdateWithJoins(DBSQLBuilder sql, DBRowSet table)
void	clear()	Clears the entire command object.
void	clearConnectBy()	Clears the connectBy Expression.
void	clearLimit()	Clears a limit or offset set by calling limit() or offset()
void	connectByPrior(DBCompareExpr expr)
String	getOptimizerHint()
DBCmdParams	getParams()
Object[]	getParamValues()	Returns an array of parameter values for a prepared statement.
void	getSelect(DBSQLBuilder sql, int flags)	Creates an Oracle specific select statement that supports special features of the Oracle DBMS like e.g.
DBCommandOracle	limitRows(int limitRows)	Overridden to change return type from DBCommandExpr to DBCommand
void	setOptimizerHint(String optimizerHint)
void	setOptimizerIndexHint(DBIndex index)
DBCommandOracle	skipRows(int skipRows)	Overridden to change return type from DBCommandExpr to DBCommand
void	startWith(DBCompareExpr expr)

Methods inherited from class org.apache.empire.db.DBCommand

addFrom, addGrouping, addJoins, addKeyConstraints, addOrder, addParam, addParam, addParam, addParam, addReferencedColumns, addSelect, addWhere, addWhere, addWhereConstraints, appendCompareColExprs, clearGroupBy, clearHaving, clearJoin, clearSelect, clearSelectDistinct, clearSet, clearWhere, clone, completeParamUsage, createSQLBuilder, findConstraintOn, getDatabase, getDataType, getDelete, getGroupBy, getHavingConstraints, getInsert, getJoins, getRowSetList, getSelectExpressions, getSelectExprList, getSetExpressions, getUpdate, getWhereConstraints, groupAll, groupBy, groupBy, groupBy, hasAggegation, hasConstraintOn, hasGroupBy, hasHavingConstraintOn, hasHavingConstraints, hasJoinOn, hasJoinOn, hasSelectExpr, hasSelectExpr, hasSetExpr, hasSetExprOn, hasWhereConstraintOn, hasWhereConstraints, having, isAutoPrepareStmt, isPreparedStatementsEnabled, isSelectDistinct, isValid, join, join, join, join, join, join, join, join, joinLeft, joinLeft, joinRight, joinRight, orderBy, orderBy, orderBy, orderByUpper, orderByUpper, qualifyAll, removeAllCommandParams, removeCommandParams, removeConstraint, removeConstraintOn, removeHavingConstraint, removeHavingConstraintOn, removeJoinsOn, removeJoinsOn, removeSelect, removeWhereConstraint, removeWhereConstraintOn, replaceSelect, resetParamUsage, select, select, select, selectDistinct, selectQualified, selectQualified, selectSetExpressions, selectSetExpressions, set, set, setConstraint, setParentTables, useCmdParam, where, where

Methods inherited from class org.apache.empire.db.DBCommandExpr

addListExpr, addSQL, clearOrderBy, getCmdColumn, getDbms, getInsertInto, getInsertInto, getInsertInto, getOrderBy, getSelect, getSelect, hasOrderBy, intersect, not, notEmpty, result, union, unionAll

Methods inherited from class org.apache.empire.db.DBObject

checkParamNull

Methods inherited from class java.lang.Object

equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Details

connectBy

protected DBCompareExpr connectBy

startWith

protected DBCompareExpr startWith

optimizerHint

protected String optimizerHint

limitRows

protected int limitRows

skipRows

protected int skipRows

Constructor Details

DBCommandOracle

public DBCommandOracle(DBMSHandlerOracle dbms,
 boolean autoPrepareStmt)

Constructs an oracle command object.

Parameters:

dbms - the oracle database handler

autoPrepareStmt - flag whether to automatically use prepared statements

See Also:

• DBCommand

Method Details

getOptimizerHint

public String getOptimizerHint()

setOptimizerHint

public void setOptimizerHint(String optimizerHint)

setOptimizerIndexHint

public void setOptimizerIndexHint(DBIndex index)

clear

public void clear()

Description copied from class: DBCommand

Clears the entire command object.

Overrides:

clear in class DBCommand

See Also:

• DBCommand.clear()

clearConnectBy

public void clearConnectBy()

Clears the connectBy Expression.

connectByPrior

public void connectByPrior(DBCompareExpr expr)

startWith

public void startWith(DBCompareExpr expr)

limitRows

public DBCommandOracle limitRows(int limitRows)

Description copied from class: DBCommand

Overridden to change return type from DBCommandExpr to DBCommand

Overrides:

limitRows in class DBCommand

Parameters:

limitRows - the number of rows to limit

Returns:

itself (this)

skipRows

public DBCommandOracle skipRows(int skipRows)

Description copied from class: DBCommand

Overridden to change return type from DBCommandExpr to DBCommand

Overrides:

skipRows in class DBCommand

Parameters:

skipRows - the number of rows to skip

Returns:

itself (this)

clearLimit

public void clearLimit()

Description copied from class: DBCommandExpr

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

Overrides:

clearLimit in class DBCommandExpr

getSelect

public void getSelect(DBSQLBuilder sql,
 int flags)

Creates an Oracle specific select statement that supports special features of the Oracle DBMS like e.g. CONNECT BY PRIOR

Overrides:

getSelect in class DBCommand

Parameters:

sql - the SQL statement

flags - bitwise context flags for sql building (see "Select Context Flags")

getParams

public DBCmdParams getParams()

Overrides:

getParams in class DBCommand

getParamValues

public Object[] getParamValues()

Description copied from class: DBCommand

Returns an array of parameter values for a prepared statement. The parameters are supplied only after getSelect(), getUpdate(), getInsert() or getDelete() have been called

Overrides:

getParamValues in class DBCommand

Returns:

an array of parameter values for a prepared statement

addUpdateForTable

protected void addUpdateForTable(DBSQLBuilder sql,
 DBRowSet table)

Overrides:

addUpdateForTable in class DBCommand

addUpdateWithJoins

protected void addUpdateWithJoins(DBSQLBuilder sql,
 DBRowSet table)

Overrides:

addUpdateWithJoins in class DBCommand

addDeleteForTable

protected void addDeleteForTable(DBSQLBuilder sql,
 DBRowSet table)

Overrides:

addDeleteForTable in class DBCommand

addDeleteWithJoins

protected void addDeleteWithJoins(DBSQLBuilder sql,
 DBRowSet table)

Overrides:

addDeleteWithJoins in class DBCommand