CType (josef 3.2.5 API)

java.lang.Object
- java.lang.Enum<CType>
- - org.josef.jdbc.CType

All Implemented Interfaces:

Serializable, Comparable<CType>
```
@Status(stage=PRODUCTION,
        unitTests=COMPLETE)
 @Reviews(value=@Review(by="Kees Schotanus",at="2009-04-11"))
public enum CType
extends Enum<CType>
```
Enumeration of JDBC types.
Use this class as a substitute for Types.
Constants in this class can for example be used to pass null bind variables. Oracle for example doesn't handle insertion of a null bind variable and requires the proper type of the null value instead.

Version:

1.0 $Revision: 6488 $

Author:

Kees Schotanus

Enum Constant Summary

Enum Constants
Enum Constant and Description
`ARRAY` Wrapper for `Types.ARRAY`.
`BIGINT` Wrapper for `Types.BIGINT`.
`BINARY` Wrapper for `Types.BINARY`.
`BIT` Wrapper for `Types.BIT`.
`BLOB` Wrapper for `Types.BLOB`.
`BOOLEAN` Wrapper for `Types.BOOLEAN`.
`CHAR` Wrapper for `Types.CHAR`.
`CLOB` Wrapper for `Types.CLOB`.
`DATALINK` Wrapper for `Types.DATALINK`.
`DATE` Wrapper for `Types.DATE`.
`DECIMAL` Wrapper for `Types.DECIMAL`.
`DISTINCT` Wrapper for `Types.DISTINCT`.
`DOUBLE` Wrapper for `Types.DOUBLE`.
`FLOAT` Wrapper for `Types.FLOAT`.
`INTEGER` Wrapper for `Types.INTEGER`.
`JAVA_OBJECT` Wrapper for `Types.JAVA_OBJECT`.
`LONGNVARCHAR` Wrapper for `Types.LONGNVARCHAR`.
`LONGVARBINARY` Wrapper for `Types.LONGVARBINARY`.
`LONGVARCHAR` Wrapper for `Types.LONGVARCHAR`.
`NCHAR` Wrapper for `Types.NCHAR`.
`NCLOB` Wrapper for `Types.NCLOB`.
`NULL` Wrapper for `Types.NULL`.
`NUMERIC` Wrapper for `Types.NUMERIC`.
`NVARCHAR` Wrapper for `Types.NVARCHAR`.
`OTHER` Wrapper for `Types.OTHER`.
`REAL` Wrapper for `Types.REAL`.
`REF` Wrapper for `Types.REF`.
`REF_CURSOR` Wrapper for `Types.REF_CURSOR`.
`ROWID` Wrapper for `Types.ROWID`.
`SMALLINT` Wrapper for `Types.SMALLINT`.
`SQLXML` Wrapper for `Types.SQLXML`.
`STRUCT` Wrapper for `Types.STRUCT`.
`TIME` Wrapper for `Types.TIME`.
`TIME_WITH_TIMEZONE` Wrapper for `Types.TIME_WITH_TIMEZONE`.
`TIMESTAMP` Wrapper for `Types.TIMESTAMP`.
`TIMESTAMP_WITH_TIMEZONE` Wrapper for `Types.TIMESTAMP_WITH_TIMEZONE`.
`TINYINT` Wrapper for `Types.TINYINT`.
`VARBINARY` Wrapper for `Types.VARBINARY`.
`VARCHAR` Wrapper for `Types.VARCHAR`.

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`static Object`	`getBindVariable(Array value)` Helper method to either return the supplied value or the corresponding JDBC Type when the supplied value is null.
`static Object`	`getBindVariable(BigDecimal value)` Helper method to either return the supplied value or the corresponding JDBC Type when the supplied value is null.
`static Object`	`getBindVariable(BigInteger value)` Helper method to either return the supplied value or the corresponding JDBC Type when the supplied value is null.
`static Object`	`getBindVariable(Blob value)` Helper method to either return the supplied value or the corresponding JDBC Type when the supplied value is null.
`static Object`	`getBindVariable(Boolean value)` Helper method to either return the supplied value or the corresponding JDBC Type when the supplied value is null.
`static Object`	`getBindVariable(Byte value)` Helper method to either return the supplied value or the corresponding JDBC Type when the supplied value is null.
`static Object`	`getBindVariable(byte[] value)` Helper method to either return the supplied value or the corresponding JDBC Type when the supplied value is null.
`static Object`	`getBindVariable(Character value)` Helper method to either return the supplied value or the corresponding JDBC Type when the supplied value is null.
`static Object`	`getBindVariable(Clob value)` Helper method to either return the supplied value or the corresponding JDBC Type when the supplied value is null.
`static Object`	`getBindVariable(Date value)` Helper method to either return the supplied value or the corresponding JDBC Type when the supplied value is null.
`static Object`	`getBindVariable(Double value)` Helper method to either return the supplied value or the corresponding JDBC Type when the supplied value is null.
`static Object`	`getBindVariable(Float value)` Helper method to either return the supplied value or the corresponding JDBC Type when the supplied value is null.
`static Object`	`getBindVariable(Integer value)` Helper method to either return the supplied value or the corresponding JDBC Type when the supplied value is null.
`static Object`	`getBindVariable(Long value)` Helper method to either return the supplied value or the corresponding JDBC Type when the supplied value is null.
`static Object`	`getBindVariable(NClob value)` Helper method to either return the supplied value or the corresponding JDBC Type when the supplied value is null.
`static Object`	`getBindVariable(Ref value)` Helper method to either return the supplied value or the corresponding JDBC Type when the supplied value is null.
`static Object`	`getBindVariable(RowId value)` Helper method to either return the supplied value or the corresponding JDBC Type when the supplied value is null.
`static Object`	`getBindVariable(Short value)` Helper method to either return the supplied value or the corresponding JDBC Type when the supplied value is null.
`static Object`	`getBindVariable(SQLXML value)` Helper method to either return the supplied value or the corresponding JDBC Type when the supplied value is null.
`static Object`	`getBindVariable(String value)` Helper method to either return the supplied value or the corresponding JDBC Type when the supplied value is null.
`static Object`	`getBindVariable(Struct value)` Helper method to either return the supplied value or the corresponding JDBC Type when the supplied value is null.
`static Object`	`getBindVariable(Time value)` Helper method to either return the supplied value or the corresponding JDBC Type when the supplied value is null.
`static Object`	`getBindVariable(Timestamp value)` Helper method to either return the supplied value or the corresponding JDBC Type when the supplied value is null.
`int`	`getType()` Gets the wrapped primitive JDBC type.
`static CType`	`valueOf(String name)` Returns the enum constant of this type with the specified name.
`static CType[]`	`values()` Returns an array containing the constants of this enum type, in the order they are declared.

Methods inherited from class java.lang.Enum
clone, compareTo, equals, finalize, getDeclaringClass, hashCode, name, ordinal, toString, valueOf

Methods inherited from class java.lang.Object
getClass, notify, notifyAll, wait, wait, wait

- Enum Constant Detail
  - ARRAY
```
public static final CType ARRAY
```
    Wrapper for Types.ARRAY.
  - BIGINT
```
public static final CType BIGINT
```
    Wrapper for Types.BIGINT.
  - BINARY
```
public static final CType BINARY
```
    Wrapper for Types.BINARY.
  - BIT
```
public static final CType BIT
```
    Wrapper for Types.BIT.
  - BLOB
```
public static final CType BLOB
```
    Wrapper for Types.BLOB.
  - BOOLEAN
```
public static final CType BOOLEAN
```
    Wrapper for Types.BOOLEAN.
  - CHAR
```
public static final CType CHAR
```
    Wrapper for Types.CHAR.
  - CLOB
```
public static final CType CLOB
```
    Wrapper for Types.CLOB.
  - DATALINK
```
public static final CType DATALINK
```
    Wrapper for Types.DATALINK.
  - DATE
```
public static final CType DATE
```
    Wrapper for Types.DATE.
  - DECIMAL
```
public static final CType DECIMAL
```
    Wrapper for Types.DECIMAL.
  - DISTINCT
```
public static final CType DISTINCT
```
    Wrapper for Types.DISTINCT.
  - DOUBLE
```
public static final CType DOUBLE
```
    Wrapper for Types.DOUBLE.
  - FLOAT
```
public static final CType FLOAT
```
    Wrapper for Types.FLOAT.
  - INTEGER
```
public static final CType INTEGER
```
    Wrapper for Types.INTEGER.
  - JAVA_OBJECT
```
public static final CType JAVA_OBJECT
```
    Wrapper for Types.JAVA_OBJECT.
  - LONGNVARCHAR
```
public static final CType LONGNVARCHAR
```
    Wrapper for Types.LONGNVARCHAR.
  - LONGVARBINARY
```
public static final CType LONGVARBINARY
```
    Wrapper for Types.LONGVARBINARY.
  - LONGVARCHAR
```
public static final CType LONGVARCHAR
```
    Wrapper for Types.LONGVARCHAR.
  - NCHAR
```
public static final CType NCHAR
```
    Wrapper for Types.NCHAR.
  - NCLOB
```
public static final CType NCLOB
```
    Wrapper for Types.NCLOB.
  - NULL
```
public static final CType NULL
```
    Wrapper for Types.NULL.
  - NUMERIC
```
public static final CType NUMERIC
```
    Wrapper for Types.NUMERIC.
  - NVARCHAR
```
public static final CType NVARCHAR
```
    Wrapper for Types.NVARCHAR.
  - OTHER
```
public static final CType OTHER
```
    Wrapper for Types.OTHER.
  - REAL
```
public static final CType REAL
```
    Wrapper for Types.REAL.
  - REF
```
public static final CType REF
```
    Wrapper for Types.REF.
  - REF_CURSOR
```
public static final CType REF_CURSOR
```
    Wrapper for Types.REF_CURSOR.
  - ROWID
```
public static final CType ROWID
```
    Wrapper for Types.ROWID.
  - SMALLINT
```
public static final CType SMALLINT
```
    Wrapper for Types.SMALLINT.
  - SQLXML
```
public static final CType SQLXML
```
    Wrapper for Types.SQLXML.
  - STRUCT
```
public static final CType STRUCT
```
    Wrapper for Types.STRUCT.
  - TIME
```
public static final CType TIME
```
    Wrapper for Types.TIME.
  - TIME_WITH_TIMEZONE
```
public static final CType TIME_WITH_TIMEZONE
```
    Wrapper for Types.TIME_WITH_TIMEZONE.
  - TIMESTAMP
```
public static final CType TIMESTAMP
```
    Wrapper for Types.TIMESTAMP.
  - TIMESTAMP_WITH_TIMEZONE
```
public static final CType TIMESTAMP_WITH_TIMEZONE
```
    Wrapper for Types.TIMESTAMP_WITH_TIMEZONE.
  - TINYINT
```
public static final CType TINYINT
```
    Wrapper for Types.TINYINT.
  - VARBINARY
```
public static final CType VARBINARY
```
    Wrapper for Types.VARBINARY.
  - VARCHAR
```
public static final CType VARCHAR
```
    Wrapper for Types.VARCHAR.
- Method Detail
  - values
```
public static CType[] values()
```
    Returns an array containing the constants of this enum type, in the order they are declared. This method may be used to iterate over the constants as follows:
```
for (CType c : CType.values())
    System.out.println(c);
```
    Returns:
    
    an array containing the constants of this enum type, in the order they are declared
  - valueOf
```
public static CType valueOf(String name)
```
    Returns the enum constant of this type with the specified name. The string must match exactly an identifier used to declare an enum constant in this type. (Extraneous whitespace characters are not permitted.)
    
    Parameters:
    
    name - the name of the enum constant to be returned.
    
    Returns:
    
    the enum constant with the specified name
    
    Throws:
    
    IllegalArgumentException - if this enum type has no constant with the specified name
    
    NullPointerException - if the argument is null
  - getType
```
public int getType()
```
    Gets the wrapped primitive JDBC type.
    
    Returns:
    
    The wrapped primitive JDBC type.
  - getBindVariable
```
public static Object getBindVariable(Array value)
```
    Helper method to either return the supplied value or the corresponding JDBC Type when the supplied value is null.
    
    Parameters:
    
    value - The SQL parameter value.
    
    Returns:
    
    The supplied value when non-null otherwise the corresponding JDBC type ARRAY.
  - getBindVariable
```
public static Object getBindVariable(BigDecimal value)
```
    Helper method to either return the supplied value or the corresponding JDBC Type when the supplied value is null.
    
    Parameters:
    
    value - The SQL parameter value.
    
    Returns:
    
    The supplied value when non-null otherwise the corresponding JDBC type NUMERIC.
  - getBindVariable
```
public static Object getBindVariable(BigInteger value)
```
    Helper method to either return the supplied value or the corresponding JDBC Type when the supplied value is null.
    
    Parameters:
    
    value - The SQL parameter value.
    
    Returns:
    
    The supplied value when non-null otherwise the corresponding JDBC type NUMERIC.
  - getBindVariable
```
public static Object getBindVariable(Blob value)
```
    Helper method to either return the supplied value or the corresponding JDBC Type when the supplied value is null.
    
    Parameters:
    
    value - The SQL parameter value.
    
    Returns:
    
    The supplied value when non-null otherwise the corresponding JDBC type BLOB.
  - getBindVariable
```
public static Object getBindVariable(Boolean value)
```
    Helper method to either return the supplied value or the corresponding JDBC Type when the supplied value is null.
    
    Parameters:
    
    value - The SQL parameter value.
    
    Returns:
    
    The supplied value when non-null otherwise the corresponding JDBC type BOOLEAN.
  - getBindVariable
```
public static Object getBindVariable(Byte value)
```
    Helper method to either return the supplied value or the corresponding JDBC Type when the supplied value is null.
    
    Parameters:
    
    value - The SQL parameter value.
    
    Returns:
    
    The supplied value when non-null otherwise the corresponding JDBC type TINYINT.
  - getBindVariable
```
public static Object getBindVariable(byte[] value)
```
    Helper method to either return the supplied value or the corresponding JDBC Type when the supplied value is null.
    
    Parameters:
    
    value - The SQL parameter value.
    
    Returns:
    
    The supplied value when non-null otherwise the corresponding JDBC type VARBINARY.
  - getBindVariable
```
public static Object getBindVariable(Character value)
```
    Helper method to either return the supplied value or the corresponding JDBC Type when the supplied value is null.
    
    Parameters:
    
    value - The SQL parameter value.
    
    Returns:
    
    The supplied value when non-null otherwise the corresponding JDBC type CHAR.
  - getBindVariable
```
public static Object getBindVariable(Clob value)
```
    Helper method to either return the supplied value or the corresponding JDBC Type when the supplied value is null.
    
    Parameters:
    
    value - The SQL parameter value.
    
    Returns:
    
    The supplied value when non-null otherwise the corresponding JDBC type CLOB.
  - getBindVariable
```
public static Object getBindVariable(Date value)
```
    Helper method to either return the supplied value or the corresponding JDBC Type when the supplied value is null.
    
    Parameters:
    
    value - The SQL parameter value.
    
    Returns:
    
    The supplied value when non-null otherwise the corresponding JDBC type DATE.
  - getBindVariable
```
public static Object getBindVariable(Double value)
```
    Helper method to either return the supplied value or the corresponding JDBC Type when the supplied value is null.
    
    Parameters:
    
    value - The SQL parameter value.
    
    Returns:
    
    The supplied value when non-null otherwise the corresponding JDBC type DOUBLE.
  - getBindVariable
```
public static Object getBindVariable(Float value)
```
    Helper method to either return the supplied value or the corresponding JDBC Type when the supplied value is null.
    
    Parameters:
    
    value - The SQL parameter value.
    
    Returns:
    
    The supplied value when non-null otherwise the corresponding JDBC type REAL.
  - getBindVariable
```
public static Object getBindVariable(Integer value)
```
    Helper method to either return the supplied value or the corresponding JDBC Type when the supplied value is null.
    
    Parameters:
    
    value - The SQL parameter value.
    
    Returns:
    
    The supplied value when non-null otherwise the corresponding JDBC type INTEGER.
  - getBindVariable
```
public static Object getBindVariable(Long value)
```
    Helper method to either return the supplied value or the corresponding JDBC Type when the supplied value is null.
    
    Parameters:
    
    value - The SQL parameter value.
    
    Returns:
    
    The supplied value when non-null otherwise the corresponding JDBC type BIGINT.
  - getBindVariable
```
public static Object getBindVariable(NClob value)
```
    Helper method to either return the supplied value or the corresponding JDBC Type when the supplied value is null.
    
    Parameters:
    
    value - The SQL parameter value.
    
    Returns:
    
    The supplied value when non-null otherwise the corresponding JDBC type NCLOB.
  - getBindVariable
```
public static Object getBindVariable(Ref value)
```
    Helper method to either return the supplied value or the corresponding JDBC Type when the supplied value is null.
    
    Parameters:
    
    value - The SQL parameter value.
    
    Returns:
    
    The supplied value when non-null otherwise the corresponding JDBC type REF.
  - getBindVariable
```
public static Object getBindVariable(RowId value)
```
    Helper method to either return the supplied value or the corresponding JDBC Type when the supplied value is null.
    
    Parameters:
    
    value - The SQL parameter value.
    
    Returns:
    
    The supplied value when non-null otherwise the corresponding JDBC type ROWID.
  - getBindVariable
```
public static Object getBindVariable(Short value)
```
    Helper method to either return the supplied value or the corresponding JDBC Type when the supplied value is null.
    
    Parameters:
    
    value - The SQL parameter value.
    
    Returns:
    
    The supplied value when non-null otherwise the corresponding JDBC type SMALLINT.
  - getBindVariable
```
public static Object getBindVariable(SQLXML value)
```
    Helper method to either return the supplied value or the corresponding JDBC Type when the supplied value is null.
    
    Parameters:
    
    value - The SQL parameter value.
    
    Returns:
    
    The supplied value when non-null otherwise the corresponding JDBC type SQLXML.
  - getBindVariable
```
public static Object getBindVariable(String value)
```
    Helper method to either return the supplied value or the corresponding JDBC Type when the supplied value is null.
    
    Parameters:
    
    value - The SQL parameter value.
    
    Returns:
    
    The supplied value when non-null otherwise the corresponding JDBC type VARCHAR.
  - getBindVariable
```
public static Object getBindVariable(Struct value)
```
    Helper method to either return the supplied value or the corresponding JDBC Type when the supplied value is null.
    
    Parameters:
    
    value - The SQL parameter value.
    
    Returns:
    
    The supplied value when non-null otherwise the corresponding JDBC type STRUCT.
  - getBindVariable
```
public static Object getBindVariable(Time value)
```
    Helper method to either return the supplied value or the corresponding JDBC Type when the supplied value is null.
    
    Parameters:
    
    value - The SQL parameter value.
    
    Returns:
    
    The supplied value when non-null otherwise the corresponding JDBC type TIME.
  - getBindVariable
```
public static Object getBindVariable(Timestamp value)
```
    Helper method to either return the supplied value or the corresponding JDBC Type when the supplied value is null.
    
    Parameters:
    
    value - The SQL parameter value.
    
    Returns:
    
    The supplied value when non-null otherwise the corresponding JDBC type TIMESTAMP.

Enum CType

Enum Constant Summary

Method Summary

Methods inherited from class java.lang.Enum

Methods inherited from class java.lang.Object

Enum Constant Detail

ARRAY

BIGINT

BINARY

BIT

BLOB

BOOLEAN

CHAR

CLOB

DATALINK

DATE

DECIMAL

DISTINCT

DOUBLE

FLOAT

INTEGER

JAVA_OBJECT

LONGNVARCHAR

LONGVARBINARY

LONGVARCHAR

NCHAR

NCLOB

NULL

NUMERIC

NVARCHAR

OTHER

REAL

REF

REF_CURSOR

ROWID

SMALLINT

SQLXML

STRUCT

TIME

TIME_WITH_TIMEZONE

TIMESTAMP

TIMESTAMP_WITH_TIMEZONE

TINYINT

VARBINARY

VARCHAR

Method Detail

values

valueOf

getType

getBindVariable

getBindVariable

getBindVariable

getBindVariable

getBindVariable

getBindVariable

getBindVariable

getBindVariable

getBindVariable

getBindVariable

getBindVariable

getBindVariable

getBindVariable

getBindVariable

getBindVariable

getBindVariable

getBindVariable

getBindVariable

getBindVariable

getBindVariable

getBindVariable

getBindVariable

getBindVariable