org.jpox.store.rdbms.query
Class OracleQueryStatement

java.lang.Object
  extended byorg.jpox.store.query.QueryStatement
      extended byorg.jpox.store.rdbms.query.OracleQueryStatement
All Implemented Interfaces:
QueryExpression

public class OracleQueryStatement
extends QueryStatement

Representation of a Query Statement in Oracle.

Version:
$Revision: 1.20 $

Nested Class Summary
 
Nested classes inherited from class org.jpox.store.query.QueryStatement
QueryStatement.Join
 
Field Summary
protected static Localiser LOCALISER_RDBMS
          Localisation for messages.
static java.lang.String NLS_SORT_ORDER_PROPERTY
          The system property that selects the "linguistic definition" to be used for native language sorting of String fields.
 
Fields inherited from class org.jpox.store.query.QueryStatement
crossJoins, dba, defaultRangeVar, distinctResults, groupingExpressions, hasAggregateExpression, havingExpr, initialTableExpr, isExistsSubQuery, joins, joinsTo, LOCALISER, orderingDirections, orderingExpressions, rangeCount, rangeOffset, selected, stmtJoinsSeparator, stmtText, storeMgr, tableExprsByRangeVar, union, useInnerJoinsOnly, whereExpr
 
Constructor Summary
OracleQueryStatement(DatastoreContainerObject initialTable, ClassLoaderResolver clr)
          QueryStatement constructor
OracleQueryStatement(DatastoreContainerObject initialTable, DatastoreIdentifier initialRangeVar, ClassLoaderResolver clr)
          QueryStatement constructor
 
Method Summary
protected  StatementText generateOrderingStatement()
          Convenience method to generate the ordering statement to add to the overall query statement.
 void innerJoin(ScalarExpression expr, ScalarExpression expr2, LogicSetExpression tblExpr)
          Method to do an inner join to another table.
 void leftOuterJoin(ScalarExpression expr, ScalarExpression expr2, LogicSetExpression tblExpr)
          Method to do a left outer join to another table.
 void rightOuterJoin(ScalarExpression expr, ScalarExpression expr2, LogicSetExpression tblExpr)
          Method to do a right outer join to another table.
 
Methods inherited from class org.jpox.store.query.QueryStatement
addGroupingExpression, addOrderingColumnsToSelect, andCondition, andCondition, assertNotFrozen, crossJoin, getClassLoaderResolver, getDefaultTableExpression, getDistinctResults, getGroupingExpressions, getHavingExpression, getInitialTableExpr, getNumberOfScalarExpressions, getOrderingExpressions, getStoreManager, getTableExpression, getUseInnerJoinsOnly, hasCrossJoin, hasMetaDataExpression, innerJoin, innerJoin, iorCondition, iorCondition, join, join, leftOuterJoin, leftOuterJoin, newTableExpression, newTableExpression, reset, rightOuterJoin, rightOuterJoin, select, select, select, select, selectDatastoreIdentity, selectField, selectScalarExpression, selectScalarExpression, selectVersion, selectVersion, setDistinctResults, setExistsSubQuery, setHaving, setOrdering, setRangeConstraint, setUseInnerJoinsOnly, toDeleteStatementText, toStatementText, toString, toString, union
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
 

Field Detail

LOCALISER_RDBMS

protected static final Localiser LOCALISER_RDBMS
Localisation for messages.


NLS_SORT_ORDER_PROPERTY

public static final java.lang.String NLS_SORT_ORDER_PROPERTY
The system property that selects the "linguistic definition" to be used for native language sorting of String fields. This is the string "org.jpox.oracle.nlsSortOrder". The default value is "LATIN". A value of "BINARY" disables native language sorting.

See Also:
Constant Field Values
Constructor Detail

OracleQueryStatement

public OracleQueryStatement(DatastoreContainerObject initialTable,
                            ClassLoaderResolver clr)
QueryStatement constructor

Parameters:
initialTable - The main table for this statement.
clr - ClassLoader resolver

OracleQueryStatement

public OracleQueryStatement(DatastoreContainerObject initialTable,
                            DatastoreIdentifier initialRangeVar,
                            ClassLoaderResolver clr)
QueryStatement constructor

Parameters:
initialTable - The main table for this statement.
initialRangeVar - The alias for the main table
clr - ClassLoader resolver
Method Detail

generateOrderingStatement

protected StatementText generateOrderingStatement()
Convenience method to generate the ordering statement to add to the overall query statement.

Overrides:
generateOrderingStatement in class QueryStatement
Returns:
The ordering statement

innerJoin

public void innerJoin(ScalarExpression expr,
                      ScalarExpression expr2,
                      LogicSetExpression tblExpr)
Method to do an inner join to another table. Requires ANSI-86 syntax, providing the table to the FROM clause and the join within the WHERE clause.

Parameters:
expr - the left hand expression
expr2 - the right hand expression
tblExpr - The table expression

leftOuterJoin

public void leftOuterJoin(ScalarExpression expr,
                          ScalarExpression expr2,
                          LogicSetExpression tblExpr)
Method to do a left outer join to another table. Requires ANSI-86 syntax, providing the table to the FROM clause and the join within the WHERE clause.

Parameters:
expr - the left hand expression
expr2 - the right hand expression
tblExpr - The table expression

rightOuterJoin

public void rightOuterJoin(ScalarExpression expr,
                           ScalarExpression expr2,
                           LogicSetExpression tblExpr)
Method to do a right outer join to another table. Requires ANSI-86 syntax, providing the table to the FROM clause and the join within the WHERE clause.

Parameters:
expr - the left hand expression
expr2 - the right hand expression
tblExpr - The table expression


Copyright © -2007 . All Rights Reserved.