|
Oracle Fusion Middleware Java API Reference for Oracle Extension SDK Reference 11g Release 1 (11.1.1.5.0) E13403-06 |
|||||||||
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 |
SQLQueryBuilder.addFromObject(FromObject from) Adds the given FromObject to the query. |
|
void |
AbstractSQLQueryBuilder.addFromObject(FromObject from) |
|
void |
SQLQueryBuilder.addSelectObject(int index, SelectObject select) Inserts the given SelectObject to the query at the given index. |
|
void |
AbstractSQLQueryBuilder.addSelectObject(int index, SelectObject select) |
|
void |
SQLQueryBuilder.addSelectObject(SelectObject select) Adds the given SelectObject to the query. |
|
void |
AbstractSQLQueryBuilder.addSelectObject(SelectObject select) |
|
void |
SQLQueryBuilder.buildQuery(SQLQuery query) Builds the query based on the given SQLQuery. |
|
abstract void |
AbstractSQLQueryBuilder.buildQuery(SQLQuery query) Builds the query based on the given SQLQuery. |
|
void |
SQLQueryBuilder.buildQuery(java.lang.String select) Builds the query based on the given select statement. |
|
void |
AbstractSQLQueryBuilder.buildQuery(java.lang.String sql) Builds a query object from the given sql expression. |
|
void |
SQLQueryBuilder.buildQuery(java.lang.String select, SQLQueryOwner owner) 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. |
|
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 |
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.constructFKJoin(FKConstraint fk, FromObject left, FromObject right) |
|
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.constructFKJoins(FKConstraint[] fks, FromObject[] usagesToUse) |
|
SQLQueryBuilder.SQLQueryObjectSet |
SQLQueryBuilder.constructFromObject(Relation relation, boolean createSelectObjects, boolean createJoins, FromObject[] includeInJoins) Creates a FromObject for the query. |
|
SQLQueryBuilder.SQLQueryObjectSet |
AbstractSQLQueryBuilder.constructFromObject(Relation relation, boolean createSelectObjects, boolean createJoins, FromObject[] includeInJoins) |
|
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. |
|
FromObject |
AbstractSQLQueryBuilder.constructFromObject(java.lang.String expression, java.lang.String alias) |
|
SQLQueryBuilder.SQLQueryObjectSet |
SQLQueryBuilder.constructFromObjects(Relation[] baseRelations, boolean createSelectObjects, boolean createJoins, FromObject[] includeInJoins) Creates one or more FromObjects for the query. |
|
SQLQueryBuilder.SQLQueryObjectSet |
AbstractSQLQueryBuilder.constructFromObjects(Relation[] baseRelations, boolean createSelectObjects, boolean createJoins, FromObject[] includeInJoins) |
|
SQLQueryBuilder.SQLQueryObjectSet |
SQLQueryBuilder.constructSelectObject(Column col, FromObject usageToUse) Creates a SelectObject for the query based on the column passed in. |
|
SQLQueryBuilder.SQLQueryObjectSet |
AbstractSQLQueryBuilder.constructSelectObject(Column col, FromObject usageToUse) |
|
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. |
|
SelectObject |
AbstractSQLQueryBuilder.constructSelectObject(java.lang.String expression, java.lang.String alias) |
|
SQLQueryBuilder.SQLQueryObjectSet |
SQLQueryBuilder.constructSelectObjects(Column[] baseCols, FromObject[] usagesToUse) Creates a set of SelectObjects for the query based on the columns passed in. |
|
SQLQueryBuilder.SQLQueryObjectSet |
AbstractSQLQueryBuilder.constructSelectObjects(Column[] baseCols, FromObject[] usagesToUse) |
|
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 |
SQLQueryBuilder.mergeRelationUsages(RelationUsage baseUsage, RelationUsage mergingUsage) Merges two RelationUsages into one. |
|
void |
AbstractSQLQueryBuilder.mergeRelationUsages(RelationUsage baseUsage, RelationUsage mergingUsage) |
|
SQLFragment |
SQLQueryBuilder.parseFromExpression(java.lang.String expression) Parses an expression to see if it is a valid expression for a From object. |
|
SQLFragment |
AbstractSQLQueryBuilder.parseFromExpression(java.lang.String expression) |
|
protected abstract SQLFragment |
AbstractSQLQueryBuilder.parseFromExpression(java.lang.String expression, FromObject creating) |
|
SQLFragment |
SQLQueryBuilder.parseHavingExpression(java.lang.String expression) Parses an expression to see if it is a valid expression for a Having object. |
|
SQLFragment |
AbstractSQLQueryBuilder.parseHavingExpression(java.lang.String expression) By default this calls parseWhereExpression(). |
|
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 |
SQLQueryBuilder.parseOrderByExpression(java.lang.String expression) Parses an expression to see if it is a valid expression for a Order By object. |
|
SQLFragment |
AbstractSQLQueryBuilder.parseOrderByExpression(java.lang.String expression) By default this calls parseSelectExpression(). |
|
static PlsqlRoot |
ParserUtils.parseQueryString(java.lang.String expression, int type) Parse an SQL expression |
|
SQLFragment |
SQLQueryBuilder.parseSelectExpression(java.lang.String expression) Parses an expression to see if it is a valid expression for a Select object. |
|
SQLFragment |
AbstractSQLQueryBuilder.parseSelectExpression(java.lang.String expression) |
|
protected abstract SQLFragment |
AbstractSQLQueryBuilder.parseSelectExpression(java.lang.String expression, SelectObject creating) |
|
SQLFragment |
SQLQueryBuilder.parseWhereExpression(java.lang.String expression) Parses an expression to see if it is a valid expression for a Where object. |
|
SQLFragment |
AbstractSQLQueryBuilder.parseWhereExpression(java.lang.String expression) |
|
abstract SQLFragment |
AbstractSQLQueryBuilder.parseWhereExpression(java.lang.String expression, WhereObject creating) |
|
void |
SQLQueryBuilder.replaceFromObject(FromObject oldFrom, FromObject newFrom) Replaces the existing from object with a new one. |
|
void |
AbstractSQLQueryBuilder.replaceFromObject(FromObject oldFrom, FromObject newFrom) |
|
void |
SQLQueryBuilder.replaceSelectObject(SelectObject oldSelect, SelectObject newSelect) Replaces the existing select object with a new one. |
|
void |
AbstractSQLQueryBuilder.replaceSelectObject(SelectObject oldSelect, SelectObject newSelect) |
|
protected
|
AbstractSQLQueryBuilder.throwException(T sqe) |
|
void |
SQLQueryBuilder.validateQuery() Validates a query object to check that its internal structure is correct. |
|
void |
AbstractSQLQueryBuilder.validateQuery() |
|
Oracle Fusion Middleware Java API Reference for Oracle Extension SDK Reference 11g Release 1 (11.1.1.5.0) E13403-06 |
|||||||||
PREV NEXT | FRAMES NO FRAMES |