|
Oracle Fusion Middleware Java API Reference for Oracle Extension SDK Reference 11g Release 1 (11.1.1) E13403-03 |
|||||||||
PREV NEXT | FRAMES NO FRAMES |
Packages that use SQLQueryException | |
---|---|
oracle.ide.db.panels.sql | UI classes for declaratively editing a SQL query. |
oracle.javatools.db.sql | Contains an API for declaratively parsing SQL queries (SELECT statements). |
Uses of SQLQueryException in oracle.ide.db.panels.sql |
---|
Methods in oracle.ide.db.panels.sql that throw SQLQueryException | |
---|---|
protected void |
FromJoinToPicker.commit()
|
void |
JoinObjectEditDialog.commit()
|
SQLQuery |
SQLQueryEditDialog.editQuery(SQLQuery query,
DBObjectProvider provider,
Schema defaultSchema)
Edits the given query. |
SQLQuery |
SQLQueryEditDialog.editQuery(SQLQuery query,
SQLFragment defaultObject,
DBObjectProvider provider,
Schema defaultSchema)
Edits the given query. |
java.lang.String |
SQLQueryEditDialog.editQuery(java.lang.String sqlText,
DBObjectProvider provider,
Schema defaultSchema)
Edits the given query sql text. |
Uses of SQLQueryException in oracle.javatools.db.sql |
---|
Subclasses of SQLQueryException in oracle.javatools.db.sql | |
---|---|
class |
AliasInUseException
SQLQueryException thrown when an attempt is made to add an object whose alias is already in use. |
class |
AmbiguousColumnException
Exception thrown when the name of a column in a query is ambiguous - i.e. |
class |
IDException
Exception thrown when a DBObject is missing an ID. |
class |
InvalidAliasException
Exception thrown when a select or from object has an invalid alias (e.g. |
class |
InvalidSQLException
SQLQueryException for representing errors in the sql (e.g. |
class |
SQLParseException
Subclass of SQLQueryException used for parse errors in the sql. |
class |
SQLQueryClauseException
Exception thrown by a SQLQueryBuilder when there is an error with a clause in the query, but that this error doesn't stop the query being declarative. |
Methods in oracle.javatools.db.sql with type parameters of type SQLQueryException | ||
---|---|---|
protected
|
AbstractSQLQueryBuilder.throwException(T sqe)
|
Methods in oracle.javatools.db.sql that throw SQLQueryException | ||
---|---|---|
void |
AbstractSQLQueryBuilder.addFromObject(FromObject from)
|
|
void |
SQLQueryBuilder.addFromObject(FromObject from)
Adds the given FromObject to the query. |
|
void |
AbstractSQLQueryBuilder.addSelectObject(int index,
SelectObject select)
|
|
void |
SQLQueryBuilder.addSelectObject(int index,
SelectObject select)
Inserts the given SelectObject to the query at the given index. |
|
void |
AbstractSQLQueryBuilder.addSelectObject(SelectObject select)
|
|
void |
SQLQueryBuilder.addSelectObject(SelectObject select)
Adds the given SelectObject to the query. |
|
abstract void |
AbstractSQLQueryBuilder.buildQuery(SQLQuery query)
Builds the query based on the given SQLQuery. |
|
void |
SQLQueryBuilder.buildQuery(SQLQuery query)
Builds the query based on the given SQLQuery. |
|
void |
AbstractSQLQueryBuilder.buildQuery(java.lang.String sql)
Builds a query object from the given sql expression. |
|
void |
SQLQueryBuilder.buildQuery(java.lang.String select)
Builds the query based on the given select statement. |
|
void |
AbstractSQLQueryBuilder.buildQuery(java.lang.String sql,
SQLQueryOwner parent)
Builds a query from the given sql expression. |
|
void |
SQLQueryBuilder.buildQuery(java.lang.String select,
SQLQueryOwner owner)
Builds the query based on the given select statement. |
|
protected abstract void |
AbstractSQLQueryBuilder.buildQueryImpl(java.lang.String sql,
SQLQueryOwner parent)
Builds the query based on the given select statement. |
|
static void |
ParserUtils.checkErrors(PlsqlRoot root,
java.lang.String sql)
Convert parser errors into a SQLQueryException |
|
SQLQueryBuilder.SQLQueryObjectSet |
AbstractSQLQueryBuilder.constructFKJoin(FKConstraint fk,
FromObject left,
FromObject right)
|
|
SQLQueryBuilder.SQLQueryObjectSet |
SQLQueryBuilder.constructFKJoin(FKConstraint fk,
FromObject left,
FromObject right)
Creates a JOIN in the query's FROM clause to represent the given FKConstraint. |
|
SQLQueryBuilder.SQLQueryObjectSet |
AbstractSQLQueryBuilder.constructFKJoins(FKConstraint[] fks,
FromObject[] usagesToUse)
|
|
SQLQueryBuilder.SQLQueryObjectSet |
SQLQueryBuilder.constructFKJoins(FKConstraint[] fks,
FromObject[] usagesToUse)
Creates a set of nested JOINs in the query's FROM clause to represent each given FKConstraint. |
|
SQLQueryBuilder.SQLQueryObjectSet |
AbstractSQLQueryBuilder.constructFromObject(Relation relation,
boolean createSelectObjects,
boolean createJoins,
FromObject[] includeInJoins)
|
|
SQLQueryBuilder.SQLQueryObjectSet |
SQLQueryBuilder.constructFromObject(Relation relation,
boolean createSelectObjects,
boolean createJoins,
FromObject[] includeInJoins)
Creates a FromObject for the query. |
|
FromObject |
AbstractSQLQueryBuilder.constructFromObject(java.lang.String expression,
java.lang.String alias)
|
|
FromObject |
SQLQueryBuilder.constructFromObject(java.lang.String expression,
java.lang.String alias)
Creates a FromObject using the given alias and expression, parsing the expression into an appropriate set of SQLFragments. |
|
SQLQueryBuilder.SQLQueryObjectSet |
AbstractSQLQueryBuilder.constructFromObjects(Relation[] baseRelations,
boolean createSelectObjects,
boolean createJoins,
FromObject[] includeInJoins)
|
|
SQLQueryBuilder.SQLQueryObjectSet |
SQLQueryBuilder.constructFromObjects(Relation[] baseRelations,
boolean createSelectObjects,
boolean createJoins,
FromObject[] includeInJoins)
Creates one or more FromObjects for the query. |
|
SQLQueryBuilder.SQLQueryObjectSet |
AbstractSQLQueryBuilder.constructSelectObject(Column col,
FromObject usageToUse)
|
|
SQLQueryBuilder.SQLQueryObjectSet |
SQLQueryBuilder.constructSelectObject(Column col,
FromObject usageToUse)
Creates a SelectObject for the query based on the column passed in. |
|
SelectObject |
AbstractSQLQueryBuilder.constructSelectObject(java.lang.String expression,
java.lang.String alias)
|
|
SelectObject |
SQLQueryBuilder.constructSelectObject(java.lang.String expression,
java.lang.String alias)
Creates a SelectObject using the given alias and expression, parsing the expression into an appropriate set of SQLFragments. |
|
SQLQueryBuilder.SQLQueryObjectSet |
AbstractSQLQueryBuilder.constructSelectObjects(Column[] baseCols,
FromObject[] usagesToUse)
|
|
SQLQueryBuilder.SQLQueryObjectSet |
SQLQueryBuilder.constructSelectObjects(Column[] baseCols,
FromObject[] usagesToUse)
Creates a set of SelectObjects for the query based on the columns passed in. |
|
static SQLQueryBuilder |
SQLQueryBuilderFactory.createBuilder(DBObjectProvider provider,
Schema defaultSchema,
SQLQuery query)
Deprecated. |
|
static SQLQueryBuilder |
SQLQueryBuilderFactory.createBuilder(DBObjectProvider provider,
Schema defaultSchema,
java.lang.String sqlText)
Deprecated. |
|
static SQLQueryBuilder |
SQLQueryBuilderFactory.createBuilder(DBObjectProvider provider,
SQLQuery query)
Deprecated. |
|
static SQLQueryBuilder |
SQLQueryBuilderFactory.createBuilder(DBObjectProvider provider,
SQLQueryOwner owner,
java.lang.String sqlText)
Deprecated. |
|
static SQLQueryBuilder |
SQLQueryBuilderFactory.createBuilder(DBObjectProvider provider,
java.lang.String sqlText)
Deprecated. |
|
protected FromObject |
AbstractSQLQueryBuilder.createFromObject(Relation rel,
java.util.List extraNames)
|
|
FromObject |
AbstractSQLQueryBuilder.createJoinObject(FKConstraint fk,
FromObject left,
FromObject right)
|
|
protected FKUsage |
AbstractSQLQueryBuilder.doConstructFKUsage(FKConstraint fk,
java.util.Map relsIDsToUse,
java.util.List newFroms)
|
|
protected FromObject |
AbstractSQLQueryBuilder.doConstructFromObject(Relation relation,
java.util.List baseRelIDs,
java.util.List relNames,
java.util.Map newRels,
java.util.List cols,
java.util.List fks)
|
|
protected FromObject |
AbstractSQLQueryBuilder.doConstructJoin(FKConstraint fk,
java.util.Map relsIDsToUse,
java.util.List newFroms,
FromObject left,
FromObject right)
|
|
protected SelectObject |
AbstractSQLQueryBuilder.doConstructSelectObject(Column col,
java.util.Map relsToUse,
java.util.Map newRels,
java.util.List relNames,
java.util.List colNames)
|
|
protected FromObjectUsage |
AbstractSQLQueryBuilder.findColumnInFromExpression(java.lang.String colName,
SQLFragment exp,
boolean allowDuplicates,
FromObject from,
SQLFragment creating)
|
|
protected FromObjectUsage |
AbstractSQLQueryBuilder.findColumnInFromObjects(java.lang.String colName,
FromObject[] froms,
boolean allowDuplicates,
boolean enforceInAll,
SQLFragment creating)
Finds a Column of given name amongst the given FromObjects. |
|
protected FromObjectUsage |
AbstractSQLQueryBuilder.findColumnInFromObjects(java.lang.String colName,
SQLFragment creating,
FromObject... extraFroms)
Finds a Column of given name amongst the RelationUsages in the query. |
|
protected FromObjectUsage |
AbstractSQLQueryBuilder.findColumnInJoin(java.lang.String colName,
JoinObject join,
boolean allowDuplicates,
SQLFragment creating)
|
|
protected FromObjectUsage |
AbstractSQLQueryBuilder.findColumnInRelation(java.lang.String colName,
Relation rel)
Warning: The returned ColumnUsage won't have a FromObject set. |
|
protected FromObjectUsage |
AbstractSQLQueryBuilder.findColumnInRelation(java.lang.String colName,
RelationUsage relU)
|
|
protected SelectObjectUsage |
AbstractSQLQueryBuilder.findColumnInSubQuery(java.lang.String colName,
SQLQuery query)
|
|
static java.util.Collection<java.lang.String[]> |
ParserUtils.getColumnNames(java.lang.String expression,
ParserUtils.ExpressionType type)
Returns a Collection of names of the columns used in expression
of SqlDriver type type . |
|
protected java.util.List |
AbstractSQLQueryBuilder.getIDs(DBObject[] objs)
|
|
protected void |
AbstractSQLQueryBuilder.loadQuery()
|
|
void |
AbstractSQLQueryBuilder.mergeRelationUsages(RelationUsage baseUsage,
RelationUsage mergingUsage)
|
|
void |
SQLQueryBuilder.mergeRelationUsages(RelationUsage baseUsage,
RelationUsage mergingUsage)
Merges two RelationUsages into one. |
|
SQLFragment |
AbstractSQLQueryBuilder.parseFromExpression(java.lang.String expression)
|
|
SQLFragment |
SQLQueryBuilder.parseFromExpression(java.lang.String expression)
Parses an expression to see if it is a valid expression for a From object. |
|
protected abstract SQLFragment |
AbstractSQLQueryBuilder.parseFromExpression(java.lang.String expression,
FromObject creating)
|
|
SQLFragment |
AbstractSQLQueryBuilder.parseHavingExpression(java.lang.String expression)
By default this calls parseWhereExpression(). |
|
SQLFragment |
SQLQueryBuilder.parseHavingExpression(java.lang.String expression)
Parses an expression to see if it is a valid expression for a Having object. |
|
OnJoinCondition |
SQLQueryBuilder.parseOnExpression(java.lang.String expression,
JoinObject join)
More specific than parseFromExpression() this method is used to specifically parse the ON expression for a JOIN in a FROM clause. |
|
SQLFragment |
AbstractSQLQueryBuilder.parseOrderByExpression(java.lang.String expression)
By default this calls parseSelectExpression(). |
|
SQLFragment |
SQLQueryBuilder.parseOrderByExpression(java.lang.String expression)
Parses an expression to see if it is a valid expression for a Order By object. |
|
static PlsqlRoot |
ParserUtils.parseQueryString(java.lang.String expression,
int type)
Parse an SQL expression |
|
SQLFragment |
AbstractSQLQueryBuilder.parseSelectExpression(java.lang.String expression)
|
|
SQLFragment |
SQLQueryBuilder.parseSelectExpression(java.lang.String expression)
Parses an expression to see if it is a valid expression for a Select object. |
|
protected abstract SQLFragment |
AbstractSQLQueryBuilder.parseSelectExpression(java.lang.String expression,
SelectObject creating)
|
|
SQLFragment |
AbstractSQLQueryBuilder.parseWhereExpression(java.lang.String expression)
|
|
SQLFragment |
SQLQueryBuilder.parseWhereExpression(java.lang.String expression)
Parses an expression to see if it is a valid expression for a Where object. |
|
abstract SQLFragment |
AbstractSQLQueryBuilder.parseWhereExpression(java.lang.String expression,
WhereObject creating)
|
|
void |
AbstractSQLQueryBuilder.replaceFromObject(FromObject oldFrom,
FromObject newFrom)
|
|
void |
SQLQueryBuilder.replaceFromObject(FromObject oldFrom,
FromObject newFrom)
Replaces the existing from object with a new one. |
|
void |
AbstractSQLQueryBuilder.replaceSelectObject(SelectObject oldSelect,
SelectObject newSelect)
|
|
void |
SQLQueryBuilder.replaceSelectObject(SelectObject oldSelect,
SelectObject newSelect)
Replaces the existing select object with a new one. |
|
protected
|
AbstractSQLQueryBuilder.throwException(T sqe)
|
|
void |
AbstractSQLQueryBuilder.validateQuery()
|
|
void |
SQLQueryBuilder.validateQuery()
Validates a query object to check that its internal structure is correct. |
|
Oracle Fusion Middleware Java API Reference for Oracle Extension SDK Reference 11g Release 1 (11.1.1) E13403-03 |
|||||||||
PREV NEXT | FRAMES NO FRAMES |