com.healthmarketscience.jackcess
Enum DataType

java.lang.Object
  java.lang.Enum<DataType>
      com.healthmarketscience.jackcess.DataType

All Implemented Interfaces:

Serializable, Comparable<DataType>

public enum DataType
extends Enum<DataType>

Access data type

Author:

Tim McCune

Enum Constant Summary

BINARY
Corresponds to a java byte[] of max length 255 bytes.

BOOLEAN
Corresponds to a java Boolean.

BYTE
Corresponds to a java Byte.

DOUBLE
Corresponds to a java Double.

FLOAT
Corresponds to a java Float.

GUID
Corresponds to a java String with the pattern "{xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx}".

INT
Corresponds to a java Short.

LONG
Corresponds to a java Integer.

MEMO
Corresponds to a java String of max length 8388607 chars.

MONEY
Corresponds to a java BigDecimal with at most 4 decimal places.

NUMERIC
Corresponds to a java BigDecimal.

OLE
Corresponds to a java byte[] of max length 16777215 bytes.

SHORT_DATE_TIME
Corresponds to a java Date.

TEXT
Corresponds to a java String of max length 255 chars.

UNKNOWN_0D
Unknown data.

Method Summary

static DataType	fromByte(byte b)
static DataType	fromSQLType(int sqlType)
static DataType	fromSQLType(int sqlType, int lengthInUnits)
int	getDefaultPrecision()
int	getDefaultScale()
int	getDefaultSize()
int	getFixedSize()
boolean	getHasScalePrecision()
int	getMaxPrecision()
int	getMaxScale()
int	getMaxSize()
int	getMinPrecision()
int	getMinScale()
int	getMinSize()
int	getSQLType()
int	getUnitSize()
byte	getValue()
boolean	isLongValue()
boolean	isTrueVariableLength()
boolean	isValidPrecision(int precision)
boolean	isValidScale(int scale)
boolean	isValidSize(int size)
boolean	isVariableLength()
static DataType	valueOf(String name) Returns the enum constant of this type with the specified name.
static DataType[]	values() Returns an array containing the constants of this enum type, in the order they're declared.

Methods inherited from class java.lang.Enum

compareTo, equals, getDeclaringClass, hashCode, name, ordinal, toString, valueOf

Methods inherited from class java.lang.Object

getClass, notify, notifyAll, wait, wait, wait

Enum Constant Detail

BOOLEAN

public static final DataType BOOLEAN

Corresponds to a java Boolean. Accepts Boolean or null (which is considered false). Equivalent to SQL Types.BOOLEAN.

BYTE

public static final DataType BYTE

Corresponds to a java Byte. Accepts any Number (using Number.byteValue()), Boolean as 1 or 0, any Object converted to a String and parsed as Double, or null. Equivalent to SQL Types.TINYINT, Types.BIT.

INT

public static final DataType INT

Corresponds to a java Short. Accepts any Number (using Number.shortValue()), Boolean as 1 or 0, any Object converted to a String and parsed as Double, or null. Equivalent to SQL Types.SMALLINT.

LONG

public static final DataType LONG

Corresponds to a java Integer. Accepts any Number (using Number.intValue()), Boolean as 1 or 0, any Object converted to a String and parsed as Double, or null. Equivalent to SQL Types.INTEGER, Types.BIGINT.

MONEY

public static final DataType MONEY

Corresponds to a java BigDecimal with at most 4 decimal places. Accepts any Number (using Number.doubleValue()), a BigInteger, a BigDecimal (with at most 4 decimal places), Boolean as 1 or 0, any Object converted to a String and parsed as BigDecimal, or null. Equivalent to SQL Types.DECIMAL.

FLOAT

public static final DataType FLOAT

Corresponds to a java Float. Accepts any Number (using Number.floatValue()), Boolean as 1 or 0, any Object converted to a String and parsed as Double, or null. Equivalent to SQL Types.FLOAT.

DOUBLE

public static final DataType DOUBLE

Corresponds to a java Double. Accepts any Number (using Number.doubleValue()), Boolean as 1 or 0, any Object converted to a String and parsed as Double, or null. Equivalent to SQL Types.DOUBLE, Types.REAL.

SHORT_DATE_TIME

public static final DataType SHORT_DATE_TIME

Corresponds to a java Date. Accepts a Date, any Number (using Number.longValue()), or null. Equivalent to SQL Types.TIMESTAMP, Types.DATE, Types.TIME.

BINARY

public static final DataType BINARY

Corresponds to a java byte[] of max length 255 bytes. Accepts a byte[], or null. Equivalent to SQL Types.BINARY, Types.VARBINARY.

TEXT

public static final DataType TEXT

Corresponds to a java String of max length 255 chars. Accepts any CharSequence, any Object converted to a String , or null. Equivalent to SQL Types.VARCHAR, Types.CHAR.

OLE

public static final DataType OLE

Corresponds to a java byte[] of max length 16777215 bytes. Accepts a byte[], or null. Equivalent to SQL Types.LONGVARBINARY, Types.BLOB.

MEMO

public static final DataType MEMO

Corresponds to a java String of max length 8388607 chars. Accepts any CharSequence, any Object converted to a String , or null. Equivalent to SQL Types.LONGVARCHAR, Types.CLOB.

UNKNOWN_0D

public static final DataType UNKNOWN_0D

Unknown data. Accepts null.

GUID

public static final DataType GUID

Corresponds to a java String with the pattern "{xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx}". Accepts any Object converted to a String matching this pattern (surrounding "{}" are optional, so UUIDs are supported), or null.

NUMERIC

public static final DataType NUMERIC

Corresponds to a java BigDecimal. Accepts any Number (using Number.doubleValue()), a BigInteger, a BigDecimal, Boolean as 1 or 0, any Object converted to a String and parsed as BigDecimal, or null. Equivalent to SQL Types.NUMERIC.

Method Detail

values

public static final DataType[] values()

Returns an array containing the constants of this enum type, in the order they're declared. This method may be used to iterate over the constants as follows:

for(DataType c : DataType.values())
        System.out.println(c);

Returns:

an array containing the constants of this enum type, in the order they're declared

valueOf

public static DataType 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

getValue

public byte getValue()

isVariableLength

public boolean isVariableLength()

isTrueVariableLength

public boolean isTrueVariableLength()

isLongValue

public boolean isLongValue()

getHasScalePrecision

public boolean getHasScalePrecision()

getFixedSize

public int getFixedSize()

getMinSize

public int getMinSize()

getDefaultSize

public int getDefaultSize()

getMaxSize

public int getMaxSize()

getSQLType

public int getSQLType()
               throws SQLException

Throws:

SQLException

getMinScale

public int getMinScale()

getDefaultScale

public int getDefaultScale()

getMaxScale

public int getMaxScale()

getMinPrecision

public int getMinPrecision()

getDefaultPrecision

public int getDefaultPrecision()

getMaxPrecision

public int getMaxPrecision()

getUnitSize

public int getUnitSize()

isValidSize

public boolean isValidSize(int size)

isValidScale

public boolean isValidScale(int scale)

isValidPrecision

public boolean isValidPrecision(int precision)

fromByte

public static DataType fromByte(byte b)
                         throws IOException

Throws:

IOException

fromSQLType

public static DataType fromSQLType(int sqlType)
                            throws SQLException

Throws:

SQLException

fromSQLType

public static DataType fromSQLType(int sqlType,
                                   int lengthInUnits)
                            throws SQLException

Throws:

SQLException