org.jpox.store.rdbms.query
Class OracleQueryStatement

java.lang.Object
  org.jpox.store.query.QueryStatement
      org.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/interfaces 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