The VerticaTypes class

JDBC does not support all of the data types that OpenText™ Analytics Database supports. The OpenText™ Analytics Database JDBC client driver contains an additional class named VerticaTypes that helps you handle identifying these database-specific data types. It contains constants that you can use in your code to specify database data types. This class defines two different categories of data types:

• Vertica's 13 types of interval values. This class contains constant properties for each of these types. You can use these constants to select a specific interval type when instantiating members of the VerticaDayTimeInterval and VerticaYearMonthInterval classes:

  // Create a day to second interval.
  VerticaDayTimeInterval dayInt = new VerticaDayTimeInterval(
          VerticaTypes.INTERVAL_DAY_TO_SECOND, 10, 0, 5, 40, 0, 0, false);
  // Create a year to month interval.
  VerticaYearMonthInterval monthInt = new VerticaYearMonthInterval(
          VerticaTypes.INTERVAL_YEAR_TO_MONTH, 10, 6, false);
  

• Vertica UUID data type. One way you can use the VerticaTypes.UUID is to query a table's metadata to see if a column is a UUID. See UUID values for an example.

See the JDBC documentation for more information on this class.