org.apache.empire.db.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.db.oracle.DBCommandOracle

All Implemented Interfaces:

Serializable, Cloneable

public class DBCommandOracle
extends DBCommand

This class handles the special features of an oracle database.

See Also:

Serialized Form

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 and 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

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

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

cmdQuery, orderBy

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

CTX_ALIAS, CTX_ALL, CTX_DEFAULT, CTX_FULLNAME, CTX_NAME, CTX_NOPARENTHESES, CTX_VALUE

Constructor Summary

Constructors

Constructor and Description
DBCommandOracle(DBDatabase db) Constructs an oracle command object.

Method Summary

Methods

Modifier and Type	Method and Description
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	getDelete(DBTable table) Creates an Oracle specific delete statement.
String	getOptimizerHint()
Object[]	getParamValues() Returns an array of parameter values for a prepared statement.
void	getSelect(StringBuilder buf) Creates an Oracle specific select statement that supports special features of the Oracle DBMS like e.g.
protected String	getSimpleUpdate()
String	getUpdate() Creates an Oracle specific update statement.
protected String	getUpdateWithJoins()
void	limitRows(int limitRows) set the maximum number of rows to return when executing a query command A negative value will remove the limit.
void	setOptimizerHint(String optimizerHint)
void	setOptimizerIndexHint(DBIndex index)
void	skipRows(int skipRows) sets the offset of the first row to return when executing a query command.
void	startWith(DBCompareExpr expr)

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

addFrom, addGrouping, addJoins, addOrder, addParam, addParam, addParam, addParam, addReferencedColumns, addSelect, addWhere, addWhere, addWhereConstraints, clearGroupBy, clearHaving, clearJoin, clearSelect, clearSelectDistinct, clearSet, clearWhere, clone, getDatabase, getInsert, getJoins, getRowSetList, getSelectExprList, getWhereConstraints, groupBy, hasConstraintOn, hasJoinOn, hasJoinOn, hasSelectExpr, hasSetExprOn, hasWhereConstraints, having, isPreparedStatementsEnabled, isSelectDistinct, isValid, isValidQuery, isValidUpdate, join, join, join, join, join, notifyParamUsage, removeConstraintOn, removeHavingConstraintOn, removeJoinsOn, removeJoinsOn, removeWhereConstraintOn, resetParamUsage, select, select, select, selectDistinct, set, setConstraint, useCmdParam, where

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

addListExpr, addSQL, clearOrderBy, getCmdColumn, getInsertInto, getInsertInto, getInsertInto, getSelect, intersect, orderBy, orderBy, orderBy, union

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

getObjectValue, getValueClass

Methods inherited from class java.lang.Object

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

Field Detail

connectBy

protected DBCompareExpr connectBy

startWith

protected DBCompareExpr startWith

optimizerHint

protected String optimizerHint

limitRows

protected int limitRows

skipRows

protected int skipRows

Constructor Detail

DBCommandOracle

public DBCommandOracle(DBDatabase db)

Constructs an oracle command object.

Parameters:

db - the oracle database object this command belongs to

See Also:

DBCommand

Method Detail

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 void limitRows(int limitRows)

Description copied from class: DBCommandExpr

set the maximum number of rows to return when executing a query command A negative value will remove the limit.

Overrides:

limitRows in class DBCommandExpr

skipRows

public void skipRows(int skipRows)

Description copied from class: DBCommandExpr

sets the offset of the first row to return when executing a query command. A negative value will remove the offset.

Overrides:

skipRows in class DBCommandExpr

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(StringBuilder buf)

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:

buf - the SQL statement

getParamValues

public Object[] getParamValues()

Description copied from class: DBCommand

Returns an array of parameter values for a prepared statement. To ensure that all values are in the order of their occurrence, getSelect() should be called first.

Overrides:

getParamValues in class DBCommand

Returns:

an array of parameter values for a prepared statement

getUpdate

public String getUpdate()

Creates an Oracle specific update statement. If a join is required, this method creates a "MERGE INTO" expression

Overrides:

getUpdate in class DBCommand

Returns:

the update SQL-Command

getSimpleUpdate

protected String getSimpleUpdate()

getUpdateWithJoins

protected String getUpdateWithJoins()

getDelete

public String getDelete(DBTable table)

Creates an Oracle specific delete statement.

Overrides:

getDelete in class DBCommand

Parameters:

table - the table object

Returns:

the delete SQL-Command