Uses of Class
oracle.javatools.db.sql.SQLQueryException

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

<T extends SQLQueryException> void

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 )
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.
<T extends SQLQueryException> void	AbstractSQLQueryBuilder.throwException(T sqe)
void	AbstractSQLQueryBuilder.validateQuery()
void	SQLQueryBuilder.validateQuery() Validates a query object to check that its internal structure is correct.