|
Oracle Fusion Middleware Java API Reference for Oracle Extension SDK 11g Release 2 (11.1.2.3.0) E17493-04 |
|||||||||
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 | ||
---|---|---|
|
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. |
|
void |
SQLQueryBuilder.addSetOperatorObject(SetOperator select) Adds the given SetOperator to the query. |
|
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) Deprecated. |
|
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) |
|
FromObject |
SQLQueryBuilder.createJoinObject(FKConstraint fk, FromObject left, FromObject right) Creates a FromObject that joins using a JoinCondition matching the given FK and joins the two from objects. |
|
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) |
|
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. |
|
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) |
|
FromObjectUsage |
AbstractSQLQueryBuilder.findColumnInRelation(java.lang.String colName, Relation rel) Warning: The returned ColumnUsage won't have a FromObject set. |
|
FromObjectUsage |
AbstractSQLQueryBuilder.findColumnInRelation(java.lang.String colName, RelationUsage relU) |
|
ColumnUsage |
AbstractSQLQueryBuilder.findColumnInStarSubQuery(java.lang.String colName, FromObject from) The from object is of the form (SELECT * FROM <rel>) <alias> |
|
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) Deprecated. |
|
static java.util.Collection<java.lang.String[]> |
ParserUtils.getColumnNames(java.lang.String expression, SQLFragmentExpressionBuilder.ExpressionType type, DBObjectProvider prov, Relation rel) Returns a Collection of names of the columns used in expression . |
|
static SQLFragment |
SQLFragmentExpressionBuilder.getExpression(DBObjectProvider provider, Relation relation, SQLFragmentExpressionBuilder.ExpressionType type, java.lang.String expression, boolean ignorErrors) For the given relation in the given provider, creates a SQLFragment condition representing the condition (such as a where clause predicate or check constraint) If the parser fails, return a SimpleSQLFragment for the expression string. |
|
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 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) |
|
SQLFragment |
SQLQueryBuilder.parseOrderByExpression(java.lang.String expression) Parses an expression to see if it is a valid expression for a Order By object. |
|
protected SQLFragment |
AbstractSQLQueryBuilder.parseOrderByExpression(java.lang.String expression, OrderByObject obo) |
|
static PlsqlRoot |
ParserUtils.parseQueryString(java.lang.String expression, int type) Deprecated. |
|
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 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. |
|
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. |
|
|
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 11g Release 2 (11.1.2.3.0) E17493-04 |
|||||||||
PREV NEXT | FRAMES NO FRAMES |