odbcdef.java

picoSQL is a SQL-based, multi-user, client/server RDBMS, released under the GPL

/*
_____       _    _    Corso   Italia,  178
(_|__   .  (_   |_|_  56125           Pisa
(_|_) |)|(()_)()| |   tel.  [phone]
  |   |               [e-mail]

 Copyright (C) Picosoft s.r.l. 1995-2002

 This program is free software; you can redistribute it and/or modify
 it under the terms of the GNU General Public License as published by
 the Free Software Foundation; either version 2, or (at your option)
 any later version.

 This program is distributed in the hope that it will be useful,
 but WITHOUT ANY WARRANTY; without even the implied warranty of
 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 GNU General Public License for more details.

 You should have received a copy of the GNU General Public License
 along with this program; if not, write to the Free Software
 Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.

*/
package IT.picosoft.jdbc;

import java.sql.Types;

public class OdbcDef
{

    public OdbcDef()
    {
    }

    public static int jdbcTypeToOdbc(int i)
    {
        int j = i;
        switch(i)
        {
        case 91: // '['
            j = 9;
            break;

        case 92: // '\\'
            j = 10;
            break;

        case 93: // ']'
            j = 11;
            break;

        }
        return j;
    }

    public static int odbcTypeToJdbc(int i)
    {
        int j = i;
        switch(i)
        {
        case 9: // '\t'
            j = 91;
            break;

        case 10: // '\n'
            j = 92;
            break;

        case 11: // '\013'
            j = 93;
            break;

        }
        return j;
    }

    public static final short SQL_SUCCESS = 0;
    public static final short SQL_SUCCESS_WITH_INFO = 1;
    public static final short SQL_NO_DATA = 100;
    public static final short SQL_NO_DATA_FOUND = 100;
    public static final short SQL_ERROR = -1;
    public static final short SQL_INVALID_HANDLE = -2;
    public static final short SQL_STILL_EXECUTING = 2;
    public static final short SQL_NEED_DATA = 99;
    public static final short SQL_TRUE = 1;
    public static final short SQL_FALSE = 0;

    public static final short SQL_CHAR = 1;
    public static final short SQL_NUMERIC = 2;
    public static final short SQL_DECIMAL = 3;
    public static final short SQL_INTEGER = 4;
    public static final short SQL_SMALLINT = 5;
    public static final short SQL_FLOAT = 6;
    public static final short SQL_REAL = 7;
    public static final short SQL_DOUBLE = 8;
    public static final short SQL_DATE = 9;
    public static final short SQL_TIME = 10;
    public static final short SQL_TIMESTAMP = 11;
    public static final short SQL_VARCHAR = 12;
    public static final short SQL_LONGVARCHAR = -1;
    public static final short SQL_BINARY = -2;
    public static final short SQL_VARBINARY = -3;
    public static final short SQL_LONGVARBINARY = -4;
    public static final short SQL_BIGINT = -5;
    public static final short SQL_TINYINT = -6;
    public static final short SQL_BIT = -7;

    public static final short SQL_C_BINARY = -2;
    public static final short SQL_C_BIT = -7;
    public static final short SQL_C_BOOKMARK = -18;
    public static final short SQL_C_CHAR = 1;
    public static final short SQL_C_DEFAULT = 99;
    public static final short SQL_C_DOUBLE = 8;
    public static final short SQL_C_FLOAT = 7;
    public static final short SQL_C_LONG = 4;
    public static final short SQL_C_SHORT = 5;
    public static final short SQL_C_SLONG = -16;
    public static final short SQL_C_SSHORT = -15;
    public static final short SQL_C_STINYINT = -26;
    public static final short SQL_C_DATE = 91;
    public static final short SQL_C_TIME = 92;
    public static final short SQL_C_TIMESTAMP = 93;
    public static final short SQL_C_TINYINT = -6;
    public static final short SQL_C_ULONG = -18;
    public static final short SQL_C_USHORT = -17;
    public static final short SQL_C_UTINYINT = -28;
    public static final short SQL_TYPE_NULL = 0;
    public static final short SQL_TYPE_UNKNOWN = 9999;
    public static final int SQL_NULL_HENV = 0;
    public static final int SQL_NULL_HDBC = 0;
    public static final int SQL_NULL_HSTMT = 0;
    public static final int SQL_NULL_DATA = -1;
    public static final int SQL_NO_TOTAL = -4;
    public static final short SQL_CLOSE = 0;
    public static final short SQL_DROP = 1;
    public static final short SQL_UNBIND = 2;
    public static final short SQL_RESET_PARAMS = 3;
    public static final short SQL_ACCESS_MODE = 101;
    public static final int SQL_MODE_READ_WRITE = 0;
    public static final int SQL_MODE_READ_ONLY = 1;
    public static final short SQL_AUTOCOMMIT = 102;
    public static final int SQL_AUTOCOMMIT_OFF = 0;
    public static final int SQL_AUTOCOMMIT_ON = 1;
    public static final short SQL_LOGIN_TIMEOUT = 103;
    public static final short SQL_TXN_ISOLATION = 108;
    public static final short SQL_CURRENT_QUALIFIER = 109;
    public static final short SQL_ACTIVE_CONNECTIONS = 0;
    public static final short SQL_ACTIVE_STATEMENTS = 1;
    public static final short SQL_DRIVER_NAME = 6;
    public static final short SQL_DRIVER_VER = 7;
    public static final short SQL_ODBC_VER = 10;
    public static final short SQL_SEARCH_PATTERN_ESCAPE = 14;
    public static final short SQL_ODBC_SQL_CONFORMANCE = 15;
    public static final short SQL_OSC_MINIMUM = 0;
    public static final short SQL_OSC_CORE = 1;
    public static final short SQL_OSC_EXTENDED = 2;
    public static final short SQL_DATABASE_NAME = 16;
    public static final short SQL_DBMS_NAME = 17;
    public static final short SQL_DBMS_VER = 18;
    public static final short SQL_ACCESSIBLE_TABLES = 19;
    public static final short SQL_ACCESSIBLE_PROCEDURES = 20;
    public static final short SQL_PROCEDURES = 21;
    public static final short SQL_CONCAT_NULL_BEHAVIOR = 22;
    public static final short SQL_CB_NULL = 0;
    public static final short SQL_CB_NON_NULL = 1;
    public static final short SQL_CURSOR_COMMIT_BEHAVIOR = 23;
    public static final short SQL_CURSOR_ROLLBACK_BEHAVIOR = 24;
    public static final short SQL_CB_DELETE = 0;
    public static final short SQL_CB_CLOSE = 1;
    public static final short SQL_CB_PRESERVE = 2;
    public static final short SQL_DATA_SOURCE_READ_ONLY = 25;
    public static final short SQL_DEFAULT_TXN_ISOLATION = 26;
    public static final short SQL_EXPRESSIONS_IN_ORDERBY = 27;
    public static final short SQL_IDENTIFIER_CASE = 28;
    public static final short SQL_IC_UPPER = 1;
    public static final short SQL_IC_LOWER = 2;
    public static final short SQL_IC_SENSITIVE = 3;
    public static final short SQL_IC_MIXED = 4;
    public static final short SQL_IDENTIFIER_QUOTE_CHAR = 29;
    public static final short SQL_MAX_COLUMN_NAME_LEN = 30;
    public static final short SQL_MAX_CURSOR_NAME_LEN = 31;
    public static final short SQL_MAX_OWNER_NAME_LEN = 32;
    public static final short SQL_MAX_PROCEDURE_NAME_LEN = 33;
    public static final short SQL_MAX_QUALIFIER_NAME_LEN = 34;
    public static final short SQL_MAX_TABLE_NAME_LEN = 35;
    public static final short SQL_MULT_RESULT_SETS = 36;
    public static final short SQL_MULTIPLE_ACTIVE_TXN = 37;
    public static final short SQL_OUTER_JOINS = 38;
    public static final short SQL_OWNER_TERM = 39;
    public static final short SQL_PROCEDURE_TERM = 40;
    public static final short SQL_QUALIFIER_NAME_SEPARATOR = 41;
    public static final short SQL_QUALIFIER_TERM = 42;
    public static final short SQL_TXN_CAPABLE = 46;
    public static final short SQL_TC_NONE = 0;
    public static final short SQL_TC_DML = 1;
    public static final short SQL_TC_ALL = 2;
    public static final short SQL_TC_DDL_COMMIT = 3;
    public static final short SQL_TC_DDL_IGNORE = 4;
    public static final short SQL_USER_NAME = 47;
    public static final short SQL_CONVERT_FUNCTIONS = 48;
    public static final int SQL_FN_CVT_CONVERT = 1;
    public static final short SQL_NUMERIC_FUNCTIONS = 49;
    public static final int SQL_FN_NUM_ABS = 1;
    public static final int SQL_FN_NUM_ACOS = 2;
    public static final int SQL_FN_NUM_ASIN = 4;
    public static final int SQL_FN_NUM_ATAN = 8;
    public static final int SQL_FN_NUM_ATAN2 = 16;
    public static final int SQL_FN_NUM_CEILING = 32;
    public static final int SQL_FN_NUM_COS = 64;
    public static final int SQL_FN_NUM_COT = 128;
    public static final int SQL_FN_NUM_EXP = 256;
    public static final int SQL_FN_NUM_FLOOR = 512;
    public static final int SQL_FN_NUM_LOG = 1024;
    public static final int SQL_FN_NUM_MOD = 2048;
    public static final int SQL_FN_NUM_SIGN = 4096;
    public static final int SQL_FN_NUM_SIN = 8192;
    public static final int SQL_FN_NUM_SQRT = 16384;
    public static final int SQL_FN_NUM_TAN = 32768;
    public static final int SQL_FN_NUM_PI = 0x10000;
    public static final int SQL_FN_NUM_RAND = 0x20000;