Supported Types

You are looking at an older version of the documentation. The latest version is found here.

Data Virtuality Server Runtime Types

Type	Description	Java Runtime Class	JDBC Type	ODBC Type
`string` or `varchar`	Variable length character string with a maximum length of 4000	`java.lang.String`	`VARCHAR`	`VARCHAR`
`varbinary`	Variable length binary string with a maximum length of 8192	`byte[]`	`VARBINARY`	`VARBINARY`
`char`	A single Unicode character	`java.lang.Character`	`CHAR`	`CHAR`
`boolean`	A single bit, or boolean, that can be `TRUE`, `FALSE`, or `NULL` (unknown)	`java.lang.Boolean`	`BIT`	`SMALLINT`
`byte` or `tinyint`	Numeric, integral type, signed 8-bit	`java.lang.Byte`	`TINYINT`	`SMALLINT`
`short` or `smallint`	Numeric, integral type, signed 16-bit	`java.lang.Short`	`SMALLINT`	`SMALLINT`
`integer` or `serial`	Numeric, integral type, signed 32-bit. The serial type also implies not null and has an auto-incrementing value that starts at 1. serial types are not automatically UNIQUE	`java.lang.Integer`	`INTEGER`	`INTEGER`
`long` or `bigint`	Numeric, integral type, signed 64-bit	`java.lang.Long`	`BIGINT`	`NUMERIC`
`biginteger`	Numeric, integral type, arbitrary precision of up to 1000 digits	`java.lang.BigInteger`	`NUMERIC`	`NUMERIC`
`float` or `real`	Numeric, floating point type, 32-bit IEEE 754 floating-point numbers	`java.lang.Float`	`REAL`	`FLOAT`
`double`	Numeric, floating point type, 64-bit IEEE 754 floating-point numbers	`java.lang.Double`	`DOUBLE`	`DOUBLE`
`bigdecimal` or `decimal`	Numeric, floating point type, arbitrary precision of up to 1000 digits. Note that the precision and scale cannot be explicitly set with the type literal, e.g. decimal(38, 2)	`java.math.BigDecimal`	`NUMERIC`	`NUMERIC`
`date`	Datetime, representing a single day (year, month, day)	`java.sql.Date`	`DATE`	`DATE`
`time`	Datetime, representing a single time (hours, minutes, seconds, milliseconds)	`java.sql.Time`	`TIME`	`TIME`
`timestamp`	Datetime, representing a single date and time (year, month, day, hours, minutes, seconds, milliseconds, nanoseconds)	`java.sql.Timestamp`	`TIMESTAMP`	`TIMESTAMP`
`object`	Any arbitrary Java object, must implement java.lang.Serializable	`Any`	`JAVA_OBJECT`	`VARCHAR`
`blob`	Binary large object, representing a stream of bytes	`java.sql.Blob`	`BLOB`	`VARCHAR`
`clob`	Character large object, representing a stream of characters	`java.sql.Clob`	`CLOB`	`VARCHAR`
`xml`	XML document	`java.sql.SQLXML`	`JAVA_OBJECT`	`VARCHAR`