Class Types

java.lang.Object
java.sql.Types
public class Types extends Object

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

  • Field Summary

    Fields
    Modifier and Type
    Field
    Description
    static final int
    ARRAY
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type ARRAY.
    static final int
    BIGINT
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type BIGINT.
    static final int
    BINARY
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type BINARY.
    static final int
    BIT
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type BIT.
    static final int
    BLOB
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type BLOB.
    static final int
    BOOLEAN
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type BOOLEAN.
    static final int
    CHAR
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type CHAR.
    static final int
    CLOB
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type CLOB.
    static final int
    DATALINK
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type DATALINK.
    static final int
    DATE
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type DATE.
    static final int
    DECFLOAT
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type DECFLOAT.
    static final int
    DECIMAL
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type DECIMAL.
    static final int
    DISTINCT
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type DISTINCT.
    static final int
    DOUBLE
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type DOUBLE.
    static final int
    FLOAT
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type FLOAT.
    static final int
    INTEGER
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type INTEGER.
    static final int
    JAVA_OBJECT
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type JAVA_OBJECT.
    static final int
    JSON
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type JSON.
    static final int
    LONGNVARCHAR
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type LONGNVARCHAR.
    static final int
    LONGVARBINARY
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type LONGVARBINARY.
    static final int
    LONGVARCHAR
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type LONGVARCHAR.
    static final int
    NCHAR
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type NCHAR
    static final int
    NCLOB
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type NCLOB.
    static final int
    NULL
    The constant in the Java programming language that identifies the generic SQL value NULL.
    static final int
    NUMERIC
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type NUMERIC.
    static final int
    NVARCHAR
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type NVARCHAR.
    static final int
    OTHER
    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.
    static final int
    REAL
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type REAL.
    static final int
    REF
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type REF.
    static final int
    REF_CURSOR
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type REF CURSOR.
    static final int
    ROWID
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type ROWID
    static final int
    SMALLINT
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type SMALLINT.
    static final int
    SQLXML
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type XML.
    static final int
    STRUCT
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type STRUCT.
    static final int
    TIME
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type TIME.
    static final int
    TIME_WITH_TIMEZONE
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type TIME WITH TIMEZONE.
    static final int
    TIMESTAMP
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type TIMESTAMP.
    static final int
    TIMESTAMP_WITH_TIMEZONE
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type TIMESTAMP WITH TIMEZONE.
    static final int
    TINYINT
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type TINYINT.
    static final int
    VARBINARY
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type VARBINARY.
    static final int
    VARCHAR
    The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type VARCHAR.

  • Method Summary

    Methods declared in class Object

    clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
    Modifier and Type
    Method
    Description
    protected Object
    clone()
    Answers a new instance of the same class as the receiver, whose slots have been filled in with the values in the slots of the receiver.
    boolean
    equals(Object o)
    Compares the argument to the receiver, and answers true if they represent the same object using a class specific comparison.
    protected void
    finalize()
    Deprecated, for removal: This API element is subject to removal in a future version.
    May cause performance issues, deadlocks and hangs.
    final Class<? extends Object>
    getClass()
    Answers the unique instance of java.lang.Class which represents the class of the receiver.
    int
    hashCode()
    Answers an integer hash code for the receiver.
    final void
    notify()
    Causes one thread which is waiting on the receiver to be made ready to run.
    final void
    notifyAll()
    Causes all threads which are waiting on the receiver to be made ready to run.
    String
    toString()
    Answers a string containing a concise, human-readable description of the receiver.
    final void
    wait()
    Causes the thread which sent this message to be made not ready to run pending some change in the receiver (as indicated by notify or notifyAll).
    final void
    wait(long time)
    Causes the thread which sent this message to be made not ready to run either pending some change in the receiver (as indicated by notify or notifyAll) or the expiration of the timeout.
    final void
    wait(long time, int frac)
    Causes the thread which sent this message to be made not ready to run either pending some change in the receiver (as indicated by notify or notifyAll) or the expiration of the timeout.

  • Field Details

    • BIT

      public static final int BIT

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

      See Also:

    • TINYINT

      public static final int TINYINT

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

      See Also:

    • SMALLINT

      public static final int SMALLINT

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

      See Also:

    • INTEGER

      public static final int INTEGER

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

      See Also:

    • BIGINT

      public static final int BIGINT

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

      See Also:

    • FLOAT

      public static final int FLOAT

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

      See Also:

    • REAL

      public static final int REAL

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

      See Also:

    • DOUBLE

      public static final int DOUBLE

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

      See Also:

    • NUMERIC

      public static final int NUMERIC

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

      See Also:

    • DECIMAL

      public static final int DECIMAL

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

      See Also:

    • CHAR

      public static final int CHAR

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

      See Also:

    • VARCHAR

      public static final int VARCHAR

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

      See Also:

    • LONGVARCHAR

      public static final int LONGVARCHAR

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

      See Also:

    • DATE

      public static final int DATE

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

      See Also:

    • TIME

      public static final int TIME

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

      See Also:

    • TIMESTAMP

      public static final int TIMESTAMP

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

      See Also:

    • BINARY

      public static final int BINARY

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

      See Also:

    • VARBINARY

      public static final int VARBINARY

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

      See Also:

    • LONGVARBINARY

      public static final int LONGVARBINARY

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

      See Also:

    • NULL

      public static final int NULL

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

      See Also:

    • OTHER

      public static final int OTHER
      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.
      See Also:

    • JAVA_OBJECT

      public static final int JAVA_OBJECT
      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
      See Also:

    • DISTINCT

      public static final int DISTINCT
      The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type DISTINCT.
      Since:
      1.2
      See Also:

    • STRUCT

      public static final int STRUCT
      The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type STRUCT.
      Since:
      1.2
      See Also:

    • ARRAY

      public static final int ARRAY
      The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type ARRAY.
      Since:
      1.2
      See Also:

    • BLOB

      public static final int BLOB
      The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type BLOB.
      Since:
      1.2
      See Also:

    • CLOB

      public static final int CLOB
      The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type CLOB.
      Since:
      1.2
      See Also:

    • REF

      public static final int REF
      The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type REF.
      Since:
      1.2
      See Also:

    • BOOLEAN

      public static final int BOOLEAN
      The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type BOOLEAN.
      Since:
      1.4
      See Also:

    • ROWID

      public static final int ROWID
      The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type ROWID
      Since:
      1.6
      See Also:

    • NCHAR

      public static final int NCHAR
      The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type NCHAR
      Since:
      1.6
      See Also:

    • NVARCHAR

      public static final int NVARCHAR
      The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type NVARCHAR.
      Since:
      1.6
      See Also:

    • LONGNVARCHAR

      public static final int LONGNVARCHAR
      The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type LONGNVARCHAR.
      Since:
      1.6
      See Also:

    • NCLOB

      public static final int NCLOB
      The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type NCLOB.
      Since:
      1.6
      See Also:

    • SQLXML

      public static final int SQLXML
      The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type XML.
      Since:
      1.6
      See Also:

    • REF_CURSOR

      public static final int REF_CURSOR
      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
      See Also:

    • TIME_WITH_TIMEZONE

      public static final int TIME_WITH_TIMEZONE
      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
      See Also:

    • TIMESTAMP_WITH_TIMEZONE

      public static final int TIMESTAMP_WITH_TIMEZONE
      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
      See Also:

    • DECFLOAT

      public static final int DECFLOAT
      The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type DECFLOAT.
      Since:
      26
      See Also:

    • JSON

      public static final int JSON
      The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type JSON.
      Since:
      26
      See Also: