Uses of Class
org.datanucleus.store.rdbms.sql.SQLStatement

Packages that use SQLStatement

Package	Description
org.datanucleus.store.rdbms.adapter	Provides mappings of all supported databases to aspects of the database that determines the SQL generation.
org.datanucleus.store.rdbms.query	Package providing the querying mechanism for DataNucleus for RDBMS datastores.
org.datanucleus.store.rdbms.request	Provides the mechanism of communicating with the database using JDBC.
org.datanucleus.store.rdbms.scostore	This package provides classes defining the (SCO) backing store for various container classes (Collections/Maps/arrays) within DataNucleus.
org.datanucleus.store.rdbms.sql	Series of classes used to generate SQL statements.
org.datanucleus.store.rdbms.sql.expression	Series of expressions representing conditions in SQL statements.
org.datanucleus.store.rdbms.sql.method	Support for invocation of Java methods, typically using SQL functions.

Uses of SQLStatement in org.datanucleus.store.rdbms.adapter

Methods in org.datanucleus.store.rdbms.adapter with parameters of type SQLStatement

Modifier and Type	Method and Description
boolean	OracleAdapter.validToSelectMappingInStatement(SQLStatement stmt, JavaTypeMapping m) Method to return if it is valid to select the specified mapping for the specified statement for this datastore adapter.
boolean	DatastoreAdapter.validToSelectMappingInStatement(SQLStatement stmt, JavaTypeMapping m) Method to return if it is valid to select the specified mapping for the specified statement for this datastore adapter.
boolean	BaseDatastoreAdapter.validToSelectMappingInStatement(SQLStatement stmt, JavaTypeMapping m) Method to return if it is valid to select the specified mapping for the specified statement for this datastore adapter.
boolean	DerbyAdapter.validToSelectMappingInStatement(SQLStatement stmt, JavaTypeMapping m) Method to return if it is valid to select the specified mapping for the specified statement for this datastore adapter.
boolean	MSSQLServerAdapter.validToSelectMappingInStatement(SQLStatement stmt, JavaTypeMapping m) Method to return if it is valid to select the specified mapping for the specified statement for this datastore adapter.

Uses of SQLStatement in org.datanucleus.store.rdbms.query

Methods in org.datanucleus.store.rdbms.query that return SQLStatement

Modifier and Type

Method and Description

static SQLStatement

RDBMSQueryUtils.getStatementForCandidates(RDBMSStoreManager storeMgr, SQLStatement parentStmt, org.datanucleus.metadata.AbstractClassMetaData cmd, StatementClassMapping clsMapping, org.datanucleus.ExecutionContext ec, Class candidateCls, boolean subclasses, String result, String candidateAlias, String candidateTableGroupName) Method to return a statement selecting the candidate table(s) required to cover all possible types for this candidates inheritance strategy.

Methods in org.datanucleus.store.rdbms.query with parameters of type SQLStatement

Modifier and Type	Method and Description
void	BulkFetchHelper.applyParametersToStatement(PreparedStatement ps, RDBMSQueryCompilation datastoreCompilation, SQLStatement sqlStmt, Map parameters) Convenience method to apply the passed parameters to the provided bulk-fetch statement.
static SQLStatement	RDBMSQueryUtils.getStatementForCandidates(RDBMSStoreManager storeMgr, SQLStatement parentStmt, org.datanucleus.metadata.AbstractClassMetaData cmd, StatementClassMapping clsMapping, org.datanucleus.ExecutionContext ec, Class candidateCls, boolean subclasses, String result, String candidateAlias, String candidateTableGroupName) Method to return a statement selecting the candidate table(s) required to cover all possible types for this candidates inheritance strategy.

Constructors in org.datanucleus.store.rdbms.query with parameters of type SQLStatement

Constructor and Description

QueryToSQLMapper(SQLStatement stmt, org.datanucleus.query.compiler.QueryCompilation compilation, Map parameters, StatementClassMapping resultDefForClass, StatementResultMapping resultDef, org.datanucleus.metadata.AbstractClassMetaData cmd, boolean subclasses, org.datanucleus.FetchPlan fetchPlan, org.datanucleus.ExecutionContext ec, org.datanucleus.util.Imports importsDefinition, Set<String> options, Map<String,Object> extensions) Constructor.

Uses of SQLStatement in org.datanucleus.store.rdbms.request

Methods in org.datanucleus.store.rdbms.request with parameters of type SQLStatement

Modifier and Type	Method and Description
protected int	FetchRequest.processMembersOfClass(SQLStatement sqlStatement, org.datanucleus.metadata.AbstractMemberMetaData[] mmds, DatastoreClass table, SQLTable sqlTbl, StatementClassMapping mappingDef, Collection fetchCallbacks, org.datanucleus.ClassLoaderResolver clr) Method to process the supplied members of the class, adding to the SQLStatement as required.

Uses of SQLStatement in org.datanucleus.store.rdbms.scostore

Methods in org.datanucleus.store.rdbms.scostore that return SQLStatement

Modifier and Type	Method and Description
SQLStatement	IteratorStatement.getSQLStatement()
protected SQLStatement	JoinMapStore.getSQLStatementForGet(org.datanucleus.state.ObjectProvider ownerOP) Method to return an SQLStatement for retrieving the value for a key.
protected SQLStatement	FKMapStore.getSQLStatementForGet(org.datanucleus.state.ObjectProvider ownerOP) Method to return an SQLStatement for retrieving the value for a key.

Constructors in org.datanucleus.store.rdbms.scostore with parameters of type SQLStatement

Constructor and Description
IteratorStatement(org.datanucleus.store.scostore.Store store, SQLStatement stmt, StatementClassMapping stmtClassMapping)

Uses of SQLStatement in org.datanucleus.store.rdbms.sql

Fields in org.datanucleus.store.rdbms.sql declared as SQLStatement

Modifier and Type	Field and Description
protected SQLStatement	SQLStatement.parent Parent statement, if this is a subquery.
protected SQLStatement	AbstractStatementGenerator.parentStmt Parent statement.
protected SQLStatement	SQLTable.stmt

Fields in org.datanucleus.store.rdbms.sql with type parameters of type SQLStatement

Modifier and Type	Field and Description
protected List<SQLStatement>	SQLStatement.unions List of unioned SQLStatements (if any).

Methods in org.datanucleus.store.rdbms.sql that return SQLStatement

Modifier and Type	Method and Description
SQLStatement	SQLStatement.getParentStatement()
SQLStatement	SQLTable.getSQLStatement()
protected SQLStatement	UnionStatementGenerator.getSQLStatementForCandidate(String className) Convenience method to return the SQLStatement for a particular class.
protected SQLStatement	UnionStatementGenerator.getSQLStatementForCandidateViaJoin(String className) Convenience method to return the SQLStatement for a particular class selecting a join table.
SQLStatement	UnionStatementGenerator.getStatement() Accessor for the SQL Statement for the candidate [+ subclasses].
SQLStatement	DiscriminatorStatementGenerator.getStatement() Accessor for the SQL Statement.
SQLStatement	StatementGenerator.getStatement() Accessor for the statement.

Methods in org.datanucleus.store.rdbms.sql that return types with arguments of type SQLStatement

Modifier and Type	Method and Description
List<SQLStatement>	SQLStatement.getUnions() Accessor for the unioned statements.

Methods in org.datanucleus.store.rdbms.sql with parameters of type SQLStatement

Modifier and Type	Method and Description
static SQLTable	SQLStatementHelper.addJoinForOneToOneRelation(SQLStatement stmt, JavaTypeMapping sourceMapping, SQLTable sourceSqlTbl, JavaTypeMapping targetMapping, Table targetTable, String targetAlias, Object[] discrimValues, String targetTablegroupName, SQLJoin.JoinType joinType) Convenience method to add a join across a 1-1 relation to the provided SQLStatement.
SQLText	SQLText.append(SQLStatement stmt) Append an SQLStatement.
String	SQLTableAlphaNamer.getAliasForTable(SQLStatement stmt, Table table, String groupName)
String	SQLTableTNamer.getAliasForTable(SQLStatement stmt, Table table, String groupName)
String	SQLTableNamer.getAliasForTable(SQLStatement stmt, Table table, String groupName) Method to return the alias to use for the specified table.
static BooleanExpression	SQLStatementHelper.getExpressionForDiscriminatorForClass(SQLStatement stmt, String className, org.datanucleus.metadata.DiscriminatorMetaData dismd, JavaTypeMapping discriminatorMapping, SQLTable discrimSqlTbl, org.datanucleus.ClassLoaderResolver clr) Convenience method to generate a BooleanExpression for the associated discriminator value for the specified class.
static PreparedStatement	SQLStatementHelper.getPreparedStatementForSQLStatement(SQLStatement sqlStmt, org.datanucleus.ExecutionContext ec, org.datanucleus.store.connection.ManagedConnection mconn, String resultSetType, String resultSetConcurrency) Convenience method to return a PreparedStatement for an SQLStatement.
static SQLTable	SQLStatementHelper.getSQLTableForMappingOfTable(SQLStatement stmt, SQLTable sqlTbl, JavaTypeMapping mapping) Method to return the SQLTable where the specified mapping (in the same table group as the provided SQLTable) is defined.
boolean	SQLStatement.isChildStatementOf(SQLStatement stmt) Convenience method to return if this statement is a child (inner) statement of the supplied statement.
static void	SQLStatementHelper.selectFetchPlanOfCandidateInStatement(SQLStatement stmt, StatementClassMapping mappingDefinition, org.datanucleus.metadata.AbstractClassMetaData candidateCmd, org.datanucleus.FetchPlan fetchPlan, int maxFetchDepth) Method to select all fetch plan members for the candidate class.
static void	SQLStatementHelper.selectFetchPlanOfSourceClassInStatement(SQLStatement stmt, StatementClassMapping mappingDefinition, org.datanucleus.FetchPlan fetchPlan, SQLTable sourceSqlTbl, org.datanucleus.metadata.AbstractClassMetaData sourceCmd, int maxFetchDepth) Method to select all fetch plan members for the "source" class.
static void	SQLStatementHelper.selectIdentityOfCandidateInStatement(SQLStatement stmt, StatementClassMapping mappingDefinition, org.datanucleus.metadata.AbstractClassMetaData candidateCmd) Method to select the identity for the candidate class.
static void	SQLStatementHelper.selectMemberOfSourceInStatement(SQLStatement stmt, StatementClassMapping mappingDefinition, org.datanucleus.FetchPlan fetchPlan, SQLTable sourceSqlTbl, org.datanucleus.metadata.AbstractMemberMetaData mmd, org.datanucleus.ClassLoaderResolver clr, int maxFetchPlanLimit) Method to select the specified member (field/property) of the source table in the passed SQL statement.
void	UnionStatementGenerator.setParentStatement(SQLStatement stmt)
void	DiscriminatorStatementGenerator.setParentStatement(SQLStatement stmt)
void	StatementGenerator.setParentStatement(SQLStatement stmt) Method to set the parent statement.
void	SQLStatement.union(SQLStatement stmt) Method to union this SQL statement with another SQL statement.

Constructors in org.datanucleus.store.rdbms.sql with parameters of type SQLStatement

Constructor and Description
SQLStatement(SQLStatement parentStmt, RDBMSStoreManager rdbmsMgr, Table table, DatastoreIdentifier alias, String tableGroupName) Constructor for an SQL statement that is a subquery of another statement.

Uses of SQLStatement in org.datanucleus.store.rdbms.sql.expression

Fields in org.datanucleus.store.rdbms.sql.expression declared as SQLStatement

Modifier and Type	Field and Description
protected SQLStatement	SQLExpression.stmt The SQL statement that this is part of.

Methods in org.datanucleus.store.rdbms.sql.expression that return SQLStatement

Modifier and Type	Method and Description
SQLStatement	SQLExpression.getSQLStatement()
SQLStatement	NumericSubqueryExpression.getSubqueryStatement()
SQLStatement	StringSubqueryExpression.getSubqueryStatement()
SQLStatement	SubqueryExpressionComponent.getSubqueryStatement() Accessor for the subquery.
SQLStatement	SubqueryExpression.getSubqueryStatement()
SQLStatement	TemporalSubqueryExpression.getSubqueryStatement()

Methods in org.datanucleus.store.rdbms.sql.expression with parameters of type SQLStatement

Modifier and Type	Method and Description
static SQLExpression	ExpressionUtils.getLiteralForOne(SQLStatement stmt) Convenience accessor for a literal for the number 1.
SQLExpression	SQLExpressionFactory.invokeMethod(SQLStatement stmt, String className, String methodName, SQLExpression expr, List args) Accessor for the result of a method call on the supplied expression with the supplied args.
SQLExpression	SQLExpressionFactory.newExpression(SQLStatement stmt, SQLTable sqlTbl, JavaTypeMapping mapping) Factory for an expression representing a mapping on a table.
SQLExpression	SQLExpressionFactory.newExpression(SQLStatement stmt, SQLTable sqlTbl, JavaTypeMapping mapping, JavaTypeMapping parentMapping) Factory for an expression representing a mapping on a table.
SQLExpression	SQLExpressionFactory.newLiteral(SQLStatement stmt, JavaTypeMapping mapping, Object value) Factory for a literal representing a value.
SQLExpression	SQLExpressionFactory.newLiteralParameter(SQLStatement stmt, JavaTypeMapping mapping, Object value, String paramName) Factory for a literal as an input parameter.

Constructors in org.datanucleus.store.rdbms.sql.expression with parameters of type SQLStatement

Constructor and Description
AggregateNumericExpression(SQLStatement stmt, JavaTypeMapping mapping, String functionName, List args)
AggregateTemporalExpression(SQLStatement stmt, JavaTypeMapping mapping, String functionName, List args)
ArrayExpression(SQLStatement stmt, JavaTypeMapping mapping, SQLExpression[] exprs) Constructor for an SQL expression for an array expression specified in the query.
ArrayExpression(SQLStatement stmt, SQLTable table, JavaTypeMapping mapping) Constructor for an SQL expression for a (field) mapping in a specified table.
ArrayLiteral(SQLStatement stmt, JavaTypeMapping mapping, Object value, String parameterName) Constructor for an array literal with a value.
BinaryExpression(SQLStatement stmt, JavaTypeMapping mapping, String functionName, List<SQLExpression> args, List types)
BinaryExpression(SQLStatement stmt, SQLTable table, JavaTypeMapping mapping) Constructor for an SQL expression for a (field) mapping in a specified table.
BooleanExpression(SQLStatement stmt, JavaTypeMapping mapping) Constructor for a boolean expression for the specified mapping of the table.
BooleanExpression(SQLStatement stmt, JavaTypeMapping mapping, String sql) Constructor for a boolean expression for the specified mapping using the specified SQL text.
BooleanExpression(SQLStatement stmt, SQLTable table, JavaTypeMapping mapping) Constructor for a boolean expression for the specified mapping of the table.
BooleanLiteral(SQLStatement stmt, JavaTypeMapping mapping, Boolean value) Creates a boolean literal with the specified value, using the provided mapping.
BooleanLiteral(SQLStatement stmt, JavaTypeMapping mapping, Object value, String parameterName) Creates a boolean literal with the specified value, using the provided mapping.
BooleanSubqueryExpression(SQLStatement stmt, String keyword, SQLStatement subStmt)
ByteExpression(SQLStatement stmt, SQLTable table, JavaTypeMapping mapping) Constructor for an SQL expression for a (field) mapping in a specified table.
ByteLiteral(SQLStatement stmt, JavaTypeMapping mapping, Object value, String parameterName) Creates a byte literal.
CharacterExpression(SQLStatement stmt, JavaTypeMapping mapping, String functionName, List args) Generates statement as e.g.
CharacterExpression(SQLStatement stmt, JavaTypeMapping mapping, String functionName, List args, List types) Generates statement as e.g.
CharacterExpression(SQLStatement stmt, SQLTable table, JavaTypeMapping mapping) Constructor for an SQL expression for a (field) mapping in a specified table.
CharacterLiteral(SQLStatement stmt, JavaTypeMapping mapping, Object value, String parameterName) Constructor for a character literal with a value.
CollectionExpression(SQLStatement stmt, SQLTable table, JavaTypeMapping mapping) Constructor for an SQL expression for a (field) mapping in a specified table.
CollectionLiteral(SQLStatement stmt, JavaTypeMapping mapping, Object value, String parameterName) Constructor for a collection literal with a value.
ColumnExpression(SQLStatement stmt, Object value) Constructor for an SQL expression for a literal value.
ColumnExpression(SQLStatement stmt, SQLTable table, Column col) Constructor for an SQL expression for a column.
ColumnExpression(SQLStatement stmt, String parameterName, JavaTypeMapping mapping, Object value, int colNumber) Constructor for an SQL expression for a parameter.
DelegatedExpression(SQLStatement stmt, SQLTable table, JavaTypeMapping mapping)
EnumExpression(SQLStatement stmt, SQLTable table, JavaTypeMapping mapping) Constructor for an expression for an enum field/property.
EnumLiteral(SQLStatement stmt, JavaTypeMapping mapping, Object value, String parameterName) Constructor for an Enum literal with a value.
FloatingPointLiteral(SQLStatement stmt, JavaTypeMapping mapping, Object value, String parameterName) Constructor for a floating point literal with a value.
IntegerLiteral(SQLStatement stmt, JavaTypeMapping mapping, Object value, String parameterName) Constructor for an integer literal with a value.
MapExpression(SQLStatement stmt, SQLTable table, JavaTypeMapping mapping) Constructor.
MapKeyLiteral(SQLStatement stmt, JavaTypeMapping mapping, Object value) Constructor.
MapLiteral(SQLStatement stmt, JavaTypeMapping mapping, Object value, String parameterName) Constructor for a map literal with a value.
MapValueLiteral(SQLStatement stmt, JavaTypeMapping mapping, Object value) Constructor.
NewObjectExpression(SQLStatement stmt, Class cls, List<SQLExpression> args)
NullLiteral(SQLStatement stmt, JavaTypeMapping mapping, Object value, String parameterName) Constructor for a null literal with a value (i.e null!).
NumericExpression(SQLStatement stmt, JavaTypeMapping mapping, String sql) Constructor for a numeric expression for the specified mapping using the specified SQL text.
NumericExpression(SQLStatement stmt, JavaTypeMapping mapping, String functionName, List args) Generates statement as "FUNCTION_NAME(arg [,argN])".
NumericExpression(SQLStatement stmt, JavaTypeMapping mapping, String functionName, List args, List types) Generates statement as "FUNCTION_NAME(arg [AS type] [,argN [AS typeN]])".
NumericExpression(SQLStatement stmt, SQLTable table, JavaTypeMapping mapping) Constructor for a numeric expression for the mapping in the specified table.
NumericSubqueryExpression(SQLStatement stmt, SQLStatement subStmt)
ObjectExpression(SQLStatement stmt, JavaTypeMapping mapping, String functionName, List args) Generates statement as "FUNCTION_NAME(arg [,argN])".
ObjectExpression(SQLStatement stmt, JavaTypeMapping mapping, String functionName, List args, List types) Generates statement as "FUNCTION_NAME(arg [AS type] [,argN [AS typeN]])".
ObjectExpression(SQLStatement stmt, SQLTable table, JavaTypeMapping mapping) Constructor for an SQL expression for a (field) mapping in a specified table.
ObjectLiteral(SQLStatement stmt, JavaTypeMapping mapping, Object value, String parameterName) Constructor for an Object literal with a value.
ParameterLiteral(SQLStatement stmt, JavaTypeMapping mapping, Object value, String parameterName) Constructor for an integer literal with a value.
SQLExpression(SQLStatement stmt, JavaTypeMapping mapping, String functionName, List<SQLExpression> args, List types) Generates statement as "FUNCTION_NAME(arg [AS type] [,argN [AS typeN]])".
SQLExpression(SQLStatement stmt, SQLTable table, JavaTypeMapping mapping) Constructor for an SQL expression for a (field) mapping in a specified table.
StringExpression(SQLStatement stmt, JavaTypeMapping mapping, String functionName, List args) Generates statement as e.g.
StringExpression(SQLStatement stmt, JavaTypeMapping mapping, String functionName, List args, List types) Generates statement as e.g.
StringExpression(SQLStatement stmt, SQLTable table, JavaTypeMapping mapping) Constructor for an SQL expression for a (field) mapping in a specified table.
StringLiteral(SQLStatement stmt, JavaTypeMapping mapping, Object value, String parameterName) Constructor for a String literal with a value.
StringNumericExpression(SQLStatement stmt, SQLTable table, JavaTypeMapping mapping) Constructor for an expression for a field/property that can be represented as String or numeric.
StringSubqueryExpression(SQLStatement stmt, SQLStatement subStmt)
StringTemporalExpression(SQLStatement stmt, SQLTable table, JavaTypeMapping mapping) Constructor for an expression for a field/property represented as String/Temporal.
SubqueryExpression(SQLStatement stmt, SQLStatement subStmt)
TemporalExpression(SQLStatement stmt, JavaTypeMapping mapping, String functionName, List args) Generates statement as "FUNCTION_NAME(arg [,argN])".
TemporalExpression(SQLStatement stmt, JavaTypeMapping mapping, String functionName, List args, List types) Generates statement as "FUNCTION_NAME(arg [AS type] [,argN [AS typeN]])".
TemporalExpression(SQLStatement stmt, SQLTable table, JavaTypeMapping mapping) Constructor for an SQL expression for a (field) mapping in a specified table.
TemporalLiteral(SQLStatement stmt, JavaTypeMapping mapping, Object value, String parameterName) Constructor for a temporal literal with a value.
TemporalSubqueryExpression(SQLStatement stmt, SQLStatement subStmt)
TypeConverterExpression(SQLStatement stmt, SQLTable table, JavaTypeMapping mapping)
TypeConverterLiteral(SQLStatement stmt, JavaTypeMapping mapping, Object value, String parameterName)
TypeConverterMultiExpression(SQLStatement stmt, SQLTable table, JavaTypeMapping mapping)
TypeConverterMultiLiteral(SQLStatement stmt, JavaTypeMapping mapping, Object value, String parameterName)
UnboundExpression(SQLStatement stmt, String variableName) Constructor for an SQL expression for an unbound variable.

Uses of SQLStatement in org.datanucleus.store.rdbms.sql.method

Fields in org.datanucleus.store.rdbms.sql.method declared as SQLStatement

Modifier and Type	Field and Description
protected SQLStatement	AbstractSQLMethod.stmt

Methods in org.datanucleus.store.rdbms.sql.method with parameters of type SQLStatement

Modifier and Type	Method and Description
void	SQLMethod.setStatement(SQLStatement stmt) Method to set the SQLStatement that we are related to.
void	AbstractSQLMethod.setStatement(SQLStatement stmt)