org.apache.empire.db.oracle
Class DBCommandOracle

java.lang.Object
  extended by org.apache.empire.commons.ErrorObject
      extended by org.apache.empire.db.DBObject
          extended by org.apache.empire.db.DBExpr
              extended by org.apache.empire.db.DBCommandExpr
                  extended by org.apache.empire.db.DBCommand
                      extended by org.apache.empire.db.oracle.DBCommandOracle
All Implemented Interfaces:
java.lang.Cloneable, ErrorInfo

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.DBCommand
DBCommand.DBCmdParameter
 
Nested classes/interfaces inherited from class org.apache.empire.db.DBCommandExpr
DBCommandExpr.DBCmdColumn, DBCommandExpr.DBCmdQuery, DBCommandExpr.DBOrderByInfo
 
Nested classes/interfaces inherited from class org.apache.empire.commons.ErrorObject
ErrorObject.ObjectErrorInfo
 
Field Summary
protected  DBCompareExpr connectBy
           
protected  java.lang.String optimizerHint
           
protected  DBCompareExpr startWith
           
 
Fields inherited from class org.apache.empire.db.DBCommand
cmdParams, groupBy, having, joins, 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, log
 
Constructor Summary
DBCommandOracle(DBDatabase db)
          Constructs an oracle command object.
 
Method Summary
 void clear()
          Clears the entire command object.
 void clearConnectBy()
          Clears the connectBy Expression.
 void connectByPrior(DBCompareExpr expr)
           
 java.lang.String getDelete(DBTable table)
          Creates the delete SQL-Command.
 java.lang.String getOptimizerHint()
           
 boolean getSelect(java.lang.StringBuilder buf)
          Creates the SQL statement the special characteristics of the Oracle database are supported.
 void setOptimizerHint(java.lang.String optimizerHint)
           
 void startWith(DBCompareExpr expr)
           
 
Methods inherited from class org.apache.empire.db.DBCommand
addCmdParam, addFrom, addGrouping, addJoins, addOrder, addReferencedColumns, addSelect, addWhere, addWhereConstraints, clearGroupBy, clearHaving, clearJoin, clearSelect, clearSelectDistinct, clearSet, clearWhere, clone, getCmdParams, getDatabase, getInsert, getJoins, getSelectExprList, getTableList, getUpdate, getWhereConstraints, groupBy, groupBy, hasJoinOn, hasSelectExpr, hasWhereConstraints, having, isSelectDistinct, isValid, isValidQuery, isValidUpdate, join, join, join, join, join, select, select, select, selectDistinct, set, setCmdParam, where
 
Methods inherited from class org.apache.empire.db.DBCommandExpr
addListExpr, addSQL, clearOrderBy, getCmdColumn, getCmdColumn, getInsertInto, getInsertInto, getInsertInto, getSelect, intersect, orderBy, orderBy, union
 
Methods inherited from class org.apache.empire.db.DBExpr
getObjectValue, getValueClass
 
Methods inherited from class org.apache.empire.db.DBObject
error, error
 
Methods inherited from class org.apache.empire.commons.ErrorObject
clearError, clearErrorInfo, error, error, error, error, error, error, error, getErrorInfo, getErrorMessage, getErrorParams, getErrorSource, getErrorType, getMessage, hasError, internalSetError, isExceptionsEnabled, setExceptionsEnabled, success
 
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 java.lang.String optimizerHint
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 java.lang.String getOptimizerHint()

setOptimizerHint

public void setOptimizerHint(java.lang.String optimizerHint)

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)

getSelect

public boolean getSelect(java.lang.StringBuilder buf)
Creates the SQL statement the special characteristics of the Oracle database are supported.

Overrides:
getSelect in class DBCommand
Parameters:
buf - the SQL statment
Returns:
true if the creation was successful

getDelete

public java.lang.String getDelete(DBTable table)
Creates the delete SQL-Command.

Overrides:
getDelete in class DBCommand
Parameters:
table - the table object
Returns:
the delete SQL-Command


Copyright © 2008-2009 Apache Software Foundation. All Rights Reserved.