Skip navigation links

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

protected <T extends SQLQueryException> void

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

Skip navigation links