com.metamatrix.common.types
Class MMJDBCSQLTypeInfo

java.lang.Object
  com.metamatrix.common.types.MMJDBCSQLTypeInfo

public final class MMJDBCSQLTypeInfo
extends java.lang.Object

This is a helper class used to obtain SQL type information for java types. The SQL type infomation is obtained from java.sql.Types class. The integers and strings retuned by methods in this class are based on constants in java.sql.Types.

Field Summary

static java.lang.String	BIGDECIMAL
static java.lang.String	BIGDECIMAL_CLASS
static java.lang.String	BIGINTEGER
static java.lang.String	BIGINTEGER_CLASS
static java.lang.String	BLOB
static java.lang.String	BLOB_CLASS
static java.lang.String	BOOLEAN
static java.lang.String	BOOLEAN_CLASS
static java.lang.String	BYTE
static java.lang.String	BYTE_CLASS
static java.lang.String	CHAR
static java.lang.String	CHAR_CLASS
static java.lang.String	CLOB
static java.lang.String	CLOB_CLASS
static java.lang.String	DATE
static java.lang.String	DATE_CLASS
static java.lang.String	DOUBLE
static java.lang.String	DOUBLE_CLASS
static java.lang.String	FLOAT
static java.lang.String	FLOAT_CLASS
static java.lang.String	INTEGER
static java.lang.String	INTEGER_CLASS
static java.lang.String	LONG
static java.lang.String	LONG_CLASS
static java.lang.String	NULL
static java.lang.String	OBJECT
static java.lang.String	OBJECT_CLASS
static java.lang.String	SHORT
static java.lang.String	SHORT_CLASS
static java.lang.String	STRING
static java.lang.String	STRING_CLASS
static java.lang.String	TIME
static java.lang.String	TIME_CLASS
static java.lang.String	TIMESTAMP
static java.lang.String	TIMESTAMP_CLASS
static java.lang.String	XML
static java.lang.String	XML_CLASS

Method Summary

static java.lang.String	getJavaClassName(int jdbcSQLType) This method is used to obtain a the java class name given an int value indicating JDBC SQL type.
static java.lang.String[]	getMMTypeNames()
static int	getSQLType(java.lang.String typeName) This method is used to obtain a short indicating JDBC SQL type for any object.
static int	getSQLTypeFromClass(java.lang.String typeName) Get sql Type from java class type name.
static int	getSQLTypeFromRuntimeType(java.lang.Class type) Get the sql type from the given runtime type

Methods inherited from class java.lang.Object

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

Field Detail

STRING

public static final java.lang.String STRING

See Also:

Constant Field Values

BOOLEAN

public static final java.lang.String BOOLEAN

See Also:

Constant Field Values

TIME

public static final java.lang.String TIME

See Also:

Constant Field Values

DATE

public static final java.lang.String DATE

See Also:

Constant Field Values

TIMESTAMP

public static final java.lang.String TIMESTAMP

See Also:

Constant Field Values

INTEGER

public static final java.lang.String INTEGER

See Also:

Constant Field Values

FLOAT

public static final java.lang.String FLOAT

See Also:

Constant Field Values

DOUBLE

public static final java.lang.String DOUBLE

See Also:

Constant Field Values

BIGDECIMAL

public static final java.lang.String BIGDECIMAL

See Also:

Constant Field Values

BIGINTEGER

public static final java.lang.String BIGINTEGER

See Also:

Constant Field Values

BYTE

public static final java.lang.String BYTE

See Also:

Constant Field Values

SHORT

public static final java.lang.String SHORT

See Also:

Constant Field Values

LONG

public static final java.lang.String LONG

See Also:

Constant Field Values

CHAR

public static final java.lang.String CHAR

See Also:

Constant Field Values

OBJECT

public static final java.lang.String OBJECT

See Also:

Constant Field Values

CLOB

public static final java.lang.String CLOB

See Also:

Constant Field Values

BLOB

public static final java.lang.String BLOB

See Also:

Constant Field Values

XML

public static final java.lang.String XML

See Also:

Constant Field Values

NULL

public static final java.lang.String NULL

See Also:

Constant Field Values

STRING_CLASS

public static final java.lang.String STRING_CLASS

BOOLEAN_CLASS

public static final java.lang.String BOOLEAN_CLASS

TIME_CLASS

public static final java.lang.String TIME_CLASS

DATE_CLASS

public static final java.lang.String DATE_CLASS

TIMESTAMP_CLASS

public static final java.lang.String TIMESTAMP_CLASS

INTEGER_CLASS

public static final java.lang.String INTEGER_CLASS

FLOAT_CLASS

public static final java.lang.String FLOAT_CLASS

DOUBLE_CLASS

public static final java.lang.String DOUBLE_CLASS

BIGDECIMAL_CLASS

public static final java.lang.String BIGDECIMAL_CLASS

BYTE_CLASS

public static final java.lang.String BYTE_CLASS

SHORT_CLASS

public static final java.lang.String SHORT_CLASS

LONG_CLASS

public static final java.lang.String LONG_CLASS

CHAR_CLASS

public static final java.lang.String CHAR_CLASS

BIGINTEGER_CLASS

public static final java.lang.String BIGINTEGER_CLASS

OBJECT_CLASS

public static final java.lang.String OBJECT_CLASS

CLOB_CLASS

public static final java.lang.String CLOB_CLASS

See Also:

Constant Field Values

BLOB_CLASS

public static final java.lang.String BLOB_CLASS

See Also:

Constant Field Values

XML_CLASS

public static final java.lang.String XML_CLASS

See Also:

Constant Field Values

Method Detail

getSQLType

public static final int getSQLType(java.lang.String typeName)

This method is used to obtain a short indicating JDBC SQL type for any object. The short values that give the type info are from java.sql.Types.

Parameters:

Name - of the metamatrix type.

Returns:

A short value representing SQL Type for the given java type.

getSQLTypeFromClass

public static final int getSQLTypeFromClass(java.lang.String typeName)

Get sql Type from java class type name. This should not be called with runtime types as Clob and Blob are represented by ClobType and BlobType respectively.

Parameters:

typeName -

Returns:

int

getSQLTypeFromRuntimeType

public static final int getSQLTypeFromRuntimeType(java.lang.Class type)

Get the sql type from the given runtime type

Parameters:

type -

Returns:

getJavaClassName

public static final java.lang.String getJavaClassName(int jdbcSQLType)

This method is used to obtain a the java class name given an int value indicating JDBC SQL type. The int values that give the type info are from java.sql.Types.

Parameters:

int - value giving the SQL type code.

Returns:

A String representing the java class name for the given SQL Type.

getMMTypeNames

public static java.lang.String[] getMMTypeNames()