| 
 | Oracle Fusion Middleware Java API Reference for Oracle Extension SDK Reference 11g Release 1 (11.1.1.6.0) E13403-07 | |||||||||
| 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 | AliasInUseExceptionSQLQueryException thrown when an attempt is made to add an object whose alias is already in use. | 
|  class | AmbiguousColumnExceptionException thrown when the name of a column in a query is ambiguous - i.e. | 
|  class | IDExceptionException thrown when a DBObject is missing an ID. | 
|  class | InvalidAliasExceptionException thrown when a select or from object has an invalid alias (e.g. | 
|  class | InvalidSQLExceptionSQLQueryException for representing errors in the sql (e.g. | 
|  class | SQLParseExceptionSubclass of SQLQueryException used for parse errors in the sql. | 
|  class | SQLQueryClauseExceptionException 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 expressionof SqlDriver typetype. | |
| 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.6.0) E13403-07 | |||||||||
| PREV NEXT | FRAMES NO FRAMES | |||||||||