Back to index...

	/*
	* Copyright (c) 1996, 2014, Oracle and/or its affiliates. All rights reserved.
	* DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
	*
	* This code is free software; you can redistribute it and/or modify it
	* under the terms of the GNU General Public License version 2 only, as
	* published by the Free Software Foundation. Oracle designates this
	* particular file as subject to the "Classpath" exception as provided
	* by Oracle in the LICENSE file that accompanied this code.
	*
	* This code 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
	* version 2 for more details (a copy is included in the LICENSE file that
	* accompanied this code).
	*
	* You should have received a copy of the GNU General Public License version
	* 2 along with this work; if not, write to the Free Software Foundation,
	* Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA.
	*
	* Please contact Oracle, 500 Oracle Parkway, Redwood Shores, CA 94065 USA
	* or visit www.oracle.com if you need additional information or have any
	* questions.
	*/

	package java.sql;

	/**
	* <P>The class that defines the constants that are used to identify generic
	* SQL types, called JDBC types.
	* <p>
	* This class is never instantiated.
	*
	* @since 1.1
	*/
	public class Types {

	/**
	* <P>The constant in the Java programming language, sometimes referred
	* to as a type code, that identifies the generic SQL type
	* <code>BIT</code>.
	*/
	public final static int BIT = -7;

	/**
	* <P>The constant in the Java programming language, sometimes referred
	* to as a type code, that identifies the generic SQL type
	* <code>TINYINT</code>.
	*/
	public final static int TINYINT = -6;

	/**
	* <P>The constant in the Java programming language, sometimes referred
	* to as a type code, that identifies the generic SQL type
	* <code>SMALLINT</code>.
	*/
	public final static int SMALLINT = 5;

	/**
	* <P>The constant in the Java programming language, sometimes referred
	* to as a type code, that identifies the generic SQL type
	* <code>INTEGER</code>.
	*/
	public final static int INTEGER = 4;

	/**
	* <P>The constant in the Java programming language, sometimes referred
	* to as a type code, that identifies the generic SQL type
	* <code>BIGINT</code>.
	*/
	public final static int BIGINT = -5;

	/**
	* <P>The constant in the Java programming language, sometimes referred
	* to as a type code, that identifies the generic SQL type
	* <code>FLOAT</code>.
	*/
	public final static int FLOAT = 6;

	/**
	* <P>The constant in the Java programming language, sometimes referred
	* to as a type code, that identifies the generic SQL type
	* <code>REAL</code>.
	*/
	public final static int REAL = 7;


	/**
	* <P>The constant in the Java programming language, sometimes referred
	* to as a type code, that identifies the generic SQL type
	* <code>DOUBLE</code>.
	*/
	public final static int DOUBLE = 8;

	/**
	* <P>The constant in the Java programming language, sometimes referred
	* to as a type code, that identifies the generic SQL type
	* <code>NUMERIC</code>.
	*/
	public final static int NUMERIC = 2;

	/**
	* <P>The constant in the Java programming language, sometimes referred
	* to as a type code, that identifies the generic SQL type
	* <code>DECIMAL</code>.
	*/
	public final static int DECIMAL = 3;

	/**
	* <P>The constant in the Java programming language, sometimes referred
	* to as a type code, that identifies the generic SQL type
	* <code>CHAR</code>.
	*/
	public final static int CHAR = 1;

	/**
	* <P>The constant in the Java programming language, sometimes referred
	* to as a type code, that identifies the generic SQL type
	* <code>VARCHAR</code>.
	*/
	public final static int VARCHAR = 12;

	/**
	* <P>The constant in the Java programming language, sometimes referred
	* to as a type code, that identifies the generic SQL type
	* <code>LONGVARCHAR</code>.
	*/
	public final static int LONGVARCHAR = -1;


	/**
	* <P>The constant in the Java programming language, sometimes referred
	* to as a type code, that identifies the generic SQL type
	* <code>DATE</code>.
	*/
	public final static int DATE = 91;

	/**
	* <P>The constant in the Java programming language, sometimes referred
	* to as a type code, that identifies the generic SQL type
	* <code>TIME</code>.
	*/
	public final static int TIME = 92;

	/**
	* <P>The constant in the Java programming language, sometimes referred
	* to as a type code, that identifies the generic SQL type
	* <code>TIMESTAMP</code>.
	*/
	public final static int TIMESTAMP = 93;


	/**
	* <P>The constant in the Java programming language, sometimes referred
	* to as a type code, that identifies the generic SQL type
	* <code>BINARY</code>.
	*/
	public final static int BINARY = -2;

	/**
	* <P>The constant in the Java programming language, sometimes referred
	* to as a type code, that identifies the generic SQL type
	* <code>VARBINARY</code>.
	*/
	public final static int VARBINARY = -3;

	/**
	* <P>The constant in the Java programming language, sometimes referred
	* to as a type code, that identifies the generic SQL type
	* <code>LONGVARBINARY</code>.
	*/
	public final static int LONGVARBINARY = -4;

	/**
	* <P>The constant in the Java programming language
	* that identifies the generic SQL value
	* <code>NULL</code>.
	*/
	public final static int NULL = 0;

	/**
	* The constant in the Java programming language that indicates
	* that the SQL type is database-specific and
	* gets mapped to a Java object that can be accessed via
	* the methods <code>getObject</code> and <code>setObject</code>.
	*/
	public final static int OTHER = 1111;



	/**
	* The constant in the Java programming language, sometimes referred to
	* as a type code, that identifies the generic SQL type
	* <code>JAVA_OBJECT</code>.
	* @since 1.2
	*/
	public final static int JAVA_OBJECT = 2000;

	/**
	* The constant in the Java programming language, sometimes referred to
	* as a type code, that identifies the generic SQL type
	* <code>DISTINCT</code>.
	* @since 1.2
	*/
	public final static int DISTINCT = 2001;

	/**
	* The constant in the Java programming language, sometimes referred to
	* as a type code, that identifies the generic SQL type
	* <code>STRUCT</code>.
	* @since 1.2
	*/
	public final static int STRUCT = 2002;

	/**
	* The constant in the Java programming language, sometimes referred to
	* as a type code, that identifies the generic SQL type
	* <code>ARRAY</code>.
	* @since 1.2
	*/
	public final static int ARRAY = 2003;

	/**
	* The constant in the Java programming language, sometimes referred to
	* as a type code, that identifies the generic SQL type
	* <code>BLOB</code>.
	* @since 1.2
	*/
	public final static int BLOB = 2004;

	/**
	* The constant in the Java programming language, sometimes referred to
	* as a type code, that identifies the generic SQL type
	* <code>CLOB</code>.
	* @since 1.2
	*/
	public final static int CLOB = 2005;

	/**
	* The constant in the Java programming language, sometimes referred to
	* as a type code, that identifies the generic SQL type
	* <code>REF</code>.
	* @since 1.2
	*/
	public final static int REF = 2006;

	/**
	* The constant in the Java programming language, sometimes referred to
	* as a type code, that identifies the generic SQL type <code>DATALINK</code>.
	*
	* @since 1.4
	*/
	public final static int DATALINK = 70;

	/**
	* The constant in the Java programming language, sometimes referred to
	* as a type code, that identifies the generic SQL type <code>BOOLEAN</code>.
	*
	* @since 1.4
	*/
	public final static int BOOLEAN = 16;

	//------------------------- JDBC 4.0 -----------------------------------

	/**
	* The constant in the Java programming language, sometimes referred to
	* as a type code, that identifies the generic SQL type <code>ROWID</code>
	*
	* @since 1.6
	*
	*/
	public final static int ROWID = -8;

	/**
	* The constant in the Java programming language, sometimes referred to
	* as a type code, that identifies the generic SQL type <code>NCHAR</code>
	*
	* @since 1.6
	*/
	public static final int NCHAR = -15;

	/**
	* The constant in the Java programming language, sometimes referred to
	* as a type code, that identifies the generic SQL type <code>NVARCHAR</code>.
	*
	* @since 1.6
	*/
	public static final int NVARCHAR = -9;

	/**
	* The constant in the Java programming language, sometimes referred to
	* as a type code, that identifies the generic SQL type <code>LONGNVARCHAR</code>.
	*
	* @since 1.6
	*/
	public static final int LONGNVARCHAR = -16;

	/**
	* The constant in the Java programming language, sometimes referred to
	* as a type code, that identifies the generic SQL type <code>NCLOB</code>.
	*
	* @since 1.6
	*/
	public static final int NCLOB = 2011;

	/**
	* The constant in the Java programming language, sometimes referred to
	* as a type code, that identifies the generic SQL type <code>XML</code>.
	*
	* @since 1.6
	*/
	public static final int SQLXML = 2009;

	//--------------------------JDBC 4.2 -----------------------------

	/**
	* The constant in the Java programming language, sometimes referred to
	* as a type code, that identifies the generic SQL type {@code REF CURSOR}.
	*
	* @since 1.8
	*/
	public static final int REF_CURSOR = 2012;

	/**
	* The constant in the Java programming language, sometimes referred to
	* as a type code, that identifies the generic SQL type
	* {@code TIME WITH TIMEZONE}.
	*
	* @since 1.8
	*/
	public static final int TIME_WITH_TIMEZONE = 2013;

	/**
	* The constant in the Java programming language, sometimes referred to
	* as a type code, that identifies the generic SQL type
	* {@code TIMESTAMP WITH TIMEZONE}.
	*
	* @since 1.8
	*/
	public static final int TIMESTAMP_WITH_TIMEZONE = 2014;

	// Prevent instantiation
	private Types() {}
	}

Back to index...