Top Description Fields Constructors Methods
org.hsqldb.types

public final Class ClobType

extends CharacterType
Class Inheritance
Imports
org.hsqldb.OpTypes, .Session, .SessionInterface, .Tokens, org.hsqldb.error.Error, .ErrorCode, org.hsqldb.jdbc.JDBCClobClient
Type object for CLOB.

Author
Fred Toussi (fredt@users dot sourceforge.net)
Since
1.9.0
Version
2.5.0

Field Summary

Modifier and TypeField and Description
public static final int
defaultClobSize

public static final int
defaultShortClobSize

public static final long
maxClobPrecision

Inherited from org.hsqldb.types.CharacterType:
charArraycharsetcollationdefaultCharPrecisiondefaultVarcharPrecisionmaxCharPrecisionnameString

Constructor Summary

AccessConstructor and Description
public
ClobType(long precision)

public
ClobType(Collation collation, long precision)

Method Summary

Modifier and TypeMethod and Description
public int
compare(Session session, Object a, Object b)

Overrides org.hsqldb.types.CharacterType.compare.

public int
compare(Session session, Object a, Object b, int opType)

Overrides org.hsqldb.types.CharacterType.compare.

public Object
convertJavaToSQL(SessionInterface session, Object a)

Overrides org.hsqldb.types.CharacterType.convertJavaToSQL.

public Object
convertSQLToJava(SessionInterface session, Object a)

Overrides org.hsqldb.types.Type.convertSQLToJava.

public Object
convertToDefaultType(SessionInterface session, Object a)

Overrides org.hsqldb.types.CharacterType.convertToDefaultType.

Relaxes SQL parameter type enforcement, allowing long strings.

public String
convertToSQLString(Object a)

Overrides org.hsqldb.types.CharacterType.convertToSQLString.

public String
convertToString(Object a)

Overrides org.hsqldb.types.CharacterType.convertToString.

public int
displaySize()

Overrides org.hsqldb.types.CharacterType.displaySize.

public String
getDefinition()

Overrides org.hsqldb.types.CharacterType.getDefinition.

Returns the full definition of the type, including parameters

public Class<T>
getJDBCClass()

Overrides org.hsqldb.types.CharacterType.getJDBCClass.

public String
getJDBCClassName()

Overrides org.hsqldb.types.CharacterType.getJDBCClassName.

Returns the JDBC class name of type, if it exists, otherwise the HSQLDB class name.

public int
getJDBCTypeCode()

Overrides org.hsqldb.types.CharacterType.getJDBCTypeCode.

Returns the JDBC type number of type, if it exists, otherwise the HSQLDB / SQL type.

public long
getMaxPrecision()

Overrides org.hsqldb.types.CharacterType.getMaxPrecision.

public int
getSQLGenericTypeCode()

Overrides org.hsqldb.types.CharacterType.getSQLGenericTypeCode.

Returns the generic SQL CLI type number of type, if it exists, otherwise the HSQLDB type.

public boolean
isLobType()

Overrides org.hsqldb.types.Type.isLobType.

public long
position(SessionInterface session, Object data, Object otherData, Type otherType, long start)

Overrides org.hsqldb.types.CharacterType.position.

Inherited from org.hsqldb.types.CharacterType:
acceptsPrecisioncanConvertFromcanMoveFromcastOrConvertToTypecastToTypeconcatconvertToJSONconvertToTypeconvertToTypeJDBCconvertToTypeLimitsequalsgetAggregateTypegetCharacterSetgetCharacterTypegetCharacterTypegetCharacterTypegetCollationgetCombinedTypegetFullNameStringgetNameStringgetRightTrimSizeisCharacterTypelowermatchoverlaypadStringprecedenceDegreerequiresPrecisionsizesubstringsubstringParamstrimupper

Field Detail

defaultClobSizeback to summary
public static final int defaultClobSize
defaultShortClobSizeback to summary
public static final int defaultShortClobSize
maxClobPrecisionback to summary
public static final long maxClobPrecision

Constructor Detail

ClobTypeback to summary
public ClobType(long precision)
ClobTypeback to summary
public ClobType(Collation collation, long precision)

Method Detail

compareback to summary
public int compare(Session session, Object a, Object b)

Overrides org.hsqldb.types.CharacterType.compare.

compareback to summary
public int compare(Session session, Object a, Object b, int opType)

Overrides org.hsqldb.types.CharacterType.compare.

convertJavaToSQLback to summary
public Object convertJavaToSQL(SessionInterface session, Object a)

Overrides org.hsqldb.types.CharacterType.convertJavaToSQL.

convertSQLToJavaback to summary
public Object convertSQLToJava(SessionInterface session, Object a)

Overrides org.hsqldb.types.Type.convertSQLToJava.

convertToDefaultTypeback to summary
public Object convertToDefaultType(SessionInterface session, Object a)

Overrides org.hsqldb.types.CharacterType.convertToDefaultType.

Doc from org.hsqldb.types.CharacterType.convertToDefaultType.

Relaxes SQL parameter type enforcement, allowing long strings.

convertToSQLStringback to summary
public String convertToSQLString(Object a)

Overrides org.hsqldb.types.CharacterType.convertToSQLString.

convertToStringback to summary
public String convertToString(Object a)

Overrides org.hsqldb.types.CharacterType.convertToString.

displaySizeback to summary
public int displaySize()

Overrides org.hsqldb.types.CharacterType.displaySize.

getDefinitionback to summary
public String getDefinition()

Overrides org.hsqldb.types.CharacterType.getDefinition.

Doc from org.hsqldb.types.Type.getDefinition.

Returns the full definition of the type, including parameters

getJDBCClassback to summary
public Class<T> getJDBCClass()

Overrides org.hsqldb.types.CharacterType.getJDBCClass.

getJDBCClassNameback to summary
public String getJDBCClassName()

Overrides org.hsqldb.types.CharacterType.getJDBCClassName.

Doc from org.hsqldb.types.Type.getJDBCClassName.

Returns the JDBC class name of type, if it exists, otherwise the HSQLDB class name.

getJDBCTypeCodeback to summary
public int getJDBCTypeCode()

Overrides org.hsqldb.types.CharacterType.getJDBCTypeCode.

Doc from org.hsqldb.types.Type.getJDBCTypeCode.

Returns the JDBC type number of type, if it exists, otherwise the HSQLDB / SQL type.

getMaxPrecisionback to summary
public long getMaxPrecision()

Overrides org.hsqldb.types.CharacterType.getMaxPrecision.

getSQLGenericTypeCodeback to summary
public int getSQLGenericTypeCode()

Overrides org.hsqldb.types.CharacterType.getSQLGenericTypeCode.

Doc from org.hsqldb.types.Type.getSQLGenericTypeCode.

Returns the generic SQL CLI type number of type, if it exists, otherwise the HSQLDB type. The generic type is returned for DATETIME and INTERVAL types.

isLobTypeback to summary
public boolean isLobType()

Overrides org.hsqldb.types.Type.isLobType.

positionback to summary
public long position(SessionInterface session, Object data, Object otherData, Type otherType, long start)

Overrides org.hsqldb.types.CharacterType.position.