Docjar: A Java Source and Docuemnt Enginecom.*    java.*    javax.*    org.*    all    new    plug-in

Quick Search    Search Deep

org.apache.derby.impl.drda
Class SQLTypes  view SQLTypes download SQLTypes.java

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


mapJdbcTypeToDB2SqlType

protected static int mapJdbcTypeToDB2SqlType(int jdbctype,
                                             boolean nullable,
                                             int[] outlen)
                                      throws java.sql.SQLException
Map JDBC Type to DB2 SqlType


getNonNullableSqlType

protected static int getNonNullableSqlType(int sqlType)
Translate DB2 SQL Type to the non-nullable type.