net.ontopia.persistence.query.sql
Class GenericSQLGenerator

java.lang.Object
  net.ontopia.persistence.query.sql.GenericSQLGenerator

All Implemented Interfaces:

SQLGeneratorIF

Direct Known Subclasses:

MySQLGenerator, OracleSQLGenerator, PostgreSQLGenerator, SQLServerSQLGenerator

public class GenericSQLGenerator
extends java.lang.Object
implements SQLGeneratorIF

INTERNAL: Generic SQL statement generator.

Field Summary

protected static int	INIT_WIDTH_FROM
protected static int	INIT_WIDTH_GROUP_BY
protected static int	INIT_WIDTH_ORDER_BY
protected static int	INIT_WIDTH_SELECT
protected static int	INIT_WIDTH_SQL
protected static int	INIT_WIDTH_WHERE
protected int	MAX_ELEMENTS_IN

Method Summary

protected void	analyzeExpression(SQLExpressionIF expr, java.util.Map tlevels, java.lang.Integer level)
protected void	analyzeExpressions(SQLExpressionIF[] exprs, java.util.Map tlevels, java.lang.Integer level)
protected void	analyzeOrderBy(java.util.List orderby, java.util.Map tlevels, java.lang.Integer level)
protected void	analyzeQuery(SQLQuery sqlquery, java.util.Map tlevels, java.lang.Integer level)
protected void	analyzeSelect(java.util.List selects, java.util.Map tlevels, java.lang.Integer level)
protected void	analyzeValue(SQLValueIF value, java.util.Map tlevels, java.lang.Integer level)
protected void	atomicSQLValueIF(SQLValueIF value, java.lang.StringBuffer sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected java.lang.StringBuffer	createFromClause(SQLExpressionIF filter, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected java.lang.StringBuffer	createGroupByClause(net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected java.lang.StringBuffer	createOffsetLimitClause(int offset, int limit, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected java.lang.StringBuffer	createOrderByClause(java.util.List orderby, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected java.lang.StringBuffer	createSelectClause(java.util.List selects, boolean distinct, 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 java.lang.String	createStatement(SQLExpressionIF filter, java.util.List selects, boolean distinct, int offset, int limit, java.util.List orderby, boolean issetquery, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected java.lang.String	createStatement(SQLQuery query, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected java.lang.String	createStatement(java.lang.StringBuffer sql_select, java.lang.StringBuffer sql_where, java.lang.StringBuffer sql_from, java.lang.StringBuffer sql_group_by, java.lang.StringBuffer sql_order_by, java.lang.StringBuffer sql_offset_limit, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected java.lang.StringBuffer	createWhereClause(SQLExpressionIF filter, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected void	escapeString(java.lang.String value, java.lang.StringBuffer sql)
protected int	flattenSQLValueIF(SQLValueIF[] values, SQLValueIF[] flatlist, int pos)
protected int	flattenSQLValueIF(SQLValueIF value, SQLValueIF[] flatlist, int pos)
protected void	fromSQLCrossJoin(SQLJoin join, java.lang.StringBuffer sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected void	fromSQLJoin_GENERIC(SQLJoin join, java.lang.String jointype, java.lang.StringBuffer sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected void	fromSQLJoin(SQLJoin join, java.lang.StringBuffer sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected void	fromSQLLeftOuterJoin(SQLJoin join, java.lang.StringBuffer sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected void	fromSQLRightOuterJoin(SQLJoin join, java.lang.StringBuffer sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected void	fromSQLTable(SQLTable table, java.lang.StringBuffer sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected void	fromSubSelectAlias(java.lang.StringBuffer sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected java.lang.String	getSetOperator(int operator)
static SQLGeneratorIF	getSQLGenerator(java.lang.String[] platforms, java.util.Map properties)
static SQLGeneratorIF	getSQLGenerator(java.lang.String platform, java.util.Map properties)
protected boolean	isFromLevel(SQLTable tbl, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected boolean	isPatternFunction(SQLFunction func)
protected void	joinSQLValueIF(SQLValueIF value, java.lang.String separator, java.lang.StringBuffer sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected void	produceFrom(java.lang.StringBuffer sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected void	produceGroupBy(java.lang.StringBuffer sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected void	produceOrderBy(java.util.List orderby, java.lang.StringBuffer sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected void	produceSelect(java.util.List selects, boolean distinct, java.lang.StringBuffer sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected void	produceWhere(SQLExpressionIF filter, java.lang.StringBuffer sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected void	referenceSQLColumnsColumn(SQLTable table, java.lang.String column, java.lang.StringBuffer sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected void	referenceSQLFunction(SQLFunction func, java.lang.StringBuffer sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected void	referenceSQLPrimitive(SQLPrimitive primitive, java.lang.StringBuffer sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected void	referenceSQLTableAndAlias(SQLTable table, java.lang.StringBuffer sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected void	referenceSQLValueIFOpBinary(SQLValueIF value1, java.lang.String operator, SQLValueIF value2, java.lang.StringBuffer sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected void	referenceSQLValueIFOpUnary(SQLValueIF value, java.lang.String operator, java.lang.StringBuffer sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected void	selectColumnAlias(SQLAggregateIF aggregate, java.lang.StringBuffer sql)
protected void	selectColumnAlias(SQLValueIF value, java.lang.StringBuffer sql)
protected void	selectSQLAggregateIF(SQLAggregateIF aggregate, boolean register, java.lang.StringBuffer sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected void	selectSQLColumns(SQLColumns columns, SQLValueIF refvalue, boolean register, java.lang.StringBuffer sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info, boolean nonagg)
protected void	selectSQLFunction(SQLFunction value, SQLValueIF refvalue, boolean register, java.lang.StringBuffer sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected void	selectSQLNull(SQLNull value, SQLValueIF refvalue, boolean register, java.lang.StringBuffer sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected void	selectSQLPrimitive(SQLPrimitive value, SQLValueIF refvalue, boolean register, java.lang.StringBuffer sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected void	selectSQLValueIF(SQLValueIF value, boolean register, java.lang.StringBuffer sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected void	selectSQLVerbatim(SQLVerbatim value, SQLValueIF refvalue, boolean register, java.lang.StringBuffer sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
boolean	supportsLimitOffset() INTERNAL: Returns true if generator supports the functionality of OFFSET/LIMIT.
protected void	whereSQLAnd(SQLAnd and, java.lang.StringBuffer sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected void	whereSQLCrossJoin_GENERIC(SQLJoin join, java.lang.StringBuffer sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected void	whereSQLCrossJoin(SQLJoin join, java.lang.StringBuffer sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected void	whereSQLEquals(SQLEquals equals, java.lang.StringBuffer sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected void	whereSQLExists(SQLExists exists, java.lang.StringBuffer sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo pinfo)
protected void	whereSQLExpressionIF(SQLExpressionIF[] nexprs, java.lang.String separator, java.lang.StringBuffer sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected void	whereSQLExpressionIF(SQLExpressionIF expr, java.lang.StringBuffer sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected void	whereSQLFalse(SQLFalse expr, java.lang.StringBuffer sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected void	whereSQLIn(SQLIn in, java.lang.StringBuffer sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected void	whereSQLIsNull(SQLIsNull is_null, java.lang.StringBuffer sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected void	whereSQLJoin(SQLJoin join, java.lang.StringBuffer sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected void	whereSQLLeftOuterJoin_GENERIC(SQLJoin join, java.lang.StringBuffer sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected void	whereSQLLeftOuterJoin_ORACLE(SQLJoin join, java.lang.StringBuffer sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected void	whereSQLLeftOuterJoin(SQLJoin join, java.lang.StringBuffer sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected void	whereSQLLike(SQLLike like, java.lang.StringBuffer sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected void	whereSQLNot(SQLNot not, java.lang.StringBuffer sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected void	whereSQLNotEquals(SQLNotEquals nequals, java.lang.StringBuffer sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected void	whereSQLOr(SQLOr or, java.lang.StringBuffer sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected void	whereSQLRightOuterJoin_GENERIC(SQLJoin join, java.lang.StringBuffer sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected void	whereSQLRightOuterJoin_ORACLE(SQLJoin join, java.lang.StringBuffer sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected void	whereSQLRightOuterJoin(SQLJoin join, java.lang.StringBuffer sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected void	whereSQLSetOperation(SQLSetOperation setop, java.lang.StringBuffer sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected void	whereSQLValueEqualsNull(SQLValueIF value, java.lang.StringBuffer sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected void	whereSQLValueExpression(SQLValueExpression expr, java.lang.StringBuffer sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected void	whereSQLValueNotEqualsNull(SQLValueIF value, java.lang.StringBuffer sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)
protected void	whereSQLVerbatimExpression(SQLVerbatimExpression expr, java.lang.StringBuffer sql, net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

Methods inherited from class java.lang.Object

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

Field Detail

INIT_WIDTH_SELECT

protected static final int INIT_WIDTH_SELECT

See Also:

Constant Field Values

INIT_WIDTH_FROM

protected static final int INIT_WIDTH_FROM

See Also:

Constant Field Values

INIT_WIDTH_WHERE

protected static final int INIT_WIDTH_WHERE

See Also:

Constant Field Values

INIT_WIDTH_GROUP_BY

protected static final int INIT_WIDTH_GROUP_BY

See Also:

Constant Field Values

INIT_WIDTH_ORDER_BY

protected static final int INIT_WIDTH_ORDER_BY

See Also:

Constant Field Values

INIT_WIDTH_SQL

protected static final int INIT_WIDTH_SQL

See Also:

Constant Field Values

MAX_ELEMENTS_IN

protected int MAX_ELEMENTS_IN

Method Detail

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

createStatement

protected java.lang.String createStatement(SQLQuery query,
                                           net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

createStatement

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

createSelectClause

protected java.lang.StringBuffer createSelectClause(java.util.List selects,
                                                    boolean distinct,
                                                    net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

createWhereClause

protected java.lang.StringBuffer createWhereClause(SQLExpressionIF filter,
                                                   net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

createFromClause

protected java.lang.StringBuffer createFromClause(SQLExpressionIF filter,
                                                  net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

createGroupByClause

protected java.lang.StringBuffer createGroupByClause(net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

createOrderByClause

protected java.lang.StringBuffer createOrderByClause(java.util.List orderby,
                                                     net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

createOffsetLimitClause

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

createStatement

protected java.lang.String createStatement(java.lang.StringBuffer sql_select,
                                           java.lang.StringBuffer sql_where,
                                           java.lang.StringBuffer sql_from,
                                           java.lang.StringBuffer sql_group_by,
                                           java.lang.StringBuffer sql_order_by,
                                           java.lang.StringBuffer sql_offset_limit,
                                           net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

analyzeQuery

protected void analyzeQuery(SQLQuery sqlquery,
                            java.util.Map tlevels,
                            java.lang.Integer level)

analyzeSelect

protected void analyzeSelect(java.util.List selects,
                             java.util.Map tlevels,
                             java.lang.Integer level)

analyzeOrderBy

protected void analyzeOrderBy(java.util.List orderby,
                              java.util.Map tlevels,
                              java.lang.Integer level)

analyzeExpression

protected void analyzeExpression(SQLExpressionIF expr,
                                 java.util.Map tlevels,
                                 java.lang.Integer level)

analyzeExpressions

protected void analyzeExpressions(SQLExpressionIF[] exprs,
                                  java.util.Map tlevels,
                                  java.lang.Integer level)

analyzeValue

protected void analyzeValue(SQLValueIF value,
                            java.util.Map tlevels,
                            java.lang.Integer level)

produceSelect

protected void produceSelect(java.util.List selects,
                             boolean distinct,
                             java.lang.StringBuffer sql,
                             net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

produceGroupBy

protected void produceGroupBy(java.lang.StringBuffer sql,
                              net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

produceOrderBy

protected void produceOrderBy(java.util.List orderby,
                              java.lang.StringBuffer sql,
                              net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

isFromLevel

protected boolean isFromLevel(SQLTable tbl,
                              net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

produceFrom

protected void produceFrom(java.lang.StringBuffer sql,
                           net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

fromSubSelectAlias

protected void fromSubSelectAlias(java.lang.StringBuffer sql,
                                  net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

produceWhere

protected void produceWhere(SQLExpressionIF filter,
                            java.lang.StringBuffer sql,
                            net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

selectSQLAggregateIF

protected void selectSQLAggregateIF(SQLAggregateIF aggregate,
                                    boolean register,
                                    java.lang.StringBuffer sql,
                                    net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

selectColumnAlias

protected void selectColumnAlias(SQLAggregateIF aggregate,
                                 java.lang.StringBuffer sql)

selectColumnAlias

protected void selectColumnAlias(SQLValueIF value,
                                 java.lang.StringBuffer sql)

selectSQLValueIF

protected void selectSQLValueIF(SQLValueIF value,
                                boolean register,
                                java.lang.StringBuffer sql,
                                net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

selectSQLColumns

protected void selectSQLColumns(SQLColumns columns,
                                SQLValueIF refvalue,
                                boolean register,
                                java.lang.StringBuffer sql,
                                net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info,
                                boolean nonagg)

selectSQLPrimitive

protected void selectSQLPrimitive(SQLPrimitive value,
                                  SQLValueIF refvalue,
                                  boolean register,
                                  java.lang.StringBuffer sql,
                                  net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

selectSQLNull

protected void selectSQLNull(SQLNull value,
                             SQLValueIF refvalue,
                             boolean register,
                             java.lang.StringBuffer sql,
                             net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

selectSQLVerbatim

protected void selectSQLVerbatim(SQLVerbatim value,
                                 SQLValueIF refvalue,
                                 boolean register,
                                 java.lang.StringBuffer sql,
                                 net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

selectSQLFunction

protected void selectSQLFunction(SQLFunction value,
                                 SQLValueIF refvalue,
                                 boolean register,
                                 java.lang.StringBuffer sql,
                                 net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

fromSQLTable

protected void fromSQLTable(SQLTable table,
                            java.lang.StringBuffer sql,
                            net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

fromSQLJoin

protected void fromSQLJoin(SQLJoin join,
                           java.lang.StringBuffer sql,
                           net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

fromSQLCrossJoin

protected void fromSQLCrossJoin(SQLJoin join,
                                java.lang.StringBuffer sql,
                                net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

fromSQLLeftOuterJoin

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

fromSQLRightOuterJoin

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

fromSQLJoin_GENERIC

protected void fromSQLJoin_GENERIC(SQLJoin join,
                                   java.lang.String jointype,
                                   java.lang.StringBuffer sql,
                                   net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

whereSQLExpressionIF

protected void whereSQLExpressionIF(SQLExpressionIF expr,
                                    java.lang.StringBuffer sql,
                                    net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

whereSQLExpressionIF

protected void whereSQLExpressionIF(SQLExpressionIF[] nexprs,
                                    java.lang.String separator,
                                    java.lang.StringBuffer sql,
                                    net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

whereSQLAnd

protected void whereSQLAnd(SQLAnd and,
                           java.lang.StringBuffer sql,
                           net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

whereSQLOr

protected void whereSQLOr(SQLOr or,
                          java.lang.StringBuffer sql,
                          net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

whereSQLNot

protected void whereSQLNot(SQLNot not,
                           java.lang.StringBuffer sql,
                           net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

whereSQLFalse

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

whereSQLEquals

protected void whereSQLEquals(SQLEquals equals,
                              java.lang.StringBuffer sql,
                              net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

whereSQLNotEquals

protected void whereSQLNotEquals(SQLNotEquals nequals,
                                 java.lang.StringBuffer sql,
                                 net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

whereSQLValueEqualsNull

protected void whereSQLValueEqualsNull(SQLValueIF value,
                                       java.lang.StringBuffer sql,
                                       net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

whereSQLValueNotEqualsNull

protected void whereSQLValueNotEqualsNull(SQLValueIF value,
                                          java.lang.StringBuffer sql,
                                          net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

whereSQLIsNull

protected void whereSQLIsNull(SQLIsNull is_null,
                              java.lang.StringBuffer sql,
                              net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

whereSQLLike

protected void whereSQLLike(SQLLike like,
                            java.lang.StringBuffer sql,
                            net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

isPatternFunction

protected boolean isPatternFunction(SQLFunction func)

referenceSQLFunction

protected void referenceSQLFunction(SQLFunction func,
                                    java.lang.StringBuffer sql,
                                    net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

whereSQLVerbatimExpression

protected void whereSQLVerbatimExpression(SQLVerbatimExpression expr,
                                          java.lang.StringBuffer sql,
                                          net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

whereSQLValueExpression

protected void whereSQLValueExpression(SQLValueExpression expr,
                                       java.lang.StringBuffer sql,
                                       net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

whereSQLExists

protected void whereSQLExists(SQLExists exists,
                              java.lang.StringBuffer sql,
                              net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo pinfo)

whereSQLIn

protected void whereSQLIn(SQLIn in,
                          java.lang.StringBuffer sql,
                          net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

getSetOperator

protected java.lang.String getSetOperator(int operator)

whereSQLSetOperation

protected void whereSQLSetOperation(SQLSetOperation setop,
                                    java.lang.StringBuffer sql,
                                    net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

whereSQLJoin

protected void whereSQLJoin(SQLJoin join,
                            java.lang.StringBuffer sql,
                            net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

whereSQLCrossJoin

protected void whereSQLCrossJoin(SQLJoin join,
                                 java.lang.StringBuffer sql,
                                 net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

whereSQLCrossJoin_GENERIC

protected void whereSQLCrossJoin_GENERIC(SQLJoin join,
                                         java.lang.StringBuffer sql,
                                         net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

whereSQLLeftOuterJoin

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

whereSQLLeftOuterJoin_GENERIC

protected void whereSQLLeftOuterJoin_GENERIC(SQLJoin join,
                                             java.lang.StringBuffer sql,
                                             net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

whereSQLLeftOuterJoin_ORACLE

protected void whereSQLLeftOuterJoin_ORACLE(SQLJoin join,
                                            java.lang.StringBuffer sql,
                                            net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

whereSQLRightOuterJoin

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

whereSQLRightOuterJoin_GENERIC

protected void whereSQLRightOuterJoin_GENERIC(SQLJoin join,
                                              java.lang.StringBuffer sql,
                                              net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

whereSQLRightOuterJoin_ORACLE

protected void whereSQLRightOuterJoin_ORACLE(SQLJoin join,
                                             java.lang.StringBuffer sql,
                                             net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

referenceSQLValueIFOpUnary

protected void referenceSQLValueIFOpUnary(SQLValueIF value,
                                          java.lang.String operator,
                                          java.lang.StringBuffer sql,
                                          net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

referenceSQLValueIFOpBinary

protected void referenceSQLValueIFOpBinary(SQLValueIF value1,
                                           java.lang.String operator,
                                           SQLValueIF value2,
                                           java.lang.StringBuffer sql,
                                           net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

atomicSQLValueIF

protected void atomicSQLValueIF(SQLValueIF value,
                                java.lang.StringBuffer sql,
                                net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

escapeString

protected void escapeString(java.lang.String value,
                            java.lang.StringBuffer sql)

joinSQLValueIF

protected void joinSQLValueIF(SQLValueIF value,
                              java.lang.String separator,
                              java.lang.StringBuffer sql,
                              net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

flattenSQLValueIF

protected int flattenSQLValueIF(SQLValueIF[] values,
                                SQLValueIF[] flatlist,
                                int pos)

flattenSQLValueIF

protected int flattenSQLValueIF(SQLValueIF value,
                                SQLValueIF[] flatlist,
                                int pos)

referenceSQLPrimitive

protected void referenceSQLPrimitive(SQLPrimitive primitive,
                                     java.lang.StringBuffer sql,
                                     net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

referenceSQLTableAndAlias

protected void referenceSQLTableAndAlias(SQLTable table,
                                         java.lang.StringBuffer sql,
                                         net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

referenceSQLColumnsColumn

protected void referenceSQLColumnsColumn(SQLTable table,
                                         java.lang.String column,
                                         java.lang.StringBuffer sql,
                                         net.ontopia.persistence.query.sql.GenericSQLGenerator.BuildInfo info)

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

getSQLGenerator

public static SQLGeneratorIF getSQLGenerator(java.lang.String[] platforms,
                                             java.util.Map properties)

getSQLGenerator

public static SQLGeneratorIF getSQLGenerator(java.lang.String platform,
                                             java.util.Map properties)