VerticaTypes
-
java.lang.Object
-
com.vertica.jdbc.VerticaTypes
public class VerticaTypes
extends java.lang.Object
This class defines Vertica identifiers for data types Vertica supports but which are not represented in java.sql.types.
These identifiers are used in metadata queries and to give Vertica JDBC applications a way to specify the types and determine how to correctly get or set their values.
Interval type constants
The JDBC specification does not define first class support for interval data types. There are no java.sql.Types type identifiers for intervals, there is no built in setter on the PreparedStatement interface and no built in getter on the ResultSet interface.
Instead, the Vertica JDBC driver follows the ODBC standard when it can. Each of the 10 day/time interval ranges is identified by the ODBC standard SQL type identifier. Those identifiers are recreated as integer fields in this class, analogous to those defined for the other data types by java.sql.Types.
UUID type constant
The JDBC specification does not define a UUID type. The Vertica JDBC driver uses the ODBC type identifier for UUIDs.
Field Summary
| Modifier and Type | Field and Description |
|---|---|
| static int | INTERVAL_DAY The ODBC SQL type identifier for an INTERVAL DAY interval. |
| static int | INTERVAL_DAY_TO_HOUR The ODBC SQL type identifier for an INTERVAL DAY TO HOUR interval. |
| static int | INTERVAL_DAY_TO_MINUTE The ODBC SQL type identifier for an INTERVAL DAY TO MINUTE interval. |
| static int | INTERVAL_DAY_TO_SECOND The ODBC SQL type identifier for an INTERVAL DAY TO SECOND interval. |
| static int | INTERVAL_HOUR The ODBC SQL type identifier for an INTERVAL HOUR interval. |
| static int | INTERVAL_HOUR_TO_MINUTE The ODBC SQL type identifier for an INTERVAL HOUR TO MINUTE interval. |
| static int | INTERVAL_HOUR_TO_SECOND The ODBC SQL type identifier for an INTERVAL HOUR TO SECOND interval. |
| static int | INTERVAL_MINUTE The ODBC SQL type identifier for an INTERVAL MINUTE interval. |
| static int | INTERVAL_MINUTE_TO_SECOND The ODBC SQL type identifier for an INTERVAL MINUTE TO SECOND interval. |
| static int | INTERVAL_MONTH The ODBC SQL type identifier for an INTERVAL MONTH interval. |
| static int | INTERVAL_SECOND The ODBC SQL type identifier for an INTERVAL SECOND interval. |
| static int | INTERVAL_YEAR The ODBC SQL type identifier for an INTERVAL YEAR interval. |
| static int | INTERVAL_YEAR_TO_MONTH The ODBC SQL type identifier for an INTERVAL YEAR TO MONTH interval. |
| static int | UUID The ODBC SQL type identifier for a UUID. |
Constructor Summary
| Constructor and Description |
|---|
| VerticaTypes() |
Method Summary
Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
Field Detail
INTERVAL_DAY
public static final int INTERVAL_DAY
The ODBC SQL type identifier for an INTERVAL DAY interval. See Also:Constant Field Values
INTERVAL_DAY_TO_HOUR
public static final int INTERVAL_DAY_TO_HOUR
The ODBC SQL type identifier for an INTERVAL DAY TO HOUR interval. See Also:Constant Field Values
INTERVAL_DAY_TO_MINUTE
public static final int INTERVAL_DAY_TO_MINUTE
The ODBC SQL type identifier for an INTERVAL DAY TO MINUTE interval. See Also:Constant Field Values
INTERVAL_DAY_TO_SECOND
public static final int INTERVAL_DAY_TO_SECOND
The ODBC SQL type identifier for an INTERVAL DAY TO SECOND interval. See Also:Constant Field Values
INTERVAL_HOUR
public static final int INTERVAL_HOUR
The ODBC SQL type identifier for an INTERVAL HOUR interval. See Also:Constant Field Values
INTERVAL_HOUR_TO_MINUTE
public static final int INTERVAL_HOUR_TO_MINUTE
The ODBC SQL type identifier for an INTERVAL HOUR TO MINUTE interval. See Also:Constant Field Values
INTERVAL_HOUR_TO_SECOND
public static final int INTERVAL_HOUR_TO_SECOND
The ODBC SQL type identifier for an INTERVAL HOUR TO SECOND interval. See Also:Constant Field Values
INTERVAL_MINUTE
public static final int INTERVAL_MINUTE
The ODBC SQL type identifier for an INTERVAL MINUTE interval. See Also:Constant Field Values
INTERVAL_MINUTE_TO_SECOND
public static final int INTERVAL_MINUTE_TO_SECOND
The ODBC SQL type identifier for an INTERVAL MINUTE TO SECOND interval. See Also:Constant Field Values
INTERVAL_SECOND
public static final int INTERVAL_SECOND
The ODBC SQL type identifier for an INTERVAL SECOND interval. See Also:Constant Field Values
INTERVAL_YEAR
public static final int INTERVAL_YEAR
The ODBC SQL type identifier for an INTERVAL YEAR interval. See Also:Constant Field Values
INTERVAL_YEAR_TO_MONTH
public static final int INTERVAL_YEAR_TO_MONTH
The ODBC SQL type identifier for an INTERVAL YEAR TO MONTH interval. See Also:Constant Field Values
INTERVAL_MONTH
public static final int INTERVAL_MONTH
The ODBC SQL type identifier for an INTERVAL MONTH interval. See Also:Constant Field Values
UUID
public static final int UUID
The ODBC SQL type identifier for a UUID. See Also:Constant Field Values
Constructor Detail
VerticaTypes
public VerticaTypes()