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

Packages that use SQLBuffer

Package	Description
org.apache.openjpa.jdbc.kernel	OpenJPA-JDBC Runtime Kernel Runtime services for the JDBC OpenJPA implementation.
org.apache.openjpa.jdbc.kernel.exps	OpenJPA-JDBC Expression Tree
org.apache.openjpa.jdbc.meta	OpenJPA-JDBC ORM Metadata This package extends the standard persistence metadata with object-relational mapping information.
org.apache.openjpa.jdbc.meta.strats	OpenJPA-JDBC ORM Strategies Library of mapping strategies.
org.apache.openjpa.jdbc.sql	OpenJPA-JDBC SQL Abstraction Utilities for generating SQL.

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

Methods in org.apache.openjpa.jdbc.kernel that return types with arguments of type SQLBuffer

Modifier and Type	Method and Description
protected List<SQLBuffer>	PessimisticLockManager.getLockRows(DBDictionary dict, Object id, ClassMapping mapping, JDBCFetchConfiguration fetch, SQLFactory factory)
protected List<SQLBuffer>	MixedLockManager.getLockRows(DBDictionary dict, Object id, ClassMapping mapping, JDBCFetchConfiguration fetch, SQLFactory factory)

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

Modifier and Type	Method and Description
protected ResultSet	PessimisticLockManager.executeQuery(Connection conn, PreparedStatement stmnt, SQLBuffer sql) This method is to provide override for non-JDBC or JDBC-like implementation of executing query.
protected ResultSet	TableJDBCSeq.executeQuery(JDBCConfiguration conf, Connection conn, PreparedStatement stmnt, SQLBuffer buf) This method is to provide override for non-JDBC or JDBC-like implementation of executing query.
protected ResultSet	SQLStoreQuery.SQLExecutor.executeQuery(JDBCStore store, Connection conn, PreparedStatement stmnt, SQLBuffer buf, List paramList) This method is to provide override for non-JDBC or JDBC-like implementation of executing query.
protected int	JDBCStoreQuery.executeUpdate(Connection conn, PreparedStatement stmnt, SQLBuffer sqlBuf, boolean isUpdate) This method is to provide override for non-JDBC or JDBC-like implementation of executing update.
protected int	TableJDBCSeq.executeUpdate(JDBCConfiguration conf, Connection conn, PreparedStatement stmnt, SQLBuffer buf, int opcode) This method is to provide override for non-JDBC or JDBC-like implementation of executing update.
protected int	SQLStoreQuery.SQLExecutor.executeUpdate(JDBCStore store, Connection conn, PreparedStatement stmnt, SQLBuffer buf) This method is to provide override for non-JDBC or JDBC-like implementation of executing update.
protected PreparedStatement	SQLStoreQuery.SQLExecutor.prepareCall(Connection conn, SQLBuffer buf) This method is to provide override for non-JDBC or JDBC-like implementation of preparing call statement.
protected PreparedStatement	SQLStoreQuery.SQLExecutor.prepareCall(Connection conn, SQLBuffer buf, JDBCFetchConfiguration fetch, int rsType, int rsConcur) This method is to provide override for non-JDBC or JDBC-like implementation of preparing call statement.
protected PreparedStatement	PessimisticLockManager.prepareStatement(Connection conn, SQLBuffer sql) This method is to provide override for non-JDBC or JDBC-like implementation of preparing statement.
protected PreparedStatement	SQLStoreQuery.SQLExecutor.prepareStatement(Connection conn, SQLBuffer buf) This method is to provide override for non-JDBC or JDBC-like implementation of preparing statement.
protected PreparedStatement	TableJDBCSeq.prepareStatement(Connection conn, SQLBuffer buf) This method is to provide override for non-JDBC or JDBC-like implementation of preparing statement.
protected PreparedStatement	JDBCStoreQuery.prepareStatement(Connection conn, SQLBuffer sql) This method is to provide override for non-JDBC or JDBC-like implementation of preparing statement.
protected PreparedStatement	SQLStoreQuery.SQLExecutor.prepareStatement(Connection conn, SQLBuffer buf, JDBCFetchConfiguration fetch, int rsType, int rsConcur) This method is to provide override for non-JDBC or JDBC-like implementation of preparing statement.

Method parameters in org.apache.openjpa.jdbc.kernel with type arguments of type SQLBuffer

Modifier and Type	Method and Description
protected void	PessimisticLockManager.lockJoinTables(List<SQLBuffer> sqls, DBDictionary dict, Object id, ClassMapping mapping, JDBCFetchConfiguration fetch, SQLFactory factory)

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

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

Modifier and Type	Method and Description
void	PCPath.appendIndex(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql)
void	Val.appendIndex(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql) Append the SQL checking the index of this value.
void	PCPath.appendIsEmpty(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql)
void	SubQ.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.appendIsEmpty(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql)
void	PCPath.appendIsNotEmpty(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql)
void	SubQ.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.appendIsNotEmpty(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql)
void	PCPath.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.appendIsNotNull(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql)
void	PCPath.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.appendIsNull(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql)
void	PCPath.appendSize(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql)
void	SubQ.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.appendSize(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql)
void	WhenScalar.appendTo(Select sel, ExpContext ctx, ExpState state, SQLBuffer buf)
void	PCPath.appendTo(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql)
void	WhenCondition.appendTo(Select sel, ExpContext ctx, ExpState state, SQLBuffer buf)
void	Trim.appendTo(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql, int index)
void	MapEntry.appendTo(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql, int index)
void	GeneralCaseExpression.appendTo(Select sel, ExpContext ctx, ExpState state, SQLBuffer buf, int index)
void	PCPath.appendTo(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql, int index)
void	Math.appendTo(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql, int index)
void	NullIfExpression.appendTo(Select sel, ExpContext ctx, ExpState state, SQLBuffer buf, int index)
void	CollectionParam.appendTo(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql, int index)
void	CoalesceExpression.appendTo(Select sel, ExpContext ctx, ExpState state, SQLBuffer buf, int index)
void	IndexOf.appendTo(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql, int index)
void	Lit.appendTo(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql, int index)
void	SubQ.appendTo(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql, int index)
void	ToLowerCase.appendTo(Select sel, ExpContext ctx, ExpState state, SQLBuffer buf, int index)
void	Null.appendTo(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql, int index)
void	TypeLit.appendTo(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql, int index)
void	Substring.appendTo(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql, int index)
void	ToUpperCase.appendTo(Select sel, ExpContext ctx, ExpState state, SQLBuffer buf, int index)
void	DatastoreFunction.appendTo(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql, int index)
void	StringLength.appendTo(Select sel, ExpContext ctx, ExpState state, SQLBuffer buf, 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	Concat.appendTo(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql, int index)
void	Param.appendTo(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql, int index)
void	SimpleCaseExpression.appendTo(Select sel, ExpContext ctx, ExpState state, SQLBuffer buf, int index)
void	MapKey.appendTo(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql, int index)
void	Args.appendTo(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql, int index)
void	Args.appendTo(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql, int index, String operator)
void	PCPath.appendTo(Select sel, ExpState state, SQLBuffer sql, Column col)
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	SQLEmbed.appendTo(SQLBuffer buf, FilterValue target, FilterValue[] args, ClassMapping type, JDBCStore store)
void	JDBCStringContains.appendTo(SQLBuffer buf, FilterValue target, FilterValue[] args, ClassMapping type, JDBCStore store) Deprecated.
void	JDBCWildcardMatch.appendTo(SQLBuffer sql, FilterValue target, FilterValue[] args, ClassMapping type, JDBCStore store) Deprecated.
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	FilterValue.appendTo(SQLBuffer buf, int index) Append the indexth SQL element for this value to the given buffer.
void	PCPath.appendType(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql)
void	Val.appendType(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql) Append the SQL checking the type of this value.

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

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

Modifier and Type	Method and Description
SQLBuffer	Discriminator.getClassConditions(Select sel, Joins joins, ClassMapping base, boolean subs)
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.

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

Modifier and Type	Method and Description
void	FieldMapping.appendIndex(SQLBuffer sql, Select sel, Joins joins)
void	FieldStrategy.appendIndex(SQLBuffer sql, Select sel, Joins joins) Append the ordered column alias to the given statement.
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.
void	FieldMapping.appendType(SQLBuffer sql, Select sel, Joins joins)
void	FieldStrategy.appendType(SQLBuffer sql, Select sel, Joins joins) Append the entity discriminator value to the given statement.

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

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

Modifier and Type	Method and Description
SQLBuffer	SubclassJoinDiscriminatorStrategy.getClassConditions(Select sel, Joins joins, ClassMapping base, boolean subclasses)
SQLBuffer	InValueDiscriminatorStrategy.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

Modifier and Type	Method and Description
void	ContainerFieldStrategy.appendIndex(SQLBuffer sql, Select sel, Joins joins)
void	AbstractFieldStrategy.appendIndex(SQLBuffer sql, Select sel, Joins joins)
void	ContainerFieldStrategy.appendIsEmpty(SQLBuffer sql, Select sel, Joins joins)
void	AbstractFieldStrategy.appendIsEmpty(SQLBuffer sql, Select sel, Joins joins)
void	ContainerFieldStrategy.appendIsNotEmpty(SQLBuffer sql, Select sel, Joins joins)
void	AbstractFieldStrategy.appendIsNotEmpty(SQLBuffer sql, Select sel, Joins joins)
void	PrimitiveFieldStrategy.appendIsNotNull(SQLBuffer sql, Select sel, Joins joins)
void	EmbedFieldStrategy.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	AbstractFieldStrategy.appendIsNotNull(SQLBuffer sql, Select sel, Joins joins)
void	RelationFieldStrategy.appendIsNotNull(SQLBuffer sql, Select sel, Joins joins)
void	HandlerFieldStrategy.appendIsNotNull(SQLBuffer sql, Select sel, Joins joins)
void	PrimitiveFieldStrategy.appendIsNull(SQLBuffer sql, Select sel, Joins joins)
void	EmbedFieldStrategy.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	AbstractFieldStrategy.appendIsNull(SQLBuffer sql, Select sel, Joins joins)
void	RelationFieldStrategy.appendIsNull(SQLBuffer sql, Select sel, Joins joins)
void	HandlerFieldStrategy.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	ContainerFieldStrategy.appendSize(SQLBuffer sql, Select sel, Joins joins)
void	AbstractFieldStrategy.appendSize(SQLBuffer sql, Select sel, Joins joins)
void	AbstractFieldStrategy.appendType(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

Modifier and Type	Method and Description
SQLBuffer	SQLBuffer.append(Column col)
SQLBuffer	SQLBuffer.append(DBIdentifier name)
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.appendParamOnly(SQLBuffer buf) Append parameters only if the given buffer at the given positions.
SQLBuffer	SQLBuffer.appendValue(Object o) Append a parameter value.
SQLBuffer	SQLBuffer.appendValue(Object o, Column col) Append a system inserted parameter value for a specific column.
SQLBuffer	SQLBuffer.appendValue(Object o, Column col, Parameter userParam) Append a user parameter value for a specific column.
SQLBuffer	SQLBuffer.appendValue(Object o, Column col, Parameter userParam, boolean useParamToken)
protected SQLBuffer	DBDictionary.getDeleteTargets(Select sel)
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	LogicalUnion.UnionSelect.getGrouping()
SQLBuffer	Select.getGrouping() Return the grouping SQL for this select.
SQLBuffer	SelectImpl.getGrouping()
SQLBuffer	LogicalUnion.UnionSelect.getHaving()
SQLBuffer	Select.getHaving() Return the HAVING clause, or null if none.
SQLBuffer	SelectImpl.getHaving()
SQLBuffer	LogicalUnion.UnionSelect.getOrdering()
SQLBuffer	Select.getOrdering() Return the ordering SQL for this select.
SQLBuffer	SelectImpl.getOrdering()
protected SQLBuffer	OracleDictionary.getSelects(Select sel, boolean distinctIdentifiers, boolean forUpdate)
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.
SQLBuffer	LogicalUnion.getSQL()
SQLBuffer	LogicalUnion.UnionSelect.getSQL()
SQLBuffer	SelectExecutor.getSQL() Get the buffer if it has been computed by a previous call to SelectExecutor.toSelect(boolean, JDBCFetchConfiguration), if any.
SQLBuffer	SelectImpl.getSQL()
SQLBuffer	LogicalUnion.UnionSelect.getWhere()
SQLBuffer	Select.getWhere() Return the WHERE clause, minus any necessary end joins.
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	OracleDictionary.toNativeJoin(Join join)
SQLBuffer	DBDictionary.toNativeJoin(Join join) Use the given join instance to create SQL joining its tables in the database's native syntax.
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	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.
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, boolean subselect) Return the SQL for the given selecting operation.
SQLBuffer	LogicalUnion.toSelect(boolean forUpdate, JDBCFetchConfiguration fetch)
SQLBuffer	LogicalUnion.UnionSelect.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	SelectImpl.toSelect(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	DBDictionary.toSelect(SQLBuffer selects, JDBCFetchConfiguration fetch, SQLBuffer from, SQLBuffer where, SQLBuffer group, SQLBuffer having, SQLBuffer order, boolean distinct, boolean forUpdate, long start, long end, boolean subselect, boolean checkTableForUpdate)
protected 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, boolean subselect, Select sel)
protected 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, boolean subselect, Select sel) Combine the given components into a SELECT statement.
protected 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, Select sel)
protected 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, Select sel) Combine the given components into a SELECT statement.
protected SQLBuffer	DB2Dictionary.toSelect(SQLBuffer select, JDBCFetchConfiguration fetch, SQLBuffer tables, SQLBuffer where, SQLBuffer group, SQLBuffer having, SQLBuffer order, boolean distinct, boolean forUpdate, long start, long end, Select sel)
SQLBuffer	LogicalUnion.toSelectCount()
SQLBuffer	LogicalUnion.UnionSelect.toSelectCount()
SQLBuffer	SelectExecutor.toSelectCount() Return this select as a COUNT SQL statement formatted for the current dictionary.
SQLBuffer	SelectImpl.toSelectCount()
SQLBuffer	DBDictionary.toSelectCount(Select sel) Create a SELECT COUNT statement in the proper join syntax for the given instance.
SQLBuffer	DBDictionary.toSQL92Join(Select sel, 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

Modifier and Type	Method and Description
SQLBuffer	SQLBuffer.append(SQLBuffer buf) Append all SQL and parameters of the given buffer.
void	LogicalUnion.UnionSelect.append(SQLBuffer buf, Joins joins)
void	Select.append(SQLBuffer buf, Joins joins) Append the given joins to the given buffer.
void	SelectImpl.append(SQLBuffer buf, Joins joins)
void	DB2Dictionary.appendCast(SQLBuffer buf, FilterValue val, int type) Cast the specified value to the specified type.
void	DBDictionary.appendCast(SQLBuffer buf, Object val, int type) Cast the specified value to the specified type.
protected void	SQLServerDictionary.appendLength(SQLBuffer buf, int type)
protected void	DBDictionary.appendLength(SQLBuffer buf, int type)
protected void	DB2Dictionary.appendLength(SQLBuffer buf, int type)
protected void	DBDictionary.appendNumericCast(SQLBuffer buf, FilterValue val) Append SQL for the given numeric value to the buffer, casting as needed.
SQLBuffer	SQLBuffer.appendParamOnly(SQLBuffer buf) Append parameters only if the given buffer at the given positions.
protected void	SolidDBDictionary.appendSelect(SQLBuffer selectSQL, Object alias, Select sel, int idx)
protected void	DBDictionary.appendSelect(SQLBuffer selectSQL, Object elem, Select sel, int idx) Append elem to selectSQL.
protected void	DB2Dictionary.appendSelect(SQLBuffer selectSQL, Object alias, Select sel, int idx)
protected void	IngresDictionary.appendSelectRange(SQLBuffer buf, long start, long end, boolean subselect) Implementation of appendSelectRange for Ingres - uses "SELECT FIRST n" syntax.
protected void	H2Dictionary.appendSelectRange(SQLBuffer buf, long start, long end, boolean subselect)
protected void	SQLServerDictionary.appendSelectRange(SQLBuffer buf, long start, long end, boolean subselect)
protected void	FirebirdDictionary.appendSelectRange(SQLBuffer buf, long start, long end, boolean subselect) Use either FIRST <p> SKIP <q> or ROWS <m> TO <n> syntax.
protected void	AbstractSQLServerDictionary.appendSelectRange(SQLBuffer buf, long start, long end, boolean subselect)
protected void	PostgresDictionary.appendSelectRange(SQLBuffer buf, long start, long end, boolean subselect)
protected void	MySQLDictionary.appendSelectRange(SQLBuffer buf, long start, long end, boolean subselect)
protected void	MariaDBDictionary.appendSelectRange(SQLBuffer buf, long start, long end, boolean subselect)
protected void	HSQLDictionary.appendSelectRange(SQLBuffer buf, long start, long end, boolean subselect)
protected void	DBDictionary.appendSelectRange(SQLBuffer buf, long start, long end, boolean subselect) If this dictionary can select ranges, use this method to append the range SQL.
protected void	DB2Dictionary.appendSelectRange(SQLBuffer buf, long start, long end, boolean subselect)
protected void	DerbyDictionary.appendSelectRange(SQLBuffer buf, long start, long end, boolean subselect) Appends a range to the given buffer.
protected void	DBDictionary.appendUpdates(Select sel, JDBCStore store, SQLBuffer sql, Object[] params, Map updateParams, boolean allowAlias)
void	SQLServerDictionary.appendXmlComparison(SQLBuffer buf, String op, FilterValue lhs, FilterValue rhs, boolean lhsxml, boolean rhsxml) If this dictionary supports XML type, use this method to append xml predicate.
void	PostgresDictionary.appendXmlComparison(SQLBuffer buf, String op, FilterValue lhs, FilterValue rhs, boolean lhsxml, boolean rhsxml) Append XML comparison.
void	MySQLDictionary.appendXmlComparison(SQLBuffer buf, String op, FilterValue lhs, FilterValue rhs, boolean lhsxml, boolean rhsxml) Append XML comparison.
void	OracleDictionary.appendXmlComparison(SQLBuffer buf, String op, FilterValue lhs, FilterValue rhs, boolean lhsxml, boolean rhsxml) If this dictionary supports XML type, use this method to append xml predicate.
void	MariaDBDictionary.appendXmlComparison(SQLBuffer buf, String op, FilterValue lhs, FilterValue rhs, boolean lhsxml, boolean rhsxml) Append XML comparison.
void	DBDictionary.appendXmlComparison(SQLBuffer buf, String op, FilterValue lhs, FilterValue rhs, boolean lhsxml, boolean rhsxml) If this dictionary supports XML type, use this method to append xml predicate.
void	DB2Dictionary.appendXmlComparison(SQLBuffer buf, String op, FilterValue lhs, FilterValue rhs, boolean lhsxml, boolean rhsxml) If this dictionary supports XML type, use this method to append xml predicate.
void	DBDictionary.comparison(SQLBuffer buf, String op, FilterValue lhs, FilterValue rhs) Append a comparison.
protected ResultSet	SelectImpl.executeQuery(Connection conn, PreparedStatement stmnt, SQLBuffer sql, boolean isLRS, JDBCStore store) This method is to provide override for non-JDBC or JDBC-like implementation of executing query.
Result	SelectImpl.getEagerResult(Connection conn, PreparedStatement stmnt, ResultSet rs, JDBCStore store, JDBCFetchConfiguration fetch, boolean forUpdate, SQLBuffer sql) This method is to provide override for non-JDBC or JDBC-like implementation of executing eager selects.
void	LogicalUnion.UnionSelect.groupBy(SQLBuffer sql)
void	Select.groupBy(SQLBuffer sql) Add a GROUP BY clause.
void	SelectImpl.groupBy(SQLBuffer sql)
void	LogicalUnion.UnionSelect.groupBy(SQLBuffer sql, Joins joins)
void	Select.groupBy(SQLBuffer sql, Joins joins) Add a GROUP BY clause.
void	SelectImpl.groupBy(SQLBuffer sql, Joins joins)
void	LogicalUnion.UnionSelect.having(SQLBuffer sql)
void	Select.having(SQLBuffer sql) Add the given having conditions.
void	SelectImpl.having(SQLBuffer sql)
void	LogicalUnion.UnionSelect.having(SQLBuffer sql, Joins joins)
void	Select.having(SQLBuffer sql, Joins joins) Add the given having conditions.
void	SelectImpl.having(SQLBuffer sql, Joins joins)
void	IngresDictionary.indexOf(SQLBuffer buf, FilterValue str, FilterValue find, FilterValue start) Invoke Ingres' IndexOf Function (Find the first index of a string in another string, starting at a given index).
void	H2Dictionary.indexOf(SQLBuffer buf, FilterValue str, FilterValue find, FilterValue start)
void	SQLServerDictionary.indexOf(SQLBuffer buf, FilterValue str, FilterValue find, FilterValue start)
void	SybaseDictionary.indexOf(SQLBuffer buf, FilterValue str, FilterValue find, FilterValue start)
void	PointbaseDictionary.indexOf(SQLBuffer buf, FilterValue str, FilterValue find, FilterValue start)
void	FirebirdDictionary.indexOf(SQLBuffer buf, FilterValue str, FilterValue find, FilterValue start) On Firebird 2.1 return POSITION(<find>, <str> [, <start>]).
void	PostgresDictionary.indexOf(SQLBuffer buf, FilterValue str, FilterValue find, FilterValue start)
void	InterbaseDictionary.indexOf(SQLBuffer buf, FilterValue str, FilterValue find, FilterValue start)
void	AbstractDB2Dictionary.indexOf(SQLBuffer buf, FilterValue str, FilterValue find, FilterValue start)
void	MySQLDictionary.indexOf(SQLBuffer buf, FilterValue str, FilterValue find, FilterValue start)
void	SolidDBDictionary.indexOf(SQLBuffer buf, FilterValue str, FilterValue find, FilterValue start)
void	OracleDictionary.indexOf(SQLBuffer buf, FilterValue str, FilterValue find, FilterValue start)
void	MariaDBDictionary.indexOf(SQLBuffer buf, FilterValue str, FilterValue find, FilterValue start)
void	HSQLDictionary.indexOf(SQLBuffer buf, FilterValue str, FilterValue find, FilterValue start)
void	JDataStoreDictionary.indexOf(SQLBuffer buf, FilterValue str, FilterValue find, FilterValue start)
void	InformixDictionary.indexOf(SQLBuffer buf, FilterValue str, FilterValue find, FilterValue start)
void	DBDictionary.indexOf(SQLBuffer buf, FilterValue str, FilterValue find, FilterValue start) Invoke this database's indexOf function.
void	DB2Dictionary.indexOf(SQLBuffer buf, FilterValue str, FilterValue find, FilterValue start)
protected boolean	DBDictionary.isUsingOrderBy(SQLBuffer sql)
void	DBDictionary.mathFunction(SQLBuffer buf, String op, FilterValue lhs, FilterValue rhs) Append the numeric parts of a mathematical function.
boolean	LogicalUnion.UnionSelect.orderBy(SQLBuffer sql, boolean asc, boolean select, Value selAs)
boolean	Select.orderBy(SQLBuffer sql, boolean asc, boolean sel, Value selAs) Add an ORDER BY clause.
boolean	SelectImpl.orderBy(SQLBuffer sql, boolean asc, boolean sel, Value selAs)
boolean	LogicalUnion.UnionSelect.orderBy(SQLBuffer sql, boolean asc, Joins joins, boolean select, Value selAs)
boolean	Select.orderBy(SQLBuffer sql, boolean asc, Joins joins, boolean sel, Value selAs) Add an ORDER BY clause.
boolean	SelectImpl.orderBy(SQLBuffer sql, boolean asc, Joins joins, boolean sel, Value selAs)
protected PreparedStatement	SelectImpl.prepareStatement(Connection conn, SQLBuffer sql, JDBCFetchConfiguration fetch, int rsType, int rsConcur, boolean isLRS) This method is to provide override for non-JDBC or JDBC-like implementation of preparing statement.
boolean	LogicalUnion.UnionSelect.select(SQLBuffer sql, Object id)
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	SelectImpl.select(SQLBuffer sql, Object id)
boolean	LogicalUnion.UnionSelect.select(SQLBuffer sql, Object id, Joins joins)
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	SelectImpl.select(SQLBuffer sql, Object id, Joins joins)
void	IngresDictionary.substring(SQLBuffer buf, FilterValue str, FilterValue start, FilterValue length)
void	PointbaseDictionary.substring(SQLBuffer buf, FilterValue str, FilterValue start, FilterValue length)
void	FirebirdDictionary.substring(SQLBuffer buf, FilterValue str, FilterValue start, FilterValue length) Use SUBSTRING(<col name> FROM <m> FOR <n>).
void	AbstractSQLServerDictionary.substring(SQLBuffer buf, FilterValue str, FilterValue start, FilterValue length)
void	InterbaseDictionary.substring(SQLBuffer buf, FilterValue str, FilterValue start, FilterValue end)
void	AbstractDB2Dictionary.substring(SQLBuffer buf, FilterValue str, FilterValue start, FilterValue length)
void	SolidDBDictionary.substring(SQLBuffer buf, FilterValue str, FilterValue start, FilterValue length)
void	JDataStoreDictionary.substring(SQLBuffer buf, FilterValue str, FilterValue start, FilterValue length)
void	DBDictionary.substring(SQLBuffer buf, FilterValue str, FilterValue start, FilterValue length) Invoke this database's substring function.
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	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.
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, boolean subselect) Return the SQL for the given selecting operation.
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	DBDictionary.toSelect(SQLBuffer selects, JDBCFetchConfiguration fetch, SQLBuffer from, SQLBuffer where, SQLBuffer group, SQLBuffer having, SQLBuffer order, boolean distinct, boolean forUpdate, long start, long end, boolean subselect, boolean checkTableForUpdate)
protected 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, boolean subselect, Select sel)
protected 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, boolean subselect, Select sel) Combine the given components into a SELECT statement.
protected 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, Select sel)
protected 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, Select sel) Combine the given components into a SELECT statement.
protected SQLBuffer	DB2Dictionary.toSelect(SQLBuffer select, JDBCFetchConfiguration fetch, SQLBuffer tables, SQLBuffer where, SQLBuffer group, SQLBuffer having, SQLBuffer order, boolean distinct, boolean forUpdate, long start, long end, Select sel)
void	LogicalUnion.UnionSelect.where(SQLBuffer sql)
void	Select.where(SQLBuffer sql) Add the given where conditions.
void	SelectImpl.where(SQLBuffer sql)
void	LogicalUnion.UnionSelect.where(SQLBuffer sql, Joins joins)
void	Select.where(SQLBuffer sql, Joins joins) Add the given where conditions.
void	SelectImpl.where(SQLBuffer sql, Joins joins)

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

Constructor and Description
SQLBuffer(SQLBuffer buf) Copy constructor.