Class SQLTypes

java.lang.Object

org.apache.derby.impl.drda.SQLTypes

class SQLTypes
extends Object

Constructor Summary

Constructors

Modifier	Constructor	Description
private	SQLTypes()

Method Summary

Modifier and Type	Method	Description
protected static int	getNonNullableSqlType(int sqlType)	Translate DB2 SQL Type to the non-nullable type.
protected static int	mapDB2SqlTypeToJdbcType(int sqlType, long length, int ccsid)	Map DB2 SQL Type to JDBC Type
protected static int	mapJdbcTypeToDB2SqlType(int jdbctype, boolean nullable, AppRequester appRequester, int[] outlen)	Map JDBC Type to DB2 SqlType

Methods inherited from class Object

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

Constructor Details

SQLTypes

private SQLTypes()

Method Details

mapDB2SqlTypeToJdbcType

protected static int mapDB2SqlTypeToJdbcType(int sqlType,
 long length,
 int ccsid)

Map DB2 SQL Type to JDBC Type

Parameters:

sqlType - SQL Type to convert

length - storage length of type

ccsid - ccsid of type

Returns:

Corresponding JDBC Type

mapJdbcTypeToDB2SqlType

protected static int mapJdbcTypeToDB2SqlType(int jdbctype,
 boolean nullable,
 AppRequester appRequester,
 int[] outlen)
                                      throws SQLException

Map JDBC Type to DB2 SqlType

Parameters:

jdbctype - JDBC Type from java.sql.Types

nullable - true if this is a nullable type

appRequester - - state variable for the connection

outlen - output parameter with type length

Returns:

Corresponding DB2 SQL Type (See DRDA Manual FD:OCA Meta Data Summary, page 245)

Throws:

SQLException - thrown for unrecognized SQLType

getNonNullableSqlType

protected static int getNonNullableSqlType(int sqlType)

Translate DB2 SQL Type to the non-nullable type.

Parameters:

sqlType - DB2 SQL Type

Returns:

The Non-Nullable DB2 SQL Type.