/* * 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. */ public class Types { /** *

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

The constant in the Java programming language * that identifies the generic SQL value * NULL. */ 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. */ 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 */ 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 */ 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 */ 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 */ 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 */ 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 */ 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 */ 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 */ 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 */ 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 * */ 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 */ 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 */ 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 */ 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 */ 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 */ 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() {} }