Results container/Supported types

Supported component types in are described in results containar the follwing tables.

table:primitive type

type get value from ResultSet by Typical JDBC type

boolean getBoolean BOOLEAN

byte getByte TINYINT

short getShort SMALLINT

int getInt INTEGER

long getLong BIGINT

char getString and get the first char CHAR, VARCHAR

float getFloat REAL

double getDouble FLOAT, DOUBLE

table:class

type get value from ResultSet by Typical JDBC type

java.io.InputStream getBinaryStream LONGVARBINARY

java.io.Reader getCharacterStream LONGVARCHAR

java.lang.Boolean getBoolean BOOLEAN

java.lang.Byte getByte TINYINT

java.lang.Short getShort SMALLINT

java.lang.Integer getInt INTEGER

java.lang.Long getLong BIGINT

java.lang.Character getString and get the first char

java.lang.Float getFloat REAL

java.lang.Double getDouble DOUBLE

java.lang.String getString VARCHAR

java.lang.Enum getString and convert to Enum VARCHAR

java.lang.Object getObject JAVA_OBJECT

java.math.BigDecimal getBigDecimal NUMERICAL

java.sql.Blob getBlob BLOB

java.sql.Clob getClob CLOB

java.sql.Date getDate DATE

java.sql.Time getTime TIME

java.sql.Timestamp getTimeStamp TIMESTAMP

java.time.LocalDate getObject as LocalDate DATE

java.time.LocalDateTime getObject as LocalDateTime TIMESTAMP

java.time.LocalTime getTime and convert to LocalTime TIME

java.time.OffsetTime getObject as OffsetTime TIME_WITH_TIMEZONE

java.time.OffsetDateTime getObject as OffsetDateTime TIMESTAMP_WITH_TIMEZONE

java.time.Instant getObject as Instant TIMESTAMP_WITH_TIMEZONE

java.util.Date getObject as Date TIMESTAMP

java.util.UUID getObject as UUID VARCHAR

table:array

type get value from ResultSet by Typical JDBC Type

byte[] getBytes VARBINARY

OTHER_TYPE[] getArray and convert to OTHER_TYPE[] ARRAY e.g.) int[] getArray and convert to int[]