com.solarmetric.kodo.impl.jdbc.schema.dict
Class SQLTypeMap

java.lang.Object
  |
  +--com.solarmetric.kodo.impl.jdbc.schema.dict.SQLTypeMap

public class SQLTypeMap

extends Object

Maps of java types to their SQL counterparts for a particular database. The default mappings are as follows:

• SQLTypes.STRING: VARCHAR(255)
• SQLTypes.CLOB: CLOB
• SQLTypes.LENSTRING: VARCHAR(length)
• SQLTypes.BOOLEAN: TINYINT
• SQLTypes.BYTE: SMALLINT
• SQLTypes.CHARACTER: CHAR(1)
• SQLTypes.DOUBLE: DOUBLE
• SQLTypes.FLOAT: REAL
• SQLTypes.INTEGER: INTEGER
• SQLTypes.LONG: BIGINT
• SQLTypes.SHORT: SMALLINT
• SQLTypes.DATE: TIMESTAMP
• SQLTypes.BLOB: BLOB
• SQLTypes.BIGINTEGER: BIGINT
• SQLTypes.BIGDECIMAL: DECIMAL
• SQLTypes.LOCALE: VARCHAR(50)

Constructor Summary

SQLTypeMap()
Constructor.

Method Summary

String	getBigDecimalType() Return the SQL type for java.math.BigDecimals.
String	getBigIntegerType() Return the SQL type for java.math.BigIntegers.
String	getBlobType() Return the SQL type for binary objects.
String	getBooleanType() Return the SQL type for booleans.
String	getByteType() Return the SQL type for bytes.
String	getCharType() Return the SQL type for chars.
String	getClobType() Return the SQL type for unlimited length Strings.
String	getDateType() Return the SQL type for Dates.
String	getDefaultStringType() Return the SQL type for default length Strings.
String	getDoubleType() Return the SQL type for doubles.
String	getFloatType() Return the SQL type for floats.
String	getIntType() Return the SQL type for ints.
String	getLenStringType() Return the SQL type for limited length Strings.
String	getLocaleType() Return the SQL type for java.util.Locales.
String	getLongType() Return the SQL type for longs.
String	getShortType() Return the SQL type for shorts.
String	getStringType() Return the SQL type for limited length Strings.
String	getType(int constant) Return the SQL column type for the given symbolic constant type.
String	getType(int constant, int length) Return the SQL column type for the given symbolic constant type.
void	setBigDecimalType(String type) Set the SQL type for java.math.BigDecimals.
void	setBigIntegerType(String type) Set the SQL type for java.math.BigIntegers.
void	setBlobType(String type) Set the SQL type for binary objects.
void	setBooleanType(String type) Set the SQL type for booleans; this should be a numeric type.
void	setByteType(String type) Set the SQL type for bytes; this should be a numeric type.
void	setCharType(String type) Set the SQL type for chars.
void	setClobType(String type) Set the SQL type for unlimited length Strings.
void	setDateType(String type) Set the SQL type for Dates.
void	setDefaultStringType(String type) Set the SQL type for default length Strings.
void	setDoubleType(String type) Set the SQL type for doubles.
void	setFloatType(String type) Set the SQL type for floats.
void	setIntType(String type) Set the SQL type for ints.
void	setLenStringType(String type) Set the SQL type for limited length Strings.
void	setLocaleType(String type) Set the SQL type for java.util.Locales.
void	setLongType(String type) Set the SQL type for longs.
void	setShortType(String type) Set the SQL type for shorts.
void	setStringType(String type) Set the SQL type for limited length Strings.
void	setType(int constant, String type) Set the SQL column type fo rthe given symbolic constant from SQLTypes.

Methods inherited from class java.lang.Object

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

Constructor Detail

SQLTypeMap

public SQLTypeMap()

Constructor. Creates the defualt mappings.

Method Detail

getBlobType

public String getBlobType()

Return the SQL type for binary objects.

setBlobType

public void setBlobType(String type)

Set the SQL type for binary objects.

getClobType

public String getClobType()

Return the SQL type for unlimited length Strings.

setClobType

public void setClobType(String type)

Set the SQL type for unlimited length Strings.

getLenStringType

public String getLenStringType()

Return the SQL type for limited length Strings. Note that the returned String might be a template using '{0}' to represent the place where the desired length will be inserted in the generated SQL.

setLenStringType

public void setLenStringType(String type)

Set the SQL type for limited length Strings. The given String will be passed through the java.text.MessageFormat with the desired length, so it can use the '{0}' symbol to denote the placement of the length in the type signature if needed.

getStringType

public String getStringType()

Return the SQL type for limited length Strings. Note that the returned String might be a template using '{0}' to represent the place where the desired length will be inserted in the generated SQL.

setStringType

public void setStringType(String type)

Set the SQL type for limited length Strings. The given String will be passed through the java.util.MessageFormat with the desired length, so it can use the '{0}' symbol to denote the placement of the length in the type signature if needed.

getDefaultStringType

public String getDefaultStringType()

Return the SQL type for default length Strings.

setDefaultStringType

public void setDefaultStringType(String type)

Set the SQL type for default length Strings.

getBooleanType

public String getBooleanType()

Return the SQL type for booleans.

setBooleanType

public void setBooleanType(String type)

Set the SQL type for booleans; this should be a numeric type.

getByteType

public String getByteType()

Return the SQL type for bytes.

setByteType

public void setByteType(String type)

Set the SQL type for bytes; this should be a numeric type.

getCharType

public String getCharType()

Return the SQL type for chars.

setCharType

public void setCharType(String type)

Set the SQL type for chars.

getDoubleType

public String getDoubleType()

Return the SQL type for doubles.

setDoubleType

public void setDoubleType(String type)

Set the SQL type for doubles.

getFloatType

public String getFloatType()

Return the SQL type for floats.

setFloatType

public void setFloatType(String type)

Set the SQL type for floats.

getIntType

public String getIntType()

Return the SQL type for ints.

setIntType

public void setIntType(String type)

Set the SQL type for ints.

getLongType

public String getLongType()

Return the SQL type for longs.

setLongType

public void setLongType(String type)

Set the SQL type for longs.

getShortType

public String getShortType()

Return the SQL type for shorts.

setShortType

public void setShortType(String type)

Set the SQL type for shorts.

getDateType

public String getDateType()

Return the SQL type for Dates.

setDateType

public void setDateType(String type)

Set the SQL type for Dates.

getBigIntegerType

public String getBigIntegerType()

Return the SQL type for java.math.BigIntegers.

setBigIntegerType

public void setBigIntegerType(String type)

Set the SQL type for java.math.BigIntegers.

getBigDecimalType

public String getBigDecimalType()

Return the SQL type for java.math.BigDecimals.

setBigDecimalType

public void setBigDecimalType(String type)

Set the SQL type for java.math.BigDecimals.

getLocaleType

public String getLocaleType()

Return the SQL type for java.util.Locales.

setLocaleType

public void setLocaleType(String type)

Set the SQL type for java.util.Locales.

getType

public String getType(int constant)

Return the SQL column type for the given symbolic constant type.

getType

public String getType(int constant,
                      int length)

Return the SQL column type for the given symbolic constant type.

setType

public void setType(int constant,
                    String type)

Set the SQL column type fo rthe given symbolic constant from SQLTypes.