/* Copyright (C) 2002-2007 MySQL AB This program is free software; you can redistribute it and/or modify it under the terms of version 2 of the GNU General Public License as  published by the Free Software Foundation. There are special exceptions to the terms and conditions of the GPL  as it is applied to this software. View the full text of the  exception in file EXCEPTIONS-CONNECTOR-J in the directory of this  software distribution. 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., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA */package com.mysql.jdbc;import java.sql.Types;import java.util.HashMap;import java.util.Iterator;import java.util.Map;/** * MysqlDefs contains many values that are needed for communication with the * MySQL server. *  * @author Mark Matthews * @version $Id: MysqlDefs.java 6376 2007-04-05 21:56:05Z mmatthews $ */public final class MysqlDefs {	// ~ Static fields/initializers	// ---------------------------------------------	static final int COM_BINLOG_DUMP = 18;	static final int COM_CHANGE_USER = 17;	static final int COM_CLOSE_STATEMENT = 25;	static final int COM_CONNECT_OUT = 20;	static final int COM_END = 29;	static final int COM_EXECUTE = 23;	static final int COM_FETCH = 28;	static final int COM_LONG_DATA = 24;	static final int COM_PREPARE = 22;	static final int COM_REGISTER_SLAVE = 21;	static final int COM_RESET_STMT = 26;	static final int COM_SET_OPTION = 27;	static final int COM_TABLE_DUMP = 19;	static final int CONNECT = 11;	static final int CREATE_DB = 5;	static final int DEBUG = 13;	static final int DELAYED_INSERT = 16;	static final int DROP_DB = 6;	static final int FIELD_LIST = 4;	static final int FIELD_TYPE_BIT = 16;	public static final int FIELD_TYPE_BLOB = 252;	static final int FIELD_TYPE_DATE = 10;	static final int FIELD_TYPE_DATETIME = 12;	// Data Types	static final int FIELD_TYPE_DECIMAL = 0;	static final int FIELD_TYPE_DOUBLE = 5;	static final int FIELD_TYPE_ENUM = 247;	static final int FIELD_TYPE_FLOAT = 4;	static final int FIELD_TYPE_GEOMETRY = 255;	static final int FIELD_TYPE_INT24 = 9;	static final int FIELD_TYPE_LONG = 3;	static final int FIELD_TYPE_LONG_BLOB = 251;	static final int FIELD_TYPE_LONGLONG = 8;	static final int FIELD_TYPE_MEDIUM_BLOB = 250;	static final int FIELD_TYPE_NEW_DECIMAL = 246;	static final int FIELD_TYPE_NEWDATE = 14;	static final int FIELD_TYPE_NULL = 6;	static final int FIELD_TYPE_SET = 248;	static final int FIELD_TYPE_SHORT = 2;	static final int FIELD_TYPE_STRING = 254;	static final int FIELD_TYPE_TIME = 11;	static final int FIELD_TYPE_TIMESTAMP = 7;	static final int FIELD_TYPE_TINY = 1;	// Older data types	static final int FIELD_TYPE_TINY_BLOB = 249;	static final int FIELD_TYPE_VAR_STRING = 253;	static final int FIELD_TYPE_VARCHAR = 15;	// Newer data types	static final int FIELD_TYPE_YEAR = 13;	static final int INIT_DB = 2;	static final long LENGTH_BLOB = 65535;	static final long LENGTH_LONGBLOB = 4294967295L;	static final long LENGTH_MEDIUMBLOB = 16777215;	static final long LENGTH_TINYBLOB = 255;	// Limitations	static final int MAX_ROWS = 50000000; // From the MySQL FAQ	/**	 * Used to indicate that the server sent no field-level character set	 * information, so the driver should use the connection-level character	 * encoding instead.	 */	public static final int NO_CHARSET_INFO = -1;	static final byte OPEN_CURSOR_FLAG = 1;	static final int PING = 14;	static final int PROCESS_INFO = 10;	static final int PROCESS_KILL = 12;	static final int QUERY = 3;	static final int QUIT = 1;	// ~ Methods	// ----------------------------------------------------------------	static final int RELOAD = 7;	static final int SHUTDOWN = 8;	//	// Constants defined from mysql	//	// DB Operations	static final int SLEEP = 0;	static final int STATISTICS = 9;	static final int TIME = 15;	/**	 * Maps the given MySQL type to the correct JDBC type.	 */	static int mysqlToJavaType(int mysqlType) {		int jdbcType;		switch (mysqlType) {		case MysqlDefs.FIELD_TYPE_NEW_DECIMAL:		case MysqlDefs.FIELD_TYPE_DECIMAL:			jdbcType = Types.DECIMAL;			break;		case MysqlDefs.FIELD_TYPE_TINY:			jdbcType = Types.TINYINT;			break;		case MysqlDefs.FIELD_TYPE_SHORT:			jdbcType = Types.SMALLINT;			break;		case MysqlDefs.FIELD_TYPE_LONG:			jdbcType = Types.INTEGER;			break;		case MysqlDefs.FIELD_TYPE_FLOAT:			jdbcType = Types.REAL;			break;		case MysqlDefs.FIELD_TYPE_DOUBLE:			jdbcType = Types.DOUBLE;			break;		case MysqlDefs.FIELD_TYPE_NULL:			jdbcType = Types.NULL;			break;		case MysqlDefs.FIELD_TYPE_TIMESTAMP:			jdbcType = Types.TIMESTAMP;			break;		case MysqlDefs.FIELD_TYPE_LONGLONG:			jdbcType = Types.BIGINT;			break;		case MysqlDefs.FIELD_TYPE_INT24:			jdbcType = Types.INTEGER;			break;		case MysqlDefs.FIELD_TYPE_DATE:			jdbcType = Types.DATE;			break;		case MysqlDefs.FIELD_TYPE_TIME:			jdbcType = Types.TIME;			break;		case MysqlDefs.FIELD_TYPE_DATETIME:			jdbcType = Types.TIMESTAMP;			break;		case MysqlDefs.FIELD_TYPE_YEAR:			jdbcType = Types.DATE;			break;		case MysqlDefs.FIELD_TYPE_NEWDATE:			jdbcType = Types.DATE;			break;		case MysqlDefs.FIELD_TYPE_ENUM:			jdbcType = Types.CHAR;			break;		case MysqlDefs.FIELD_TYPE_SET:			jdbcType = Types.CHAR;			break;		case MysqlDefs.FIELD_TYPE_TINY_BLOB:			jdbcType = Types.VARBINARY;			break;		case MysqlDefs.FIELD_TYPE_MEDIUM_BLOB:			jdbcType = Types.LONGVARBINARY;			break;		case MysqlDefs.FIELD_TYPE_LONG_BLOB:			jdbcType = Types.LONGVARBINARY;			break;		case MysqlDefs.FIELD_TYPE_BLOB:			jdbcType = Types.LONGVARBINARY;