org.apache.derby.impl.drda
Class SQLTypes
java.lang.Object
org.apache.derby.impl.drda.SQLTypes
- public class SQLTypes
- extends java.lang.Object
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 |
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
SQLTypes
private SQLTypes()
mapDB2SqlTypeToJdbcType
protected static int mapDB2SqlTypeToJdbcType(int sqlType,
long length,
int ccsid)
- Map DB2 SQL Type to JDBC Type
- Parameters:
sqlType
- SQL Type to convertlength
- storage length of typeccsid
- 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.Typesnullable
- true if this is a nullable typeoutlen
- 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.
Apache Derby V10.0 Engine Documentation - Copyright © 1997,2004 The Apache Software Foundation or its licensors, as applicable.