Uses of Class
org.apache.openjpa.jdbc.sql.SQLBuffer
Package
Description
OpenJPA-JDBC Runtime Kernel
OpenJPA-JDBC Expression Tree
OpenJPA-JDBC ORM Metadata
OpenJPA-JDBC ORM Strategies
OpenJPA-JDBC SQL Abstraction
-
Uses of SQLBuffer in org.apache.openjpa.jdbc.kernel
Modifier and TypeMethodDescriptionMixedLockManager.getLockRows
(DBDictionary dict, Object id, ClassMapping mapping, JDBCFetchConfiguration fetch, SQLFactory factory) PessimisticLockManager.getLockRows
(DBDictionary dict, Object id, ClassMapping mapping, JDBCFetchConfiguration fetch, SQLFactory factory) Modifier and TypeMethodDescriptionprotected 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
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 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 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
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 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 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
JDBCStoreQuery.prepareStatement
(Connection conn, SQLBuffer sql) This method is to provide override for non-JDBC or JDBC-like implementation of preparing 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
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.protected PreparedStatement
TableJDBCSeq.prepareStatement
(Connection conn, SQLBuffer buf) This method is to provide override for non-JDBC or JDBC-like implementation of preparing statement.Modifier and TypeMethodDescriptionprotected 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
Modifier and TypeMethodDescriptionvoid
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
Args.appendIsEmpty
(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql) 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.appendIsNotEmpty
(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.appendIsNotNull
(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.appendIsNull
(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.appendSize
(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.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
CoalesceExpression.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
Concat.appendTo
(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql, int index) void
DatastoreFunction.appendTo
(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql, int index) void
Append the first SQL element for this value to the given buffer.void
Append theindex
th SQL element for this value to the given buffer.void
GeneralCaseExpression.appendTo
(Select sel, ExpContext ctx, ExpState state, SQLBuffer buf, int index) void
GetColumn.appendTo
(SQLBuffer buf, FilterValue target, FilterValue[] args, ClassMapping type, JDBCStore store) void
IndexOf.appendTo
(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql, int index) 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
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
Lit.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
MapKey.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
Null.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
Param.appendTo
(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql, int index) void
PCPath.appendTo
(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql) void
PCPath.appendTo
(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql, int index) void
void
SimpleCaseExpression.appendTo
(Select sel, ExpContext ctx, ExpState state, SQLBuffer buf, int index) void
SQLEmbed.appendTo
(SQLBuffer buf, FilterValue target, FilterValue[] args, ClassMapping type, JDBCStore store) void
StringLength.appendTo
(Select sel, ExpContext ctx, ExpState state, SQLBuffer buf, int index) void
SubQ.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
ToLowerCase.appendTo
(Select sel, ExpContext ctx, ExpState state, SQLBuffer buf, int index) void
ToUpperCase.appendTo
(Select sel, ExpContext ctx, ExpState state, SQLBuffer buf, int index) void
Trim.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
Val.appendTo
(Select sel, ExpContext ctx, ExpState state, SQLBuffer sql, int index) Append theindex
th SQL element to the given buffer.void
WhenCondition.appendTo
(Select sel, ExpContext ctx, ExpState state, SQLBuffer buf) void
WhenScalar.appendTo
(Select sel, ExpContext ctx, ExpState state, SQLBuffer buf) 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
Modifier and TypeMethodDescriptionDiscriminator.getClassConditions
(Select sel, Joins joins, ClassMapping base, boolean subs) 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.Modifier and TypeMethodDescriptionvoid
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
Modifier and TypeMethodDescriptionAbstractDiscriminatorStrategy.getClassConditions
(Select sel, Joins joins, ClassMapping base, boolean subs) InValueDiscriminatorStrategy.getClassConditions
(Select sel, Joins joins, ClassMapping base, boolean subclasses) SubclassJoinDiscriminatorStrategy.getClassConditions
(Select sel, Joins joins, ClassMapping base, boolean subclasses) SuperclassDiscriminatorStrategy.getClassConditions
(Select sel, Joins joins, ClassMapping base, boolean subclasses) Modifier and TypeMethodDescriptionvoid
AbstractFieldStrategy.appendIndex
(SQLBuffer sql, Select sel, Joins joins) void
ContainerFieldStrategy.appendIndex
(SQLBuffer sql, Select sel, Joins joins) 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
AbstractFieldStrategy.appendIsNotNull
(SQLBuffer sql, Select sel, Joins joins) void
ContainerFieldStrategy.appendIsNotNull
(SQLBuffer sql, Select sel, Joins joins) void
EmbedFieldStrategy.appendIsNotNull
(SQLBuffer sql, Select sel, Joins joins) void
HandlerFieldStrategy.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
StringFieldStrategy.appendIsNotNull
(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
EmbedFieldStrategy.appendIsNull
(SQLBuffer sql, Select sel, Joins joins) void
HandlerFieldStrategy.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) void
StringFieldStrategy.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) 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
Modifier and TypeMethodDescriptionSQLBuffer.append
(DBIdentifier name) SQLBuffer.append
(Select sel, JDBCFetchConfiguration fetch) Append a subselect.Append all SQL and parameters of the given buffer.SQLBuffer.appendCount
(Select sel, JDBCFetchConfiguration fetch) Append a subselect count.SQLBuffer.appendParamOnly
(SQLBuffer buf) Append parameters only if the given buffer at the given positions.SQLBuffer.appendValue
(Object o) Append a parameter value.SQLBuffer.appendValue
(Object o, Column col) Append a system inserted parameter value for a specific column.SQLBuffer.appendValue
(Object o, Column col, Parameter userParam) Append a user parameter value for a specific column.SQLBuffer.appendValue
(Object o, Column col, Parameter userParam, boolean useParamToken) protected SQLBuffer
DBDictionary.getDeleteTargets
(Select sel) protected SQLBuffer
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.LogicalUnion.UnionSelect.getGrouping()
Select.getGrouping()
Return the grouping SQL for this select.SelectImpl.getGrouping()
LogicalUnion.UnionSelect.getHaving()
Select.getHaving()
Return the HAVING clause, or null if none.SelectImpl.getHaving()
LogicalUnion.UnionSelect.getOrdering()
Select.getOrdering()
Return the ordering SQL for this select.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) LogicalUnion.getSQL()
LogicalUnion.UnionSelect.getSQL()
SelectExecutor.getSQL()
Get the buffer if it has been computed by a previous call toSelectExecutor.toSelect(boolean, JDBCFetchConfiguration)
, if any.SelectImpl.getSQL()
protected SQLBuffer
Return the WHERE portion of the select statement, or null if no where conditions.LogicalUnion.UnionSelect.getWhere()
Select.getWhere()
Return the WHERE clause, minus any necessary end joins.SelectImpl.getWhere()
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.DBDictionary.toDelete
(ClassMapping mapping, Select sel, Object[] params) Create a DELETE statement for the specified Select.DBDictionary.toNativeJoin
(Join join) Use the given join instance to create SQL joining its tables in the database's native syntax.OracleDictionary.toNativeJoin
(Join join) 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.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.HSQLDictionary.toOperation
(String op, SQLBuffer selects, SQLBuffer from, SQLBuffer where, SQLBuffer group, SQLBuffer having, SQLBuffer order, boolean distinct, long start, long end, String forUpdateClause) 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) DBDictionary.toSelect
(Select sel, boolean forUpdate, JDBCFetchConfiguration fetch) Create a SELECT statement in the proper join syntax for the given instance.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.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
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
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.EmpressDictionary.toSelect
(SQLBuffer selects, JDBCFetchConfiguration fetch, SQLBuffer from, SQLBuffer where, SQLBuffer group, SQLBuffer having, SQLBuffer order, boolean distinct, boolean forUpdate, long startIdx, long endIdx) LogicalUnion.toSelect
(boolean forUpdate, JDBCFetchConfiguration fetch) LogicalUnion.UnionSelect.toSelect
(boolean forUpdate, JDBCFetchConfiguration fetch) 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
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) SelectExecutor.toSelect
(boolean forUpdate, JDBCFetchConfiguration fetch) Return this select as a SQL statement formatted for the current dictionary.SelectImpl.toSelect
(boolean forUpdate, JDBCFetchConfiguration fetch) DBDictionary.toSelectCount
(Select sel) Create a SELECT COUNT statement in the proper join syntax for the given instance.LogicalUnion.toSelectCount()
LogicalUnion.UnionSelect.toSelectCount()
SelectExecutor.toSelectCount()
Return this select as a COUNT SQL statement formatted for the current dictionary.SelectImpl.toSelectCount()
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.DBDictionary.toTraditionalJoin
(Join join) Use the given join instance to create SQL joining its tables in the traditional style.DBDictionary.toUpdate
(ClassMapping mapping, Select sel, JDBCStore store, Object[] params, Map updates) Modifier and TypeMethodDescriptionvoid
void
Append the given joins to the given buffer.void
Append all SQL and parameters of the given buffer.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
DB2Dictionary.appendLength
(SQLBuffer buf, int type) protected void
DBDictionary.appendLength
(SQLBuffer buf, int type) protected void
SQLServerDictionary.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.appendParamOnly
(SQLBuffer buf) Append parameters only if the given buffer at the given positions.protected void
DB2Dictionary.appendSelect
(SQLBuffer selectSQL, Object alias, Select sel, int idx) protected void
DBDictionary.appendSelect
(SQLBuffer selectSQL, Object elem, Select sel, int idx) Appendelem
toselectSQL
.protected void
SolidDBDictionary.appendSelect
(SQLBuffer selectSQL, Object alias, Select sel, int idx) protected void
AbstractSQLServerDictionary.appendSelectRange
(SQLBuffer buf, long start, long end, boolean subselect) protected void
DB2Dictionary.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
DerbyDictionary.appendSelectRange
(SQLBuffer buf, long start, long end, boolean subselect) Appends a range to the given buffer.protected void
FirebirdDictionary.appendSelectRange
(SQLBuffer buf, long start, long end, boolean subselect) Use eitherFIRST <p> SKIP <q>
orROWS <m> TO <n>
syntax.protected void
H2Dictionary.appendSelectRange
(SQLBuffer buf, long start, long end, boolean subselect) protected void
HSQLDictionary.appendSelectRange
(SQLBuffer buf, long start, long end, boolean subselect) protected void
IngresDictionary.appendSelectRange
(SQLBuffer buf, long start, long end, boolean subselect) Implementation of appendSelectRange for Ingres - uses "SELECT FIRST n" syntax.protected void
MariaDBDictionary.appendSelectRange
(SQLBuffer buf, long start, long end, boolean subselect) protected void
MySQLDictionary.appendSelectRange
(SQLBuffer buf, long start, long end, boolean subselect) protected void
PostgresDictionary.appendSelectRange
(SQLBuffer buf, long start, long end, boolean subselect) protected void
SQLServerDictionary.appendSelectRange
(SQLBuffer buf, long start, long end, boolean subselect) protected void
DBDictionary.appendUpdates
(Select sel, JDBCStore store, SQLBuffer sql, Object[] params, Map updateParams, boolean allowAlias) 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.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
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
PostgresDictionary.appendXmlComparison
(SQLBuffer buf, String op, FilterValue lhs, FilterValue rhs, boolean lhsxml, boolean rhsxml) Append XML comparison.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
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.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
void
void
Add a GROUP BY clause.void
Add a GROUP BY clause.void
void
void
void
void
Add the given having conditions.void
Add the given having conditions.void
void
void
AbstractDB2Dictionary.indexOf
(SQLBuffer buf, FilterValue str, FilterValue find, FilterValue start) void
DB2Dictionary.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
FirebirdDictionary.indexOf
(SQLBuffer buf, FilterValue str, FilterValue find, FilterValue start) On Firebird 2.1 returnPOSITION(<find>, <str> [, <start>])
.
void
H2Dictionary.indexOf
(SQLBuffer buf, FilterValue str, FilterValue find, FilterValue start) void
HSQLDictionary.indexOf
(SQLBuffer buf, FilterValue str, FilterValue find, FilterValue start) void
InformixDictionary.indexOf
(SQLBuffer buf, FilterValue str, FilterValue find, FilterValue start) 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
InterbaseDictionary.indexOf
(SQLBuffer buf, FilterValue str, FilterValue find, FilterValue start) void
JDataStoreDictionary.indexOf
(SQLBuffer buf, FilterValue str, FilterValue find, FilterValue start) void
MariaDBDictionary.indexOf
(SQLBuffer buf, FilterValue str, FilterValue find, FilterValue start) void
MySQLDictionary.indexOf
(SQLBuffer buf, FilterValue str, FilterValue find, FilterValue start) void
OracleDictionary.indexOf
(SQLBuffer buf, FilterValue str, FilterValue find, FilterValue start) void
PointbaseDictionary.indexOf
(SQLBuffer buf, FilterValue str, FilterValue find, FilterValue start) void
PostgresDictionary.indexOf
(SQLBuffer buf, FilterValue str, FilterValue find, FilterValue start) void
SolidDBDictionary.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) 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
boolean
LogicalUnion.UnionSelect.orderBy
(SQLBuffer sql, boolean asc, Joins joins, boolean select, Value selAs) boolean
Add an ORDER BY clause.boolean
Add an ORDER BY clause.boolean
boolean
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
boolean
boolean
Select the given SQL; the given id object is an identifier to use when retrieving the corresponding value from aResult
.boolean
Select the given SQL; the given id object is an identifier to use when retrieving the corresponding value from aResult
.boolean
boolean
void
AbstractDB2Dictionary.substring
(SQLBuffer buf, FilterValue str, FilterValue start, FilterValue length) void
AbstractSQLServerDictionary.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.void
FirebirdDictionary.substring
(SQLBuffer buf, FilterValue str, FilterValue start, FilterValue length) UseSUBSTRING(<col name> FROM <m> FOR <n>)
.void
IngresDictionary.substring
(SQLBuffer buf, FilterValue str, FilterValue start, FilterValue length) void
InterbaseDictionary.substring
(SQLBuffer buf, FilterValue str, FilterValue start, FilterValue end) void
JDataStoreDictionary.substring
(SQLBuffer buf, FilterValue str, FilterValue start, FilterValue length) void
PointbaseDictionary.substring
(SQLBuffer buf, FilterValue str, FilterValue start, FilterValue length) void
SolidDBDictionary.substring
(SQLBuffer buf, FilterValue str, FilterValue start, FilterValue length) 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.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.HSQLDictionary.toOperation
(String op, SQLBuffer selects, SQLBuffer from, SQLBuffer where, SQLBuffer group, SQLBuffer having, SQLBuffer order, boolean distinct, long start, long end, String forUpdateClause) 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) 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.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
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
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.EmpressDictionary.toSelect
(SQLBuffer selects, JDBCFetchConfiguration fetch, SQLBuffer from, SQLBuffer where, SQLBuffer group, SQLBuffer having, SQLBuffer order, boolean distinct, boolean forUpdate, long startIdx, long endIdx) 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
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) void
void
void
Add the given where conditions.void
Add the given where conditions.void
void