Package net.ontopia.persistence.query.sql

Class OracleSQLGenerator

java.lang.Object

net.ontopia.persistence.query.sql.GenericSQLGenerator

net.ontopia.persistence.query.sql.OracleSQLGenerator

All Implemented Interfaces:

SQLGeneratorIF

public class OracleSQLGenerator
extends GenericSQLGenerator

INTERNAL: Oracle SQL statement generator.

Field Summary

Fields inherited from class net.ontopia.persistence.query.sql.GenericSQLGenerator

AND, INIT_WIDTH_FROM, INIT_WIDTH_GROUP_BY, INIT_WIDTH_ORDER_BY, INIT_WIDTH_SELECT, INIT_WIDTH_SQL, INIT_WIDTH_WHERE, MAX_ELEMENTS_IN

Method Summary

Modifier and Type	Method	Description
protected StringBuilder	createOffsetLimitClause(int offset, int limit, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
SQLStatementIF	createSQLStatement(SQLQuery query)	INTERNAL: Create a concrete SQL statement from the given abstract SQL query.
protected String	createStatement(SQLExpressionIF filter, List selects, boolean distinct, int offset, int limit, List orderby, boolean issetquery, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected void	fromSQLLeftOuterJoin(SQLJoin join, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected void	fromSQLRightOuterJoin(SQLJoin join, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected String	getSetOperator(int operator)
boolean	supportsLimitOffset()	INTERNAL: Returns true if generator supports the functionality of OFFSET/LIMIT.
protected void	whereSQLFalse(SQLFalse expr, StringBuilder sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected void	whereSQLLeftOuterJoin(SQLJoin join, StringBuilder sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected void	whereSQLRightOuterJoin(SQLJoin join, StringBuilder sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

Methods inherited from class net.ontopia.persistence.query.sql.GenericSQLGenerator

analyzeExpression, analyzeExpressions, analyzeOrderBy, analyzeQuery, analyzeSelect, analyzeValue, atomicSQLValueIF, createFromClause, createGroupByClause, createOrderByClause, createSelectClause, createStatement, createStatement, createWhereClause, escapeString, flattenSQLValueIF, flattenSQLValueIF, fromSQLCrossJoin, fromSQLJoin, fromSQLJoin_GENERIC, fromSQLLeftOuterJoin, fromSQLRightOuterJoin, fromSQLTable, fromSubSelectAlias, getSQLGenerator, getSQLGenerator, isFromLevel, isPatternFunction, joinSQLValueIF, produceFrom, produceGroupBy, produceOrderBy, produceSelect, produceWhere, referenceSQLColumnsColumn, referenceSQLFunction, referenceSQLPrimitive, referenceSQLTableAndAlias, referenceSQLValueIFOpBinary, referenceSQLValueIFOpUnary, selectColumnAlias, selectColumnAlias, selectSQLAggregateIF, selectSQLColumns, selectSQLFunction, selectSQLNull, selectSQLPrimitive, selectSQLValueIF, selectSQLVerbatim, whereSQLAnd, whereSQLCrossJoin, whereSQLCrossJoin_GENERIC, whereSQLEquals, whereSQLExists, whereSQLExpressionIF, whereSQLExpressionIF, whereSQLIn, whereSQLIsNull, whereSQLJoin, whereSQLLeftOuterJoin_GENERIC, whereSQLLeftOuterJoin_ORACLE, whereSQLLike, whereSQLNot, whereSQLNotEquals, whereSQLOr, whereSQLRightOuterJoin_GENERIC, whereSQLRightOuterJoin_ORACLE, whereSQLSetOperation, whereSQLValueEqualsNull, whereSQLValueExpression, whereSQLValueNotEqualsNull, whereSQLVerbatimExpression

Methods inherited from class java.lang.Object

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

Method Details

createSQLStatement

public SQLStatementIF createSQLStatement(SQLQuery query)

Description copied from interface: SQLGeneratorIF

INTERNAL: Create a concrete SQL statement from the given abstract SQL query.

Specified by:

createSQLStatement in interface SQLGeneratorIF

Overrides:

createSQLStatement in class GenericSQLGenerator

createStatement

protected String createStatement(SQLExpressionIF filter,
 List selects,
 boolean distinct,
 int offset,
 int limit,
 List orderby,
 boolean issetquery,
 net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

Overrides:

createStatement in class GenericSQLGenerator

fromSQLLeftOuterJoin

protected void fromSQLLeftOuterJoin(SQLJoin join,
 net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

fromSQLRightOuterJoin

protected void fromSQLRightOuterJoin(SQLJoin join,
 net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

whereSQLLeftOuterJoin

protected void whereSQLLeftOuterJoin(SQLJoin join,
 StringBuilder sql,
 net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

Overrides:

whereSQLLeftOuterJoin in class GenericSQLGenerator

whereSQLRightOuterJoin

protected void whereSQLRightOuterJoin(SQLJoin join,
 StringBuilder sql,
 net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

Overrides:

whereSQLRightOuterJoin in class GenericSQLGenerator

getSetOperator

protected String getSetOperator(int operator)

Overrides:

getSetOperator in class GenericSQLGenerator

createOffsetLimitClause

protected StringBuilder createOffsetLimitClause(int offset,
 int limit,
 net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

Overrides:

createOffsetLimitClause in class GenericSQLGenerator

supportsLimitOffset

public boolean supportsLimitOffset()

Description copied from interface: SQLGeneratorIF

INTERNAL: Returns true if generator supports the functionality of OFFSET/LIMIT.

Specified by:

supportsLimitOffset in interface SQLGeneratorIF

Overrides:

supportsLimitOffset in class GenericSQLGenerator

whereSQLFalse

protected void whereSQLFalse(SQLFalse expr,
 StringBuilder sql,
 net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

Overrides:

whereSQLFalse in class GenericSQLGenerator