|
|||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectorg.jpox.store.query.QueryStatement
org.jpox.store.rdbms.query.OracleQueryStatement
Representation of a Query Statement in Oracle.
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 java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait |
Field Detail |
protected static final Localiser LOCALISER_RDBMS
public static final java.lang.String NLS_SORT_ORDER_PROPERTY
Constructor Detail |
public OracleQueryStatement(DatastoreContainerObject initialTable, ClassLoaderResolver clr)
initialTable
- The main table for this statement.clr
- ClassLoader resolverpublic OracleQueryStatement(DatastoreContainerObject initialTable, DatastoreIdentifier initialRangeVar, ClassLoaderResolver clr)
initialTable
- The main table for this statement.initialRangeVar
- The alias for the main tableclr
- ClassLoader resolverMethod Detail |
protected StatementText generateOrderingStatement()
generateOrderingStatement
in class QueryStatement
public void innerJoin(ScalarExpression expr, ScalarExpression expr2, LogicSetExpression tblExpr)
expr
- the left hand expressionexpr2
- the right hand expressiontblExpr
- The table expressionpublic void leftOuterJoin(ScalarExpression expr, ScalarExpression expr2, LogicSetExpression tblExpr)
expr
- the left hand expressionexpr2
- the right hand expressiontblExpr
- The table expressionpublic void rightOuterJoin(ScalarExpression expr, ScalarExpression expr2, LogicSetExpression tblExpr)
expr
- the left hand expressionexpr2
- the right hand expressiontblExpr
- The table expression
|
|||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |