VerticaTypes (Vertica JDBC API Documentation)

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

Fields
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

Constructors
Constructor and Description

VerticaTypes()

Constructors
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()
```

Class VerticaTypes

Field Summary

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Field Detail

INTERVAL_DAY

INTERVAL_DAY_TO_HOUR

INTERVAL_DAY_TO_MINUTE

INTERVAL_DAY_TO_SECOND

INTERVAL_HOUR

INTERVAL_HOUR_TO_MINUTE

INTERVAL_HOUR_TO_SECOND

INTERVAL_MINUTE

INTERVAL_MINUTE_TO_SECOND

INTERVAL_SECOND

INTERVAL_YEAR

INTERVAL_YEAR_TO_MONTH

INTERVAL_MONTH

UUID

Constructor Detail

VerticaTypes