com.metamatrix.metadata.runtime.spi.jdbc
Class JDBCTranslator

java.lang.Object
  com.metamatrix.metadata.runtime.spi.jdbc.JDBCTranslator

public class JDBCTranslator
extends java.lang.Object

Field Summary

static java.lang.String	DELETE_MODEL
static java.lang.String	DELETE_MODEL_PROP_NMS
static java.lang.String	DELETE_MODEL_PROP_VALS
static java.lang.String	DELETE_VDB
static java.lang.String	DELETE_VDB_MODEL
static java.lang.String	DELETE_VDB_MODELS
static java.lang.String	INSERT_MODELS
static java.lang.String	INSERT_PROP_NAMES
static java.lang.String	INSERT_PROP_VALUES
static java.lang.String	INSERT_VDB_MODELS
static java.lang.String	INSERT_VDB_MODELS_WITH_BINDING
static java.lang.String	INSERT_VIRTUAL_DATABASE
static int	NA_INT
static long	NA_LONG
static short	NA_SHORT
static java.lang.String	SELECT_ACTIVE_VIRTUAL_DATABASE_ID
static java.lang.String	SELECT_ACTIVE_VIRTUAL_DATABASE_ID_LV
static java.lang.String	SELECT_DELETED_VIRTUAL_DATABASES
static java.lang.String	SELECT_MODEL_IDS
static java.lang.String	SELECT_MODEL_IDS_ONLY_IN_VDB
static java.lang.String	SELECT_MODELS
static java.lang.String	SELECT_PROPERTIES
static java.lang.String	SELECT_SCHEMA_UIDS
static java.lang.String	SELECT_VIRTUAL_DATABASE
static java.lang.String	SELECT_VIRTUAL_DATABASE_ID
static java.lang.String	SELECT_VIRTUAL_DATABASE_ID_LV
static java.lang.String	SELECT_VIRTUAL_DATABASES
static java.lang.String	UPDATE_CONNECTOR_BINGING_NAME
static java.lang.String	UPDATE_MODEL_NAME
static java.lang.String	UPDATE_SET_STATUS
static java.lang.String	UPDATE_VDB
static java.lang.String	UPDATE_VDB_MODELS
static java.lang.String	UPDATE_VDB_VERSION

Constructor Summary

JDBCTranslator()

Method Summary

static int	getCount(java.sql.ResultSet resultSet)
static Model	getModel(java.sql.ResultSet resultSet)
static java.util.List	getModelIDs(java.sql.ResultSet resultSet)
static java.util.Collection	getModels(java.sql.ResultSet resultSet, VirtualDatabaseID vdbID, java.util.Collection smUids)
static java.util.Properties	getProperties(java.sql.ResultSet resultSet)
static VirtualDatabase	getVirtualDatabase(java.sql.ResultSet resultSet, VirtualDatabaseID vdbID)
static VirtualDatabaseID	getVirtualDatabaseID(java.sql.ResultSet resultSet)
static java.util.Collection	getVirtualDatabaseIDs(java.sql.ResultSet resultSet)
static java.util.Collection	getVirtualDatabases(java.sql.ResultSet resultSet)

Methods inherited from class java.lang.Object

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

Field Detail

NA_LONG

public static long NA_LONG

NA_INT

public static int NA_INT

NA_SHORT

public static short NA_SHORT

SELECT_ACTIVE_VIRTUAL_DATABASE_ID

public static final java.lang.String SELECT_ACTIVE_VIRTUAL_DATABASE_ID

See Also:

Constant Field Values

SELECT_VIRTUAL_DATABASE_ID

public static final java.lang.String SELECT_VIRTUAL_DATABASE_ID

See Also:

Constant Field Values

SELECT_ACTIVE_VIRTUAL_DATABASE_ID_LV

public static final java.lang.String SELECT_ACTIVE_VIRTUAL_DATABASE_ID_LV

See Also:

Constant Field Values

SELECT_VIRTUAL_DATABASE_ID_LV

public static final java.lang.String SELECT_VIRTUAL_DATABASE_ID_LV

See Also:

Constant Field Values

SELECT_VIRTUAL_DATABASES

public static final java.lang.String SELECT_VIRTUAL_DATABASES

See Also:

Constant Field Values

SELECT_SCHEMA_UIDS

public static final java.lang.String SELECT_SCHEMA_UIDS

See Also:

Constant Field Values

SELECT_DELETED_VIRTUAL_DATABASES

public static final java.lang.String SELECT_DELETED_VIRTUAL_DATABASES

See Also:

Constant Field Values

SELECT_VIRTUAL_DATABASE

public static final java.lang.String SELECT_VIRTUAL_DATABASE

See Also:

Constant Field Values

SELECT_MODELS

public static final java.lang.String SELECT_MODELS

See Also:

Constant Field Values

SELECT_MODEL_IDS

public static final java.lang.String SELECT_MODEL_IDS

See Also:

Constant Field Values

SELECT_MODEL_IDS_ONLY_IN_VDB

public static final java.lang.String SELECT_MODEL_IDS_ONLY_IN_VDB

See Also:

Constant Field Values

SELECT_PROPERTIES

public static final java.lang.String SELECT_PROPERTIES

See Also:

Constant Field Values

INSERT_VIRTUAL_DATABASE

public static final java.lang.String INSERT_VIRTUAL_DATABASE

See Also:

Constant Field Values

INSERT_MODELS

public static final java.lang.String INSERT_MODELS

See Also:

Constant Field Values

INSERT_VDB_MODELS

public static final java.lang.String INSERT_VDB_MODELS

See Also:

Constant Field Values

INSERT_VDB_MODELS_WITH_BINDING

public static final java.lang.String INSERT_VDB_MODELS_WITH_BINDING

See Also:

Constant Field Values

INSERT_PROP_NAMES

public static final java.lang.String INSERT_PROP_NAMES

See Also:

Constant Field Values

INSERT_PROP_VALUES

public static final java.lang.String INSERT_PROP_VALUES

See Also:

Constant Field Values

UPDATE_SET_STATUS

public static final java.lang.String UPDATE_SET_STATUS

See Also:

Constant Field Values

UPDATE_CONNECTOR_BINGING_NAME

public static final java.lang.String UPDATE_CONNECTOR_BINGING_NAME

See Also:

Constant Field Values

UPDATE_VDB

public static final java.lang.String UPDATE_VDB

See Also:

Constant Field Values

UPDATE_VDB_VERSION

public static final java.lang.String UPDATE_VDB_VERSION

See Also:

Constant Field Values

UPDATE_VDB_MODELS

public static final java.lang.String UPDATE_VDB_MODELS

See Also:

Constant Field Values

UPDATE_MODEL_NAME

public static final java.lang.String UPDATE_MODEL_NAME

See Also:

Constant Field Values

DELETE_MODEL_PROP_VALS

public static final java.lang.String DELETE_MODEL_PROP_VALS

See Also:

Constant Field Values

DELETE_MODEL_PROP_NMS

public static final java.lang.String DELETE_MODEL_PROP_NMS

See Also:

Constant Field Values

DELETE_VDB_MODELS

public static final java.lang.String DELETE_VDB_MODELS

See Also:

Constant Field Values

DELETE_VDB_MODEL

public static final java.lang.String DELETE_VDB_MODEL

See Also:

Constant Field Values

DELETE_MODEL

public static final java.lang.String DELETE_MODEL

See Also:

Constant Field Values

DELETE_VDB

public static final java.lang.String DELETE_VDB

See Also:

Constant Field Values

Constructor Detail

JDBCTranslator

public JDBCTranslator()

Method Detail

getCount

public static int getCount(java.sql.ResultSet resultSet)
                    throws java.sql.SQLException

Throws:

java.sql.SQLException

getVirtualDatabases

public static java.util.Collection getVirtualDatabases(java.sql.ResultSet resultSet)
                                                throws java.sql.SQLException

Throws:

java.sql.SQLException

getVirtualDatabaseIDs

public static java.util.Collection getVirtualDatabaseIDs(java.sql.ResultSet resultSet)
                                                  throws java.sql.SQLException

Throws:

java.sql.SQLException

getVirtualDatabase

public static VirtualDatabase getVirtualDatabase(java.sql.ResultSet resultSet,
                                                 VirtualDatabaseID vdbID)
                                          throws java.sql.SQLException

Throws:

java.sql.SQLException

getVirtualDatabaseID

public static VirtualDatabaseID getVirtualDatabaseID(java.sql.ResultSet resultSet)
                                              throws java.sql.SQLException

Throws:

java.sql.SQLException

getModels

public static java.util.Collection getModels(java.sql.ResultSet resultSet,
                                             VirtualDatabaseID vdbID,
                                             java.util.Collection smUids)
                                      throws java.sql.SQLException

Throws:

java.sql.SQLException

getModelIDs

public static java.util.List getModelIDs(java.sql.ResultSet resultSet)
                                  throws java.sql.SQLException

Throws:

java.sql.SQLException

getModel

public static Model getModel(java.sql.ResultSet resultSet)
                      throws java.sql.SQLException

Throws:

java.sql.SQLException

getProperties

public static java.util.Properties getProperties(java.sql.ResultSet resultSet)
                                          throws java.sql.SQLException

Throws:

java.sql.SQLException