/*
 * 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;

The class that defines the constants that are used to identify generic SQL types, called JDBC types.

This class is never instantiated.

Since:1.1
/** * <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 {

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type BIT.

/** * <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;

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type TINYINT.

/** * <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;

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type SMALLINT.

/** * <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;

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type INTEGER.

/** * <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;

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type BIGINT.

/** * <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;

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type FLOAT.

/** * <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;

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type REAL.

/** * <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;

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type DOUBLE.

/** * <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;

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type NUMERIC.

/** * <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;

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type DECIMAL.

/** * <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;

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type CHAR.

/** * <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;

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type VARCHAR.

/** * <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;

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type LONGVARCHAR.

/** * <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;

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type DATE.

/** * <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;

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type TIME.

/** * <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;

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type TIMESTAMP.

/** * <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;

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type BINARY.

/** * <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;

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type VARBINARY.

/** * <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;

The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type LONGVARBINARY.

/** * <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;

The constant in the Java programming language that identifies the generic SQL value NULL.

/** * <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 getObject and setObject.
/** * 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 JAVA_OBJECT.
Since:1.2
/** * 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 DISTINCT.
Since:1.2
/** * 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 STRUCT.
Since:1.2
/** * 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 ARRAY.
Since:1.2
/** * 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 BLOB.
Since:1.2
/** * 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 CLOB.
Since:1.2
/** * 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 REF.
Since:1.2
/** * 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 DATALINK.
Since:1.4
/** * 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 BOOLEAN.
Since:1.4
/** * 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 ROWID
Since:1.6
/** * 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 NCHAR
Since:1.6
/** * 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 NVARCHAR.
Since:1.6
/** * 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 LONGNVARCHAR.
Since:1.6
/** * 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 NCLOB.
Since:1.6
/** * 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 XML.
Since:1.6
/** * 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 REF CURSOR.
Since:1.8
/** * 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 TIME WITH TIMEZONE.
Since:1.8
/** * 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 TIMESTAMP WITH TIMEZONE.
Since:1.8
/** * 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() {} }