org.apache.derby.impl.drda
Class SQLTypes

java.lang.Object
  extended byorg.apache.derby.impl.drda.SQLTypes

public class SQLTypes
extends java.lang.Object


Field Summary
protected static int DB2_SQLTYPE_BIGINT
           
protected static int DB2_SQLTYPE_BLOB
           
protected static int DB2_SQLTYPE_BLOB_LOCATOR
           
protected static int DB2_SQLTYPE_CHAR
           
protected static int DB2_SQLTYPE_CLOB
           
protected static int DB2_SQLTYPE_CLOB_LOCATOR
           
protected static int DB2_SQLTYPE_CSTR
           
protected static int DB2_SQLTYPE_DATALINK
           
protected static int DB2_SQLTYPE_DATE
           
protected static int DB2_SQLTYPE_DBCLOB
           
protected static int DB2_SQLTYPE_DBCLOB_LOCATOR
           
protected static int DB2_SQLTYPE_DECIMAL
           
protected static int DB2_SQLTYPE_FLOAT
           
protected static int DB2_SQLTYPE_GRAPHIC
           
protected static int DB2_SQLTYPE_INTEGER
           
protected static int DB2_SQLTYPE_LONG
           
protected static int DB2_SQLTYPE_LONGRAPH
           
protected static int DB2_SQLTYPE_LSTR
           
protected static int DB2_SQLTYPE_NBIGINT
           
protected static int DB2_SQLTYPE_NBLOB
           
protected static int DB2_SQLTYPE_NBLOB_LOCATOR
           
protected static int DB2_SQLTYPE_NCHAR
           
protected static int DB2_SQLTYPE_NCLOB
           
protected static int DB2_SQLTYPE_NCLOB_LOCATOR
           
protected static int DB2_SQLTYPE_NCSTR
           
protected static int DB2_SQLTYPE_NDATALINK
           
protected static int DB2_SQLTYPE_NDATE
           
protected static int DB2_SQLTYPE_NDBCLOB
           
protected static int DB2_SQLTYPE_NDBCLOB_LOCATOR
           
protected static int DB2_SQLTYPE_NDECIMAL
           
protected static int DB2_SQLTYPE_NFLOAT
           
protected static int DB2_SQLTYPE_NGRAPHIC
           
protected static int DB2_SQLTYPE_NINTEGER
           
protected static int DB2_SQLTYPE_NLONG
           
protected static int DB2_SQLTYPE_NLONGRAPH
           
protected static int DB2_SQLTYPE_NLSTR
           
protected static int DB2_SQLTYPE_NNUMERIC
           
protected static int DB2_SQLTYPE_NROWID
           
protected static int DB2_SQLTYPE_NSMALL
           
protected static int DB2_SQLTYPE_NTIME
           
protected static int DB2_SQLTYPE_NTIMESTAMP
           
protected static int DB2_SQLTYPE_NUMERIC
           
protected static int DB2_SQLTYPE_NVARCHAR
           
protected static int DB2_SQLTYPE_NVARGRAPH
           
protected static int DB2_SQLTYPE_NZONED
           
protected static int DB2_SQLTYPE_ROWID
           
protected static int DB2_SQLTYPE_SMALL
           
protected static int DB2_SQLTYPE_TIME
           
protected static int DB2_SQLTYPE_TIMESTAMP
           
protected static int DB2_SQLTYPE_VARCHAR
           
protected static int DB2_SQLTYPE_VARGRAPH
           
protected static int DB2_SQLTYPE_ZONED
           
 
Constructor Summary
private SQLTypes()
           
 
Method Summary
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, int[] outlen)
          Map JDBC Type to DB2 SqlType
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

DB2_SQLTYPE_DATE

protected static final int DB2_SQLTYPE_DATE
See Also:
Constant Field Values

DB2_SQLTYPE_NDATE

protected static final int DB2_SQLTYPE_NDATE
See Also:
Constant Field Values

DB2_SQLTYPE_TIME

protected static final int DB2_SQLTYPE_TIME
See Also:
Constant Field Values

DB2_SQLTYPE_NTIME

protected static final int DB2_SQLTYPE_NTIME
See Also:
Constant Field Values

DB2_SQLTYPE_TIMESTAMP

protected static final int DB2_SQLTYPE_TIMESTAMP
See Also:
Constant Field Values

DB2_SQLTYPE_NTIMESTAMP

protected static final int DB2_SQLTYPE_NTIMESTAMP
See Also:
Constant Field Values

DB2_SQLTYPE_DATALINK

protected static final int DB2_SQLTYPE_DATALINK
See Also:
Constant Field Values

DB2_SQLTYPE_NDATALINK

protected static final int DB2_SQLTYPE_NDATALINK
See Also:
Constant Field Values

DB2_SQLTYPE_BLOB

protected static final int DB2_SQLTYPE_BLOB
See Also:
Constant Field Values

DB2_SQLTYPE_NBLOB

protected static final int DB2_SQLTYPE_NBLOB
See Also:
Constant Field Values

DB2_SQLTYPE_CLOB

protected static final int DB2_SQLTYPE_CLOB
See Also:
Constant Field Values

DB2_SQLTYPE_NCLOB

protected static final int DB2_SQLTYPE_NCLOB
See Also:
Constant Field Values

DB2_SQLTYPE_DBCLOB

protected static final int DB2_SQLTYPE_DBCLOB
See Also:
Constant Field Values

DB2_SQLTYPE_NDBCLOB

protected static final int DB2_SQLTYPE_NDBCLOB
See Also:
Constant Field Values

DB2_SQLTYPE_VARCHAR

protected static final int DB2_SQLTYPE_VARCHAR
See Also:
Constant Field Values

DB2_SQLTYPE_NVARCHAR

protected static final int DB2_SQLTYPE_NVARCHAR
See Also:
Constant Field Values

DB2_SQLTYPE_CHAR

protected static final int DB2_SQLTYPE_CHAR
See Also:
Constant Field Values

DB2_SQLTYPE_NCHAR

protected static final int DB2_SQLTYPE_NCHAR
See Also:
Constant Field Values

DB2_SQLTYPE_LONG

protected static final int DB2_SQLTYPE_LONG
See Also:
Constant Field Values

DB2_SQLTYPE_NLONG

protected static final int DB2_SQLTYPE_NLONG
See Also:
Constant Field Values

DB2_SQLTYPE_CSTR

protected static final int DB2_SQLTYPE_CSTR
See Also:
Constant Field Values

DB2_SQLTYPE_NCSTR

protected static final int DB2_SQLTYPE_NCSTR
See Also:
Constant Field Values

DB2_SQLTYPE_VARGRAPH

protected static final int DB2_SQLTYPE_VARGRAPH
See Also:
Constant Field Values

DB2_SQLTYPE_NVARGRAPH

protected static final int DB2_SQLTYPE_NVARGRAPH
See Also:
Constant Field Values

DB2_SQLTYPE_GRAPHIC

protected static final int DB2_SQLTYPE_GRAPHIC
See Also:
Constant Field Values

DB2_SQLTYPE_NGRAPHIC

protected static final int DB2_SQLTYPE_NGRAPHIC
See Also:
Constant Field Values

DB2_SQLTYPE_LONGRAPH

protected static final int DB2_SQLTYPE_LONGRAPH
See Also:
Constant Field Values

DB2_SQLTYPE_NLONGRAPH

protected static final int DB2_SQLTYPE_NLONGRAPH
See Also:
Constant Field Values

DB2_SQLTYPE_LSTR

protected static final int DB2_SQLTYPE_LSTR
See Also:
Constant Field Values

DB2_SQLTYPE_NLSTR

protected static final int DB2_SQLTYPE_NLSTR
See Also:
Constant Field Values

DB2_SQLTYPE_FLOAT

protected static final int DB2_SQLTYPE_FLOAT
See Also:
Constant Field Values

DB2_SQLTYPE_NFLOAT

protected static final int DB2_SQLTYPE_NFLOAT
See Also:
Constant Field Values

DB2_SQLTYPE_DECIMAL

protected static final int DB2_SQLTYPE_DECIMAL
See Also:
Constant Field Values

DB2_SQLTYPE_NDECIMAL

protected static final int DB2_SQLTYPE_NDECIMAL
See Also:
Constant Field Values

DB2_SQLTYPE_ZONED

protected static final int DB2_SQLTYPE_ZONED
See Also:
Constant Field Values

DB2_SQLTYPE_NZONED

protected static final int DB2_SQLTYPE_NZONED
See Also:
Constant Field Values

DB2_SQLTYPE_BIGINT

protected static final int DB2_SQLTYPE_BIGINT
See Also:
Constant Field Values

DB2_SQLTYPE_NBIGINT

protected static final int DB2_SQLTYPE_NBIGINT
See Also:
Constant Field Values

DB2_SQLTYPE_INTEGER

protected static final int DB2_SQLTYPE_INTEGER
See Also:
Constant Field Values

DB2_SQLTYPE_NINTEGER

protected static final int DB2_SQLTYPE_NINTEGER
See Also:
Constant Field Values

DB2_SQLTYPE_SMALL

protected static final int DB2_SQLTYPE_SMALL
See Also:
Constant Field Values

DB2_SQLTYPE_NSMALL

protected static final int DB2_SQLTYPE_NSMALL
See Also:
Constant Field Values

DB2_SQLTYPE_NUMERIC

protected static final int DB2_SQLTYPE_NUMERIC
See Also:
Constant Field Values

DB2_SQLTYPE_NNUMERIC

protected static final int DB2_SQLTYPE_NNUMERIC
See Also:
Constant Field Values

DB2_SQLTYPE_ROWID

protected static final int DB2_SQLTYPE_ROWID
See Also:
Constant Field Values

DB2_SQLTYPE_NROWID

protected static final int DB2_SQLTYPE_NROWID
See Also:
Constant Field Values

DB2_SQLTYPE_BLOB_LOCATOR

protected static final int DB2_SQLTYPE_BLOB_LOCATOR
See Also:
Constant Field Values

DB2_SQLTYPE_NBLOB_LOCATOR

protected static final int DB2_SQLTYPE_NBLOB_LOCATOR
See Also:
Constant Field Values

DB2_SQLTYPE_CLOB_LOCATOR

protected static final int DB2_SQLTYPE_CLOB_LOCATOR
See Also:
Constant Field Values

DB2_SQLTYPE_NCLOB_LOCATOR

protected static final int DB2_SQLTYPE_NCLOB_LOCATOR
See Also:
Constant Field Values

DB2_SQLTYPE_DBCLOB_LOCATOR

protected static final int DB2_SQLTYPE_DBCLOB_LOCATOR
See Also:
Constant Field Values

DB2_SQLTYPE_NDBCLOB_LOCATOR

protected static final int DB2_SQLTYPE_NDBCLOB_LOCATOR
See Also:
Constant Field Values
Constructor Detail

SQLTypes

private SQLTypes()
Method Detail

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,
                                             int[] outlen)
                                      throws java.sql.SQLException
Map JDBC Type to DB2 SqlType

Parameters:
jdbctype - JDBC Type from java.sql.Types
nullable - true if this is a nullable type
outlen - output parameter with type length
Returns:
Corresponding DB2 SQL Type (See DRDA Manual FD:OCA Meta Data Summary, page 245)
Throws:
java.sql.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.

Built on Mon 2007-06-04 09:58:47+0400, from revision ???

Apache Derby V10.1 Engine Documentation - Copyright © 1997,2005 The Apache Software Foundation or its licensors, as applicable.