oracle.javatools.db.sql
Class SQLQueryBuilderFactory

java.lang.Object
  oracle.javatools.db.sql.SQLQueryBuilderFactory

public abstract class SQLQueryBuilderFactory
extends java.lang.Object

Factory class for creating a SQLQueryBuilder. The appropriate factory can be accessed from the DatabaseDesriptor appropriate to the type of database you are interested in.

Since:

11.1.1.1.0 - previously this factory consisted of only static methods, without a factory hook into the DatabaseDescriptor.

See Also:

DatabaseDescriptor.getSQLQueryBuilderFactory()

Constructor Summary

SQLQueryBuilderFactory()

Method Summary

static SQLQueryBuilder	createBuilder(DBObjectProvider provider) Creates a new builder for the given provider.
static SQLQueryBuilder	createBuilder(DBObjectProvider provider, Schema schema) Creates a new builder for the given provider with a given default schema.
static SQLQueryBuilder	createBuilder(DBObjectProvider provider, Schema defaultSchema, SQLQuery query) Deprecated.
static SQLQueryBuilder	createBuilder(DBObjectProvider provider, Schema defaultSchema, java.lang.String sqlText) Deprecated.
static SQLQueryBuilder	createBuilder(DBObjectProvider provider, SQLQuery query) Deprecated.
static SQLQueryBuilder	createBuilder(DBObjectProvider provider, SQLQueryOwner owner, java.lang.String sqlText) Deprecated.
static SQLQueryBuilder	createBuilder(DBObjectProvider provider, java.lang.String sqlText) Deprecated.
protected abstract SQLQueryBuilder	createBuilderImpl(DBObjectProvider provider, Schema schema) Implementation of creating the actual builder.
static SQLQuery	createQuery(DBObjectProvider provider, Schema defaultSchema, java.lang.String sqlText) Deprecated.
static SQLQuery	createQuery(DBObjectProvider provider, SQLQueryOwner owner, java.lang.String sqlText) Deprecated.
SQLQueryBuilder	createSQLQueryBuilder(DBObjectProvider provider) Creates a new SQLQueryBuilder.
SQLQueryBuilder	createSQLQueryBuilder(DBObjectProvider provider, Schema defaultSchema) Creates a new SQLQueryBuilder.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

SQLQueryBuilderFactory

public SQLQueryBuilderFactory()

Method Detail

createSQLQueryBuilder

public final SQLQueryBuilder createSQLQueryBuilder(DBObjectProvider provider)

Creates a new SQLQueryBuilder. The default schema for the provider will be used as the default schema for the SQL.

Parameters:

provider - the base DBObjectProvider

Returns:

a SQLQueryBuilder implementation for building SQLQuery objects.

createSQLQueryBuilder

public final SQLQueryBuilder createSQLQueryBuilder(DBObjectProvider provider,
                                                   Schema defaultSchema)

Creates a new SQLQueryBuilder.

Parameters:

provider - the base DBObjectProvider

defaultSchema - the default schema for the SQL to use

Returns:

a SQLQueryBuilder implementation for building SQLQuery objects.

createBuilderImpl

protected abstract SQLQueryBuilder createBuilderImpl(DBObjectProvider provider,
                                                     Schema schema)

Implementation of creating the actual builder. Subclasses must implement this.

createBuilder

public static SQLQueryBuilder createBuilder(DBObjectProvider provider)

Creates a new builder for the given provider. This is a utility method that gets the provider's DatabaseDescriptor and uses that to get a SQLQueryBuilderFactory implementation to create a new builder.

See Also:

DatabaseDescriptor.getSQLQueryBuilderFactory(), createSQLQueryBuilder(DBObjectProvider)

createBuilder

public static SQLQueryBuilder createBuilder(DBObjectProvider provider,
                                            Schema schema)

Creates a new builder for the given provider with a given default schema. This is a utility method that gets the provider's DatabaseDescriptor and uses that to get a SQLQueryBuilderFactory implementation to create a new builder.

See Also:

DatabaseDescriptor.getSQLQueryBuilderFactory(), createSQLQueryBuilder(DBObjectProvider,Schema)

createQuery

@Deprecated
public static SQLQuery createQuery(DBObjectProvider provider,
                                              Schema defaultSchema,
                                              java.lang.String sqlText)
                            throws SQLParseException

Deprecated.

Attemps to parse the given sql text and create a SQLQuery from it. If the query parses declaratively then an appropriate DeclarativeSQLQuery implementation is returned - else a NonDeclarativeSQLQuery is returned.

If the given string is null or empty an empty query will be returned.

Throws:

SQLParseException

createQuery

@Deprecated
public static SQLQuery createQuery(DBObjectProvider provider,
                                              SQLQueryOwner owner,
                                              java.lang.String sqlText)
                            throws SQLParseException

Deprecated.

Attemps to parse the given sql text and create a SQLQuery from it. If the query parses declaratively then an appropriate DeclarativeSQLQuery implementation is returned - else a NonDeclarativeSQLQuery is returned.

If the given string is null or empty an empty query will be returned.

Throws:

SQLParseException

createBuilder

@Deprecated
public static SQLQueryBuilder createBuilder(DBObjectProvider provider,
                                                       SQLQuery query)
                                     throws SQLQueryException

Deprecated.

Returns a builder for the given provider and query.

Throws:

SQLQueryException

createBuilder

@Deprecated
public static SQLQueryBuilder createBuilder(DBObjectProvider provider,
                                                       Schema defaultSchema,
                                                       SQLQuery query)
                                     throws SQLQueryException

Deprecated.

Returns a builder for the given provider and query using a default schema.

Throws:

SQLQueryException

createBuilder

@Deprecated
public static SQLQueryBuilder createBuilder(DBObjectProvider provider,
                                                       java.lang.String sqlText)
                                     throws SQLQueryException

Deprecated.

Returns a builder for the given provider by building the given sql text into a query. If the text is empty or null the builder will have an empty query.

Throws:

SQLQueryException

createBuilder

@Deprecated
public static SQLQueryBuilder createBuilder(DBObjectProvider provider,
                                                       Schema defaultSchema,
                                                       java.lang.String sqlText)
                                     throws SQLQueryException

Deprecated.

Returns a builder for the given provider by building the given sql text into a query using the default schema. If the text is empty or null the builder will have an empty query.

Throws:

SQLQueryException

createBuilder

@Deprecated
public static SQLQueryBuilder createBuilder(DBObjectProvider provider,
                                                       SQLQueryOwner owner,
                                                       java.lang.String sqlText)
                                     throws SQLQueryException

Deprecated.

Returns a builder for the given provider by building the given sql text into a query using the default schema. If the text is empty or null the builder will have an empty query.

Throws:

SQLQueryException