oracle.jdeveloper.deploy.sp
Class OracleDatatypeMappings

java.lang.Object
  oracle.jdeveloper.deploy.sp.OracleDatatypeMappings

public final class OracleDatatypeMappings
extends java.lang.Object

Provides utility methods for determining what legal data type mappings exist from Java to PL/SQL.

Field Summary

static java.lang.String	BOOLEAN
static java.lang.String	BYTE
static java.lang.String	BYTE_ARRAY
static java.lang.String	DOUBLE
static java.lang.String	FLOAT
static java.lang.String	INT
static java.lang.String	JAVA_LANG_BOOLEAN
static java.lang.String	JAVA_LANG_BYTE
static java.lang.String	JAVA_LANG_DOUBLE
static java.lang.String	JAVA_LANG_FLOAT
static java.lang.String	JAVA_LANG_INTEGER
static java.lang.String	JAVA_LANG_LONG
static java.lang.String	JAVA_LANG_SHORT
static java.lang.String	JAVA_LANG_STRING
static java.lang.String	JAVA_MATH_BIGDECIMAL
static java.lang.String	JAVA_SQL_ARRAY
static java.lang.String	JAVA_SQL_BLOB
static java.lang.String	JAVA_SQL_CLOB
static java.lang.String	JAVA_SQL_DATE
static java.lang.String	JAVA_SQL_REF
static java.lang.String	JAVA_SQL_STRUCT
static java.lang.String	JAVA_SQL_TIME
static java.lang.String	JAVA_SQL_TIMESTAMP
static java.lang.String	LONG
static java.lang.String	ORACLE_JDBC_ORACLEARRAY
static java.lang.String	ORACLE_JDBC_ORACLEBLOB
static java.lang.String	ORACLE_JDBC_ORACLECLOB
static java.lang.String	ORACLE_JDBC_ORACLEREF
static java.lang.String	ORACLE_JDBC_ORACLESTRUCT
static java.lang.String	ORACLE_JDBC2_ARRAY
static java.lang.String	ORACLE_JDBC2_BLOB
static java.lang.String	ORACLE_JDBC2_CLOB
static java.lang.String	ORACLE_JDBC2_REF
static java.lang.String	ORACLE_JDBC2_STRUCT
static java.lang.String	ORACLE_SQL_ARRAY
static java.lang.String	ORACLE_SQL_BFILE
static java.lang.String	ORACLE_SQL_BLOB
static java.lang.String	ORACLE_SQL_CHAR
static java.lang.String	ORACLE_SQL_CLOB
static java.lang.String	ORACLE_SQL_CUSTOMDATUM
static java.lang.String	ORACLE_SQL_DATE
static java.lang.String	ORACLE_SQL_DATUM
static java.lang.String	ORACLE_SQL_NUMBER
static java.lang.String	ORACLE_SQL_RAW
static java.lang.String	ORACLE_SQL_REF
static java.lang.String	ORACLE_SQL_ROWID
static java.lang.String	ORACLE_SQL_STRUCT
static java.lang.String	ORACLE_SQLJDATA
static java.lang.String	SHORT
static java.lang.String	SQL_BFILE
static java.lang.String	SQL_BLOB
static java.lang.String	SQL_CHAR
static java.lang.String	SQL_CLOB
static java.lang.String	SQL_DATE
static java.lang.String	SQL_LONG
static java.lang.String	SQL_LONG_RAW
static java.lang.String	SQL_NCHAR
static java.lang.String	SQL_NCLOB
static java.lang.String	SQL_NUMBER
static java.lang.String	SQL_NVARCHAR2
static java.lang.String	SQL_OBJECT
static java.lang.String	SQL_RAW
static java.lang.String	SQL_REF
static java.lang.String	SQL_ROWID
static java.lang.String	SQL_TABLE
static java.lang.String	SQL_VARCHAR2
static java.lang.String	SQL_VARRAY
static java.lang.String	UNDEFINED

Method Summary

static java.lang.String	getDefaultPlsqlMapping(java.lang.Class javaClass)
static java.lang.String	getDefaultPlsqlMapping(java.lang.String javaClassName)
static java.util.List	getPlsqlMappings(java.lang.Class javaClass) Given a Class object representing a Java data type, returns a List containing the possible PL/SQL data types that the Java type can be mapped to.
static java.util.List	getPlsqlMappings(java.lang.String className) Given a human-readable format of the classname (such as returned by JavaTypes.toDisplayName() or JotClass.getName()), returns a List of PL/SQL types that the Java type can be mapped to.
static boolean	hasPlsqlMapping(java.lang.Class javaClass) Given a Class object representing a Java data type, returns true if it can be mapped to a PL/SQL data type, false if not.
static boolean	hasPlsqlMapping(java.lang.String className) Given a String representing the name of a Java data type, returns true if it can be mapped to a PL/SQL data type, false if not.

Methods inherited from class java.lang.Object

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

Field Detail

SQL_BFILE

public static final java.lang.String SQL_BFILE

See Also:

Constant Field Values

SQL_BLOB

public static final java.lang.String SQL_BLOB

See Also:

Constant Field Values

SQL_CHAR

public static final java.lang.String SQL_CHAR

See Also:

Constant Field Values

SQL_CLOB

public static final java.lang.String SQL_CLOB

See Also:

Constant Field Values

SQL_DATE

public static final java.lang.String SQL_DATE

See Also:

Constant Field Values

SQL_LONG

public static final java.lang.String SQL_LONG

See Also:

Constant Field Values

SQL_LONG_RAW

public static final java.lang.String SQL_LONG_RAW

See Also:

Constant Field Values

SQL_NCHAR

public static final java.lang.String SQL_NCHAR

See Also:

Constant Field Values

SQL_NCLOB

public static final java.lang.String SQL_NCLOB

See Also:

Constant Field Values

SQL_NUMBER

public static final java.lang.String SQL_NUMBER

See Also:

Constant Field Values

SQL_NVARCHAR2

public static final java.lang.String SQL_NVARCHAR2

See Also:

Constant Field Values

SQL_OBJECT

public static final java.lang.String SQL_OBJECT

See Also:

Constant Field Values

SQL_RAW

public static final java.lang.String SQL_RAW

See Also:

Constant Field Values

SQL_REF

public static final java.lang.String SQL_REF

See Also:

Constant Field Values

SQL_ROWID

public static final java.lang.String SQL_ROWID

See Also:

Constant Field Values

SQL_TABLE

public static final java.lang.String SQL_TABLE

See Also:

Constant Field Values

SQL_VARCHAR2

public static final java.lang.String SQL_VARCHAR2

See Also:

Constant Field Values

SQL_VARRAY

public static final java.lang.String SQL_VARRAY

See Also:

Constant Field Values

UNDEFINED

public static final java.lang.String UNDEFINED

See Also:

Constant Field Values

BYTE

public static final java.lang.String BYTE

See Also:

Constant Field Values

BYTE_ARRAY

public static final java.lang.String BYTE_ARRAY

See Also:

Constant Field Values

DOUBLE

public static final java.lang.String DOUBLE

See Also:

Constant Field Values

FLOAT

public static final java.lang.String FLOAT

See Also:

Constant Field Values

INT

public static final java.lang.String INT

See Also:

Constant Field Values

BOOLEAN

public static final java.lang.String BOOLEAN

See Also:

Constant Field Values

JAVA_LANG_BYTE

public static final java.lang.String JAVA_LANG_BYTE

See Also:

Constant Field Values

JAVA_LANG_DOUBLE

public static final java.lang.String JAVA_LANG_DOUBLE

See Also:

Constant Field Values

JAVA_LANG_FLOAT

public static final java.lang.String JAVA_LANG_FLOAT

See Also:

Constant Field Values

JAVA_LANG_INTEGER

public static final java.lang.String JAVA_LANG_INTEGER

See Also:

Constant Field Values

JAVA_LANG_LONG

public static final java.lang.String JAVA_LANG_LONG

See Also:

Constant Field Values

JAVA_LANG_SHORT

public static final java.lang.String JAVA_LANG_SHORT

See Also:

Constant Field Values

JAVA_LANG_STRING

public static final java.lang.String JAVA_LANG_STRING

See Also:

Constant Field Values

JAVA_LANG_BOOLEAN

public static final java.lang.String JAVA_LANG_BOOLEAN

See Also:

Constant Field Values

JAVA_MATH_BIGDECIMAL

public static final java.lang.String JAVA_MATH_BIGDECIMAL

See Also:

Constant Field Values

JAVA_SQL_ARRAY

public static final java.lang.String JAVA_SQL_ARRAY

See Also:

Constant Field Values

JAVA_SQL_BLOB

public static final java.lang.String JAVA_SQL_BLOB

See Also:

Constant Field Values

JAVA_SQL_CLOB

public static final java.lang.String JAVA_SQL_CLOB

See Also:

Constant Field Values

JAVA_SQL_DATE

public static final java.lang.String JAVA_SQL_DATE

See Also:

Constant Field Values

JAVA_SQL_REF

public static final java.lang.String JAVA_SQL_REF

See Also:

Constant Field Values

JAVA_SQL_STRUCT

public static final java.lang.String JAVA_SQL_STRUCT

See Also:

Constant Field Values

JAVA_SQL_TIME

public static final java.lang.String JAVA_SQL_TIME

See Also:

Constant Field Values

JAVA_SQL_TIMESTAMP

public static final java.lang.String JAVA_SQL_TIMESTAMP

See Also:

Constant Field Values

LONG

public static final java.lang.String LONG

See Also:

Constant Field Values

ORACLE_JDBC2_ARRAY

public static final java.lang.String ORACLE_JDBC2_ARRAY

See Also:

Constant Field Values

ORACLE_JDBC2_BLOB

public static final java.lang.String ORACLE_JDBC2_BLOB

See Also:

Constant Field Values

ORACLE_JDBC2_CLOB

public static final java.lang.String ORACLE_JDBC2_CLOB

See Also:

Constant Field Values

ORACLE_JDBC2_REF

public static final java.lang.String ORACLE_JDBC2_REF

See Also:

Constant Field Values

ORACLE_JDBC2_STRUCT

public static final java.lang.String ORACLE_JDBC2_STRUCT

See Also:

Constant Field Values

ORACLE_JDBC_ORACLEARRAY

public static final java.lang.String ORACLE_JDBC_ORACLEARRAY

See Also:

Constant Field Values

ORACLE_JDBC_ORACLEBLOB

public static final java.lang.String ORACLE_JDBC_ORACLEBLOB

See Also:

Constant Field Values

ORACLE_JDBC_ORACLECLOB

public static final java.lang.String ORACLE_JDBC_ORACLECLOB

See Also:

Constant Field Values

ORACLE_JDBC_ORACLEREF

public static final java.lang.String ORACLE_JDBC_ORACLEREF

See Also:

Constant Field Values

ORACLE_JDBC_ORACLESTRUCT

public static final java.lang.String ORACLE_JDBC_ORACLESTRUCT

See Also:

Constant Field Values

ORACLE_SQLJDATA

public static final java.lang.String ORACLE_SQLJDATA

See Also:

Constant Field Values

ORACLE_SQL_ARRAY

public static final java.lang.String ORACLE_SQL_ARRAY

See Also:

Constant Field Values

ORACLE_SQL_BFILE

public static final java.lang.String ORACLE_SQL_BFILE

See Also:

Constant Field Values

ORACLE_SQL_BLOB

public static final java.lang.String ORACLE_SQL_BLOB

See Also:

Constant Field Values

ORACLE_SQL_CHAR

public static final java.lang.String ORACLE_SQL_CHAR

See Also:

Constant Field Values

ORACLE_SQL_CLOB

public static final java.lang.String ORACLE_SQL_CLOB

See Also:

Constant Field Values

ORACLE_SQL_CUSTOMDATUM

public static final java.lang.String ORACLE_SQL_CUSTOMDATUM

See Also:

Constant Field Values

ORACLE_SQL_DATE

public static final java.lang.String ORACLE_SQL_DATE

See Also:

Constant Field Values

ORACLE_SQL_DATUM

public static final java.lang.String ORACLE_SQL_DATUM

See Also:

Constant Field Values

ORACLE_SQL_NUMBER

public static final java.lang.String ORACLE_SQL_NUMBER

See Also:

Constant Field Values

ORACLE_SQL_RAW

public static final java.lang.String ORACLE_SQL_RAW

See Also:

Constant Field Values

ORACLE_SQL_REF

public static final java.lang.String ORACLE_SQL_REF

See Also:

Constant Field Values

ORACLE_SQL_ROWID

public static final java.lang.String ORACLE_SQL_ROWID

See Also:

Constant Field Values

ORACLE_SQL_STRUCT

public static final java.lang.String ORACLE_SQL_STRUCT

See Also:

Constant Field Values

SHORT

public static final java.lang.String SHORT

See Also:

Constant Field Values

Method Detail

getDefaultPlsqlMapping

public static java.lang.String getDefaultPlsqlMapping(java.lang.String javaClassName)

getDefaultPlsqlMapping

public static java.lang.String getDefaultPlsqlMapping(java.lang.Class javaClass)

getPlsqlMappings

public static java.util.List getPlsqlMappings(java.lang.Class javaClass)

Given a Class object representing a Java data type, returns a List containing the possible PL/SQL data types that the Java type can be mapped to. If no mappings are possible, null is returned.

hasPlsqlMapping

public static boolean hasPlsqlMapping(java.lang.Class javaClass)

Given a Class object representing a Java data type, returns true if it can be mapped to a PL/SQL data type, false if not.

getPlsqlMappings

public static java.util.List getPlsqlMappings(java.lang.String className)

Given a human-readable format of the classname (such as returned by JavaTypes.toDisplayName() or JotClass.getName()), returns a List of PL/SQL types that the Java type can be mapped to. If no mappings are possible, null is returned.

hasPlsqlMapping

public static boolean hasPlsqlMapping(java.lang.String className)

Given a String representing the name of a Java data type, returns true if it can be mapped to a PL/SQL data type, false if not.