Uses of Class
org.apache.openjpa.jdbc.sql.SQLBuffer

Packages that use SQLBuffer

org.apache.openjpa.jdbc.kernel.exps	OpenJPA-JDBC Expression Tree
org.apache.openjpa.jdbc.meta	OpenJPA-JDBC ORM Metadata
org.apache.openjpa.jdbc.meta.strats	OpenJPA-JDBC ORM Strategies
org.apache.openjpa.jdbc.sql	OpenJPA-JDBC SQL Abstraction

Uses of SQLBuffer in org.apache.openjpa.jdbc.kernel.exps

Methods in org.apache.openjpa.jdbc.kernel.exps with parameters of type SQLBuffer

void	Args.appendIsEmpty(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql)
void	Val.appendIsEmpty(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql) Append the SQL testing whether this value is empty to the given buffer.
void	Args.appendIsNotEmpty(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql)
void	Val.appendIsNotEmpty(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql) Append the SQL testing whether this value is not empty to the given buffer.
void	Args.appendIsNotNull(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql)
void	Val.appendIsNotNull(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql) Append the SQL testing whether this value is not null to the given buffer.
void	Args.appendIsNull(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql)
void	Val.appendIsNull(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql) Append the SQL testing whether this value is null to the given buffer.
void	Args.appendSize(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql)
void	Val.appendSize(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql) Append the SQL checking the size of this value.
void	Args.appendTo(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql, int index)
void	Val.appendTo(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql, int index) Append the indexth SQL element to the given buffer.
void	FilterValue.appendTo(SQLBuffer buf) Append the first SQL element for this value to the given buffer.
void	JDBCAggregateListener.appendTo(SQLBuffer buf, FilterValue[] args, ClassMapping mapping, JDBCStore store) Append the SQL for this aggregate.
void	JDBCFilterListener.appendTo(SQLBuffer buf, FilterValue target, FilterValue[] args, ClassMapping mapping, JDBCStore store) Append the SQL for this expression or value.
void	GetColumn.appendTo(SQLBuffer buf, FilterValue target, FilterValue[] args, ClassMapping type, JDBCStore store)
void	JDBCWildcardMatch.appendTo(SQLBuffer sql, FilterValue target, FilterValue[] args, ClassMapping type, JDBCStore store) Deprecated.
void	JDBCStringContains.appendTo(SQLBuffer buf, FilterValue target, FilterValue[] args, ClassMapping type, JDBCStore store) Deprecated.
void	SQLEmbed.appendTo(SQLBuffer buf, FilterValue target, FilterValue[] args, ClassMapping type, JDBCStore store)
void	FilterValue.appendTo(SQLBuffer buf, int index) Append the indexth SQL element for this value to the given buffer.

Uses of SQLBuffer in org.apache.openjpa.jdbc.meta

Methods in org.apache.openjpa.jdbc.meta that return SQLBuffer

SQLBuffer	DiscriminatorStrategy.getClassConditions(Select sel, Joins joins, ClassMapping base, boolean subs) Return SQL to limit the classes selected as much as possible to the given base class, and optionally its subclasses.
SQLBuffer	Discriminator.getClassConditions(Select sel, Joins joins, ClassMapping base, boolean subs)

Methods in org.apache.openjpa.jdbc.meta with parameters of type SQLBuffer

void	FieldMapping.appendIsEmpty(SQLBuffer sql, Select sel, Joins joins)
void	FieldStrategy.appendIsEmpty(SQLBuffer sql, Select sel, Joins joins) Append a where clause to the given statement checking if this value is empty.
void	FieldMapping.appendIsNotEmpty(SQLBuffer sql, Select sel, Joins joins)
void	FieldStrategy.appendIsNotEmpty(SQLBuffer sql, Select sel, Joins joins) Append a where clause to the given statement checking if this value is not empty.
void	FieldMapping.appendIsNotNull(SQLBuffer sql, Select sel, Joins joins)
void	FieldStrategy.appendIsNotNull(SQLBuffer sql, Select sel, Joins joins) Append a where clause to the given statement checking if this value is not null.
void	FieldMapping.appendIsNull(SQLBuffer sql, Select sel, Joins joins)
void	FieldStrategy.appendIsNull(SQLBuffer sql, Select sel, Joins joins) Append a where clause to the given statement checking if this value is null.
void	FieldMapping.appendSize(SQLBuffer sql, Select sel, Joins joins)
void	FieldStrategy.appendSize(SQLBuffer sql, Select sel, Joins joins) Append a where clause to the given statement checking the size of the value.

Uses of SQLBuffer in org.apache.openjpa.jdbc.meta.strats

Methods in org.apache.openjpa.jdbc.meta.strats that return SQLBuffer

SQLBuffer	InValueDiscriminatorStrategy.getClassConditions(Select sel, Joins joins, ClassMapping base, boolean subclasses)
SQLBuffer	SubclassJoinDiscriminatorStrategy.getClassConditions(Select sel, Joins joins, ClassMapping base, boolean subclasses)
SQLBuffer	AbstractDiscriminatorStrategy.getClassConditions(Select sel, Joins joins, ClassMapping base, boolean subs)
SQLBuffer	SuperclassDiscriminatorStrategy.getClassConditions(Select sel, Joins joins, ClassMapping base, boolean subclasses)

Methods in org.apache.openjpa.jdbc.meta.strats with parameters of type SQLBuffer

void	AbstractFieldStrategy.appendIsEmpty(SQLBuffer sql, Select sel, Joins joins)
void	ContainerFieldStrategy.appendIsEmpty(SQLBuffer sql, Select sel, Joins joins)
void	AbstractFieldStrategy.appendIsNotEmpty(SQLBuffer sql, Select sel, Joins joins)
void	ContainerFieldStrategy.appendIsNotEmpty(SQLBuffer sql, Select sel, Joins joins)
void	HandlerFieldStrategy.appendIsNotNull(SQLBuffer sql, Select sel, Joins joins)
void	EmbedFieldStrategy.appendIsNotNull(SQLBuffer sql, Select sel, Joins joins)
void	AbstractFieldStrategy.appendIsNotNull(SQLBuffer sql, Select sel, Joins joins)
void	ContainerFieldStrategy.appendIsNotNull(SQLBuffer sql, Select sel, Joins joins)
void	StringFieldStrategy.appendIsNotNull(SQLBuffer sql, Select sel, Joins joins)
void	PrimitiveFieldStrategy.appendIsNotNull(SQLBuffer sql, Select sel, Joins joins)
void	RelationFieldStrategy.appendIsNotNull(SQLBuffer sql, Select sel, Joins joins)
void	HandlerFieldStrategy.appendIsNull(SQLBuffer sql, Select sel, Joins joins)
void	EmbedFieldStrategy.appendIsNull(SQLBuffer sql, Select sel, Joins joins)
void	AbstractFieldStrategy.appendIsNull(SQLBuffer sql, Select sel, Joins joins)
void	ContainerFieldStrategy.appendIsNull(SQLBuffer sql, Select sel, Joins joins)
void	StringFieldStrategy.appendIsNull(SQLBuffer sql, Select sel, Joins joins)
void	PrimitiveFieldStrategy.appendIsNull(SQLBuffer sql, Select sel, Joins joins)
void	RelationFieldStrategy.appendIsNull(SQLBuffer sql, Select sel, Joins joins)
protected static void	ContainerFieldStrategy.appendJoinCount(SQLBuffer sql, Select sel, Joins joins, DBDictionary dict, FieldMapping field, ForeignKey fk)
void	AbstractFieldStrategy.appendSize(SQLBuffer sql, Select sel, Joins joins)
void	ContainerFieldStrategy.appendSize(SQLBuffer sql, Select sel, Joins joins)
static void	ContainerFieldStrategy.appendUnaliasedJoin(SQLBuffer sql, Select sel, Joins joins, DBDictionary dict, FieldMapping field, ForeignKey fk)

Uses of SQLBuffer in org.apache.openjpa.jdbc.sql

Methods in org.apache.openjpa.jdbc.sql that return SQLBuffer

SQLBuffer	SQLBuffer.append(Column col)
SQLBuffer	SQLBuffer.append(Select sel, JDBCFetchConfiguration fetch) Append a subselect.
SQLBuffer	SQLBuffer.append(Sequence seq)
SQLBuffer	SQLBuffer.append(SQLBuffer buf) Append all SQL and parameters of the given buffer.
SQLBuffer	SQLBuffer.append(String s)
SQLBuffer	SQLBuffer.append(Table table)
SQLBuffer	SQLBuffer.appendCount(Select sel, JDBCFetchConfiguration fetch) Append a subselect count.
SQLBuffer	SQLBuffer.appendValue(boolean b) Append a parameter value.
SQLBuffer	SQLBuffer.appendValue(boolean b, Column col) Append a parameter value.
SQLBuffer	SQLBuffer.appendValue(byte b) Append a parameter value.
SQLBuffer	SQLBuffer.appendValue(byte b, Column col) Append a parameter value.
SQLBuffer	SQLBuffer.appendValue(char c) Append a parameter value.
SQLBuffer	SQLBuffer.appendValue(char c, Column col) Append a parameter value.
SQLBuffer	SQLBuffer.appendValue(double d) Append a parameter value.
SQLBuffer	SQLBuffer.appendValue(double d, Column col) Append a parameter value.
SQLBuffer	SQLBuffer.appendValue(float f) Append a parameter value.
SQLBuffer	SQLBuffer.appendValue(float f, Column col) Append a parameter value.
SQLBuffer	SQLBuffer.appendValue(int i) Append a parameter value.
SQLBuffer	SQLBuffer.appendValue(int i, Column col) Append a parameter value.
SQLBuffer	SQLBuffer.appendValue(long l) Append a parameter value.
SQLBuffer	SQLBuffer.appendValue(long l, Column col) Append a parameter value.
SQLBuffer	SQLBuffer.appendValue(Object o) Append a parameter value.
SQLBuffer	SQLBuffer.appendValue(Object o, Column col) Append a parameter value for a specific column.
SQLBuffer	SQLBuffer.appendValue(short s) Append a parameter value.
SQLBuffer	SQLBuffer.appendValue(short s, Column col) Append a parameter value.
protected SQLBuffer	DBDictionary.getFrom(Select sel, boolean forUpdate) Return the portion of the select statement between the FROM keyword and the WHERE keyword.
protected SQLBuffer	DBDictionary.getFromSelect(Select sel, boolean forUpdate) Return the FROM clause for a select that selects from a tmp table created by an inner select.
SQLBuffer	Select.getGrouping() Return the grouping SQL for this select.
SQLBuffer	LogicalUnion.UnionSelect.getGrouping()
SQLBuffer	SelectImpl.getGrouping()
SQLBuffer	Select.getHaving() Return the HAVING clause, or null if none.
SQLBuffer	LogicalUnion.UnionSelect.getHaving()
SQLBuffer	SelectImpl.getHaving()
SQLBuffer	Select.getOrdering() Return the ordering SQL for this select.
SQLBuffer	LogicalUnion.UnionSelect.getOrdering()
SQLBuffer	SelectImpl.getOrdering()
protected SQLBuffer	DBDictionary.getSelects(Select sel, boolean distinctIdentifiers, boolean forUpdate) Return the portion of the select statement between the SELECT keyword and the FROM keyword.
protected SQLBuffer	OracleDictionary.getSelects(Select sel, boolean distinctIdentifiers, boolean forUpdate)
SQLBuffer	Select.getWhere() Return the WHERE clause, minus any necessary end joins.
SQLBuffer	LogicalUnion.UnionSelect.getWhere()
SQLBuffer	SelectImpl.getWhere()
protected SQLBuffer	DBDictionary.getWhere(Select sel, boolean forUpdate) Return the WHERE portion of the select statement, or null if no where conditions.
protected SQLBuffer	DBDictionary.toBulkOperation(ClassMapping mapping, Select sel, JDBCStore store, Object[] params, Map updateParams) Returns the SQL for a bulk operation, either a DELETE or an UPDATE.
SQLBuffer	DBDictionary.toDelete(ClassMapping mapping, Select sel, Object[] params) Create a DELETE statement for the specified Select.
SQLBuffer	DBDictionary.toNativeJoin(Join join) Use the given join instance to create SQL joining its tables in the database's native syntax.
SQLBuffer	OracleDictionary.toNativeJoin(Join join)
protected SQLBuffer	DBDictionary.toOperation(String op, SQLBuffer selects, SQLBuffer from, SQLBuffer where, SQLBuffer group, SQLBuffer having, SQLBuffer order, boolean distinct, long start, long end, String forUpdateClause) Return the SQL for the given selecting operation.
protected SQLBuffer	HSQLDictionary.toOperation(String op, SQLBuffer selects, SQLBuffer from, SQLBuffer where, SQLBuffer group, SQLBuffer having, SQLBuffer order, boolean distinct, long start, long end, String forUpdateClause)
SQLBuffer	LogicalUnion.toSelect(boolean forUpdate, JDBCFetchConfiguration fetch)
SQLBuffer	LogicalUnion.UnionSelect.toSelect(boolean forUpdate, JDBCFetchConfiguration fetch)
SQLBuffer	SelectImpl.toSelect(boolean forUpdate, JDBCFetchConfiguration fetch)
SQLBuffer	SelectExecutor.toSelect(boolean forUpdate, JDBCFetchConfiguration fetch) Return this select as a SQL statement formatted for the current dictionary.
SQLBuffer	DB2Dictionary.toSelect(Select sel, boolean forUpdate, JDBCFetchConfiguration fetch)
SQLBuffer	DBDictionary.toSelect(Select sel, boolean forUpdate, JDBCFetchConfiguration fetch) Create a SELECT statement in the proper join syntax for the given instance.
SQLBuffer	EmpressDictionary.toSelect(SQLBuffer selects, JDBCFetchConfiguration fetch, SQLBuffer from, SQLBuffer where, SQLBuffer group, SQLBuffer having, SQLBuffer order, boolean distinct, boolean forUpdate, long startIdx, long endIdx)
SQLBuffer	DBDictionary.toSelect(SQLBuffer selects, JDBCFetchConfiguration fetch, SQLBuffer from, SQLBuffer where, SQLBuffer group, SQLBuffer having, SQLBuffer order, boolean distinct, boolean forUpdate, long start, long end) Combine the given components into a SELECT statement.
SQLBuffer	OracleDictionary.toSelect(SQLBuffer select, JDBCFetchConfiguration fetch, SQLBuffer tables, SQLBuffer where, SQLBuffer group, SQLBuffer having, SQLBuffer order, boolean distinct, boolean forUpdate, long start, long end)
SQLBuffer	LogicalUnion.toSelectCount()
SQLBuffer	LogicalUnion.UnionSelect.toSelectCount()
SQLBuffer	SelectImpl.toSelectCount()
SQLBuffer	SelectExecutor.toSelectCount() Return this select as a COUNT SQL statement formatted for the current dictionary.
SQLBuffer	DBDictionary.toSelectCount(Select sel) Create a SELECT COUNT statement in the proper join syntax for the given instance.
SQLBuffer	DBDictionary.toSQL92Join(Join join, boolean forUpdate, boolean first) Use the given join instance to create SQL joining its tables in the SQL92 style.
SQLBuffer	DBDictionary.toTraditionalJoin(Join join) Use the given join instance to create SQL joining its tables in the traditional style.
SQLBuffer	DBDictionary.toUpdate(ClassMapping mapping, Select sel, JDBCStore store, Object[] params, Map updates)

Methods in org.apache.openjpa.jdbc.sql with parameters of type SQLBuffer

SQLBuffer	SQLBuffer.append(SQLBuffer buf) Append all SQL and parameters of the given buffer.
void	Select.append(SQLBuffer buf, Joins joins) Append the given joins to the given buffer.
void	LogicalUnion.UnionSelect.append(SQLBuffer buf, Joins joins)
void	SelectImpl.append(SQLBuffer buf, Joins joins)
void	DBDictionary.appendCast(SQLBuffer buf, FilterValue val, int type) Cast the specified value to the specified type.
protected void	DBDictionary.appendNumericCast(SQLBuffer buf, FilterValue val) Append SQL for the given numeric value to the buffer, casting as needed.
protected void	DB2Dictionary.appendSelectRange(SQLBuffer buf, long start, long end)
protected void	DBDictionary.appendSelectRange(SQLBuffer buf, long start, long end) If this dictionary can select ranges, use this method to append the range SQL.
protected void	PostgresDictionary.appendSelectRange(SQLBuffer buf, long start, long end)
protected void	AbstractSQLServerDictionary.appendSelectRange(SQLBuffer buf, long start, long end)
protected void	H2Dictionary.appendSelectRange(SQLBuffer buf, long start, long end)
protected void	MySQLDictionary.appendSelectRange(SQLBuffer buf, long start, long end)
protected void	HSQLDictionary.appendSelectRange(SQLBuffer buf, long start, long end)
protected void	DBDictionary.appendUpdates(Select sel, JDBCStore store, SQLBuffer sql, Object[] params, Map updateParams, boolean allowAlias)
void	DBDictionary.comparison(SQLBuffer buf, String op, FilterValue lhs, FilterValue rhs) Append a comparison.
void	Select.groupBy(SQLBuffer sql) Add a GROUP BY clause.
void	LogicalUnion.UnionSelect.groupBy(SQLBuffer sql)
void	SelectImpl.groupBy(SQLBuffer sql)
void	Select.groupBy(SQLBuffer sql, Joins joins) Add a GROUP BY clause.
void	LogicalUnion.UnionSelect.groupBy(SQLBuffer sql, Joins joins)
void	SelectImpl.groupBy(SQLBuffer sql, Joins joins)
void	Select.having(SQLBuffer sql) Add the given having conditions.
void	LogicalUnion.UnionSelect.having(SQLBuffer sql)
void	SelectImpl.having(SQLBuffer sql)
void	Select.having(SQLBuffer sql, Joins joins) Add the given having conditions.
void	LogicalUnion.UnionSelect.having(SQLBuffer sql, Joins joins)
void	SelectImpl.having(SQLBuffer sql, Joins joins)
void	DBDictionary.indexOf(SQLBuffer buf, FilterValue str, FilterValue find, FilterValue start) Invoke this database's indexOf function.
void	PostgresDictionary.indexOf(SQLBuffer buf, FilterValue str, FilterValue find, FilterValue start)
void	AbstractSQLServerDictionary.indexOf(SQLBuffer buf, FilterValue str, FilterValue find, FilterValue start)
void	PointbaseDictionary.indexOf(SQLBuffer buf, FilterValue str, FilterValue find, FilterValue start)
void	H2Dictionary.indexOf(SQLBuffer buf, FilterValue str, FilterValue find, FilterValue start)
void	JDataStoreDictionary.indexOf(SQLBuffer buf, FilterValue str, FilterValue find, FilterValue start)
void	AbstractDB2Dictionary.indexOf(SQLBuffer buf, FilterValue str, FilterValue find, FilterValue start)
void	HSQLDictionary.indexOf(SQLBuffer buf, FilterValue str, FilterValue find, FilterValue start)
void	InterbaseDictionary.indexOf(SQLBuffer buf, FilterValue str, FilterValue find, FilterValue start)
void	DBDictionary.mathFunction(SQLBuffer buf, String op, FilterValue lhs, FilterValue rhs) Append the numeric parts of a mathematical function.
boolean	Select.orderBy(SQLBuffer sql, boolean asc, boolean sel) Add an ORDER BY clause.
boolean	LogicalUnion.UnionSelect.orderBy(SQLBuffer sql, boolean asc, boolean select)
boolean	SelectImpl.orderBy(SQLBuffer sql, boolean asc, boolean sel)
boolean	Select.orderBy(SQLBuffer sql, boolean asc, Joins joins, boolean sel) Add an ORDER BY clause.
boolean	LogicalUnion.UnionSelect.orderBy(SQLBuffer sql, boolean asc, Joins joins, boolean select)
boolean	SelectImpl.orderBy(SQLBuffer sql, boolean asc, Joins joins, boolean sel)
boolean	Select.select(SQLBuffer sql, Object id) Select the given SQL; the given id object is an identifier to use when retrieving the corresponding value from a Result.
boolean	LogicalUnion.UnionSelect.select(SQLBuffer sql, Object id)
boolean	SelectImpl.select(SQLBuffer sql, Object id)
boolean	Select.select(SQLBuffer sql, Object id, Joins joins) Select the given SQL; the given id object is an identifier to use when retrieving the corresponding value from a Result.
boolean	LogicalUnion.UnionSelect.select(SQLBuffer sql, Object id, Joins joins)
boolean	SelectImpl.select(SQLBuffer sql, Object id, Joins joins)
void	DBDictionary.substring(SQLBuffer buf, FilterValue str, FilterValue start, FilterValue end) Invoke this database's substring function.
void	AbstractSQLServerDictionary.substring(SQLBuffer buf, FilterValue str, FilterValue start, FilterValue end)
void	AccessDictionary.substring(SQLBuffer buf, FilterValue str, FilterValue start, FilterValue end)
void	OracleDictionary.substring(SQLBuffer buf, FilterValue str, FilterValue start, FilterValue end)
void	PointbaseDictionary.substring(SQLBuffer buf, FilterValue str, FilterValue start, FilterValue end)
void	H2Dictionary.substring(SQLBuffer buf, FilterValue str, FilterValue start, FilterValue end)
void	JDataStoreDictionary.substring(SQLBuffer buf, FilterValue str, FilterValue start, FilterValue end)
void	AbstractDB2Dictionary.substring(SQLBuffer buf, FilterValue str, FilterValue start, FilterValue end)
void	HSQLDictionary.substring(SQLBuffer buf, FilterValue str, FilterValue start, FilterValue end)
void	InterbaseDictionary.substring(SQLBuffer buf, FilterValue str, FilterValue start, FilterValue end)
void	FirebirdDictionary.substring(SQLBuffer buf, FilterValue str, FilterValue start, FilterValue end)
protected SQLBuffer	DBDictionary.toOperation(String op, SQLBuffer selects, SQLBuffer from, SQLBuffer where, SQLBuffer group, SQLBuffer having, SQLBuffer order, boolean distinct, long start, long end, String forUpdateClause) Return the SQL for the given selecting operation.
protected SQLBuffer	HSQLDictionary.toOperation(String op, SQLBuffer selects, SQLBuffer from, SQLBuffer where, SQLBuffer group, SQLBuffer having, SQLBuffer order, boolean distinct, long start, long end, String forUpdateClause)
SQLBuffer	EmpressDictionary.toSelect(SQLBuffer selects, JDBCFetchConfiguration fetch, SQLBuffer from, SQLBuffer where, SQLBuffer group, SQLBuffer having, SQLBuffer order, boolean distinct, boolean forUpdate, long startIdx, long endIdx)
SQLBuffer	DBDictionary.toSelect(SQLBuffer selects, JDBCFetchConfiguration fetch, SQLBuffer from, SQLBuffer where, SQLBuffer group, SQLBuffer having, SQLBuffer order, boolean distinct, boolean forUpdate, long start, long end) Combine the given components into a SELECT statement.
SQLBuffer	OracleDictionary.toSelect(SQLBuffer select, JDBCFetchConfiguration fetch, SQLBuffer tables, SQLBuffer where, SQLBuffer group, SQLBuffer having, SQLBuffer order, boolean distinct, boolean forUpdate, long start, long end)
void	Select.where(SQLBuffer sql) Add the given where conditions.
void	LogicalUnion.UnionSelect.where(SQLBuffer sql)
void	SelectImpl.where(SQLBuffer sql)
void	Select.where(SQLBuffer sql, Joins joins) Add the given where conditions.
void	LogicalUnion.UnionSelect.where(SQLBuffer sql, Joins joins)
void	SelectImpl.where(SQLBuffer sql, Joins joins)

Constructors in org.apache.openjpa.jdbc.sql with parameters of type SQLBuffer

SQLBuffer(SQLBuffer buf)
Copy constructor.