org.eclipse.datatools.enablement.msft.internal.sqlserver.loaders
Class SQL2005RoutineLoader

java.lang.Object
  org.eclipse.datatools.connectivity.sqm.loader.JDBCBaseLoader
      org.eclipse.datatools.connectivity.sqm.loader.JDBCRoutineLoader
          org.eclipse.datatools.enablement.msft.internal.sqlserver.loaders.SQL2005RoutineLoader

public class SQL2005RoutineLoader
extends JDBCRoutineLoader

Nested Class Summary

static class	SQL2005RoutineLoader.SQL2005ProcedureFactory
static class	SQL2005RoutineLoader.SQL2005UserDefinedFunctionFactory

Nested classes/interfaces inherited from class org.eclipse.datatools.connectivity.sqm.loader.JDBCRoutineLoader

JDBCRoutineLoader.IRoutineFactory, JDBCRoutineLoader.ProcedureFactory, JDBCRoutineLoader.UserDefinedFunctionFactory

Field Summary

static java.lang.String	COLUMN_ROUTINE_CATALOG
static java.lang.String	COLUMN_ROUTINE_DEFINITION
static java.lang.String	COLUMN_ROUTINE_NAME
static java.lang.String	COLUMN_ROUTINE_SCHEMA
static java.lang.String	COLUMN_ROUTINE_TYPE

Fields inherited from class org.eclipse.datatools.connectivity.sqm.loader.JDBCRoutineLoader

COLUMN_PROCEDURE_NAME, COLUMN_PROCEDURE_TYPE, COLUMN_REMARKS

Constructor Summary

SQL2005RoutineLoader()

SQL2005RoutineLoader(ICatalogObject catalogObject)

SQL2005RoutineLoader(ICatalogObject catalogObject, IConnectionFilterProvider connectionFilterProvider)

SQL2005RoutineLoader(ICatalogObject catalogObject, IConnectionFilterProvider connectionFilterProvider, JDBCRoutineLoader.IRoutineFactory udfFactory, JDBCRoutineLoader.IRoutineFactory spFactory)

Method Summary

JDBCRoutineLoader.IRoutineFactory	getProcedureFactory()
JDBCRoutineLoader.IRoutineFactory	getUserDefinedFunctionFactory() Sets the UDF factory used by this object
void	loadRoutines(java.util.List containmentList, java.util.Collection existingRoutines) Loads the "routine" objects from the database.

Methods inherited from class org.eclipse.datatools.connectivity.sqm.loader.JDBCRoutineLoader

clearRoutines, loadRoutines, setProcedureFactory, setUserDefinedFunctionFactory

Methods inherited from class org.eclipse.datatools.connectivity.sqm.loader.JDBCBaseLoader

getCatalogObject, setCatalogObject

Methods inherited from class java.lang.Object

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

Field Detail

COLUMN_ROUTINE_NAME

public static final java.lang.String COLUMN_ROUTINE_NAME

See Also:

Constant Field Values

COLUMN_ROUTINE_CATALOG

public static final java.lang.String COLUMN_ROUTINE_CATALOG

See Also:

Constant Field Values

COLUMN_ROUTINE_SCHEMA

public static final java.lang.String COLUMN_ROUTINE_SCHEMA

See Also:

Constant Field Values

COLUMN_ROUTINE_TYPE

public static final java.lang.String COLUMN_ROUTINE_TYPE

See Also:

Constant Field Values

COLUMN_ROUTINE_DEFINITION

public static final java.lang.String COLUMN_ROUTINE_DEFINITION

See Also:

Constant Field Values

Constructor Detail

SQL2005RoutineLoader

public SQL2005RoutineLoader()

SQL2005RoutineLoader

public SQL2005RoutineLoader(ICatalogObject catalogObject)

SQL2005RoutineLoader

public SQL2005RoutineLoader(ICatalogObject catalogObject,
                            IConnectionFilterProvider connectionFilterProvider)

SQL2005RoutineLoader

public SQL2005RoutineLoader(ICatalogObject catalogObject,
                            IConnectionFilterProvider connectionFilterProvider,
                            JDBCRoutineLoader.IRoutineFactory udfFactory,
                            JDBCRoutineLoader.IRoutineFactory spFactory)

Method Detail

getProcedureFactory

public JDBCRoutineLoader.IRoutineFactory getProcedureFactory()

Overrides:

getProcedureFactory in class JDBCRoutineLoader

Returns:

the procedure factory used by this object

getUserDefinedFunctionFactory

public JDBCRoutineLoader.IRoutineFactory getUserDefinedFunctionFactory()

Description copied from class: JDBCRoutineLoader

Sets the UDF factory used by this object

Overrides:

getUserDefinedFunctionFactory in class JDBCRoutineLoader

loadRoutines

public void loadRoutines(java.util.List containmentList,
                         java.util.Collection existingRoutines)
                  throws java.sql.SQLException

Description copied from class: JDBCRoutineLoader

Loads the "routine" objects from the database. This method uses the result set from createResultSet() to load the "routine" objects from the server. This method first checks the name of the "routine" to determine whether or not it should be filtered. If it is not filtered, it checks to see if an object with that name was loaded previously. If it finds an existing object, it refreshes that object and adds it to the containment list. If the named object does not exist, the result set is passed processRow(). Routine objects are created and initialized using one of the registered factories. This method should only be overridden as a last resort when the desired behavior cannot be acheived by overriding createResultSet(), closeResultSet(), processRow(), and a specialized SP and UDF factories.

Overrides:

loadRoutines in class JDBCRoutineLoader

Parameters:

containmentList - the containment list held by parent

existingRoutines - the catalog objects which were previously loaded

Throws:

java.sql.SQLException - if an error occurred during loading.