Package org.apache.derby.impl.drda

Class SQLTypes

  • class SQLTypes
extends java.lang.Object

    • Constructor Summary

      Constructors 
      Modifier Constructor Description
      private SQLTypes()  

    • Method Summary

      All Methods Static Methods Concrete Methods 
      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 java.lang.Object

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

    • 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,
                                             AppRequester appRequester,
                                             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
        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:
        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.