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.