io.rdbc.japi

Interface Row

public interface Row

Represents a row of a result returned by a database engine.

This class defines a set of methods that can be used to get values from the row either by a column name or by a column index. Each method has a version returning an Optional to allow null-safe handling of SQL NULL values.

Method Summary

Modifier and Type	Method and Description
java.math.BigDecimal	getBigDecimal(int idx) Returns a BigDecimal from column with a given index.
java.math.BigDecimal	getBigDecimal(java.lang.String name) Returns a BigDecimal from column with a given name.
java.util.Optional<java.math.BigDecimal>	getBigDecimalOpt(int idx) Returns a BigDecimal from column with a given index.
java.util.Optional<java.math.BigDecimal>	getBigDecimalOpt(java.lang.String name) Returns a BigDecimal from column with a given name.
java.lang.Boolean	getBool(int idx) Returns a boolean value from column with a given index.
java.lang.Boolean	getBool(java.lang.String name) Returns a boolean value from column with a given name.
java.util.Optional<java.lang.Boolean>	getBoolOpt(int idx) Returns a boolean value from column with a given index.
java.util.Optional<java.lang.Boolean>	getBoolOpt(java.lang.String name) Returns a boolean value from column with a given name.
byte[]	getBytes(int idx) Returns a byte array from column with a given index.
byte[]	getBytes(java.lang.String name) Returns a byte array from column with a given name.
java.util.Optional<byte[]>	getBytesOpt(int idx) Returns a byte array from column with a given index.
java.util.Optional<byte[]>	getBytesOpt(java.lang.String name) Returns a byte array from column with a given name.
java.lang.Character	getChar(int idx) Returns a character from column with a given index.
java.lang.Character	getChar(java.lang.String name) Returns a character from column with a given name.
java.util.Optional<java.lang.Character>	getCharOpt(int idx) Returns a character from column with a given index.
java.util.Optional<java.lang.Character>	getCharOpt(java.lang.String name) Returns a character from column with a given name.
<T> T	getCol(int idx, java.lang.Class<T> cls) Returns an object of type T from column with a given index.
<T> T	getCol(java.lang.String name, java.lang.Class<T> cls) Returns an object of type T from column with a given name.
<T> java.util.Optional<T>	getColOpt(int idx, java.lang.Class<T> cls) Returns an object of type T from column with a given index.
<T> java.util.Optional<T>	getColOpt(java.lang.String name, java.lang.Class<T> cls) Returns an object of type T from column with a given name.
java.lang.Double	getDouble(int idx) Returns a Double from column with a given index.
java.lang.Double	getDouble(java.lang.String name) Returns a Double from column with a given name.
java.util.Optional<java.lang.Double>	getDoubleOpt(int idx) Returns a Double from column with a given index.
java.util.Optional<java.lang.Double>	getDoubleOpt(java.lang.String name) Returns a Double from column with a given name.
java.lang.Float	getFloat(int idx) Returns a Float from column with a given index.
java.lang.Float	getFloat(java.lang.String name) Returns a Float from column with a given name.
java.util.Optional<java.lang.Float>	getFloatOpt(int idx) Returns a Float from column with a given index.
java.util.Optional<java.lang.Float>	getFloatOpt(java.lang.String name) Returns a Float from column with a given name.
java.time.Instant	getInstant(int idx) Returns an Instant from column with a given index.
java.time.Instant	getInstant(java.lang.String name) Returns an Instant from column with a given name.
java.util.Optional<java.time.Instant>	getInstantOpt(int idx) Returns an Instant from column with a given index.
java.util.Optional<java.time.Instant>	getInstantOpt(java.lang.String name) Returns an Instant from column with a given name.
java.lang.Integer	getInt(int idx) Returns an int from column with a given index.
java.lang.Integer	getInt(java.lang.String name) Returns an int from column with a given name.
java.util.Optional<java.lang.Integer>	getIntOpt(int idx) Returns an int from column with a given index.
java.util.Optional<java.lang.Integer>	getIntOpt(java.lang.String name) Returns an int from column with a given name.
java.time.LocalDate	getLocalDate(int idx) Returns a LocalDate from column with a given index.
java.time.LocalDate	getLocalDate(java.lang.String name) Returns a LocalDate from column with a given name.
java.util.Optional<java.time.LocalDate>	getLocalDateOpt(int idx) Returns a LocalDate from column with a given index.
java.util.Optional<java.time.LocalDate>	getLocalDateOpt(java.lang.String name) Returns a LocalDate from column with a given name.
java.time.LocalDateTime	getLocalDateTime(int idx) Returns a LocalDateTime from column with a given index.
java.time.LocalDateTime	getLocalDateTime(java.lang.String name) Returns a LocalDateTime from column with a given name.
java.util.Optional<java.time.LocalDateTime>	getLocalDateTimeOpt(int idx) Returns a LocalDateTime from column with a given index.
java.util.Optional<java.time.LocalDateTime>	getLocalDateTimeOpt(java.lang.String name) Returns a LocalDateTime from column with a given name.
java.time.LocalTime	getLocalTime(int idx) Returns a LocalDate from column with a given index.
java.time.LocalTime	getLocalTime(java.lang.String name) Returns a LocalDate from column with a given name.
java.util.Optional<java.time.LocalTime>	getLocalTimeOpt(int idx) Returns a LocalDate from column with a given index.
java.util.Optional<java.time.LocalTime>	getLocalTimeOpt(java.lang.String name) Returns a LocalDate from column with a given name.
java.lang.Long	getLong(int idx) Returns a Long from column with a given index.
java.lang.Long	getLong(java.lang.String name) Returns a Long from column with a given name.
java.util.Optional<java.lang.Long>	getLongOpt(int idx) Returns a Long from column with a given index.
java.util.Optional<java.lang.Long>	getLongOpt(java.lang.String name) Returns a Long from column with a given name.
SqlNumeric	getNumeric(int idx) Returns a SqlNumeric from column with a given index.
SqlNumeric	getNumeric(java.lang.String name) Returns a SqlNumeric from column with a given name.
java.util.Optional<SqlNumeric>	getNumericOpt(int idx) Returns a SqlNumeric from column with a given index.
java.util.Optional<SqlNumeric>	getNumericOpt(java.lang.String name) Returns a SqlNumeric from column with a given name.
java.lang.Short	getShort(int idx) Returns a Short from column with a given index.
java.lang.Short	getShort(java.lang.String name) Returns a Short from column with a given name.
java.util.Optional<java.lang.Short>	getShortOpt(int idx) Returns a Short from column with a given index.
java.util.Optional<java.lang.Short>	getShortOpt(java.lang.String name) Returns a Short from column with a given name.
java.lang.String	getStr(int idx) Returns a String from column with a given index.
java.lang.String	getStr(java.lang.String name) Returns a String from column with a given name.
java.util.Optional<java.lang.String>	getStrOpt(int idx) Returns a String from column with a given index.
java.util.Optional<java.lang.String>	getStrOpt(java.lang.String name) Returns a String from column with a given name.
java.util.UUID	getUuid(int idx) Returns an UUID from column with a given index.
java.util.UUID	getUuid(java.lang.String name) Returns an UUID from column with a given name.
java.util.Optional<java.util.UUID>	getUuidOpt(int idx) Returns an UUID from column with a given index.
java.util.Optional<java.util.UUID>	getUuidOpt(java.lang.String name) Returns an UUID from column with a given name.

Method Detail

getCol

<T> T getCol(int idx,
             java.lang.Class<T> cls)
      throws ConversionException

Returns an object of type T from column with a given index.

For SQL NULL values, ConversionException is thrown. For null-safety consider using corresponding *Opt method.

Throws:

ConversionException

getColOpt

<T> java.util.Optional<T> getColOpt(int idx,
                                    java.lang.Class<T> cls)
                             throws ConversionException

Returns an object of type T from column with a given index.

For SQL NULL values an empty Optional is returned.

Throws:

ConversionException

getCol

<T> T getCol(java.lang.String name,
             java.lang.Class<T> cls)
      throws ConversionException

Returns an object of type T from column with a given name.

For SQL NULL values, ConversionException is thrown. For null-safety consider using corresponding *Opt method.

Throws:

ConversionException

getColOpt

<T> java.util.Optional<T> getColOpt(java.lang.String name,
                                    java.lang.Class<T> cls)
                             throws ConversionException

Returns an object of type T from column with a given name.

For SQL NULL values an empty Optional is returned.

Throws:

ConversionException

getStr

java.lang.String getStr(java.lang.String name)
                 throws ConversionException

Returns a String from column with a given name.

For SQL NULL values, ConversionException is thrown. For null-safety consider using corresponding *Opt method.

Throws:

ConversionException

getStrOpt

java.util.Optional<java.lang.String> getStrOpt(java.lang.String name)
                                        throws ConversionException

Returns a String from column with a given name.

For SQL NULL values an empty Optional is returned.

Throws:

ConversionException

getStr

java.lang.String getStr(int idx)
                 throws ConversionException

Returns a String from column with a given index.

For SQL NULL values, ConversionException is thrown. For null-safety consider using corresponding *Opt method.

Throws:

ConversionException

getStrOpt

java.util.Optional<java.lang.String> getStrOpt(int idx)
                                        throws ConversionException

Returns a String from column with a given index.

For SQL NULL values an empty Optional is returned.

Throws:

ConversionException

getBool

java.lang.Boolean getBool(java.lang.String name)
                   throws ConversionException

Returns a boolean value from column with a given name.

• A single 'T', 'Y' or '1' character values or 1 numeric value are considered true.
• A single 'F', 'N' or '0' character values or 0 numeric value are considered false.

For SQL NULL values, ConversionException is thrown. For null-safety consider using corresponding *Opt method.

Throws:

ConversionException

getBoolOpt

java.util.Optional<java.lang.Boolean> getBoolOpt(java.lang.String name)
                                          throws ConversionException

Returns a boolean value from column with a given name.

• A single 'T', 'Y' or '1' character values or 1 numeric value are considered true.
• A single 'F', 'N' or '0' character values or 0 numeric value are considered false.

For SQL NULL values an empty Optional is returned.

Throws:

ConversionException

getBool

java.lang.Boolean getBool(int idx)
                   throws ConversionException

Returns a boolean value from column with a given index.

• A single 'T', 'Y' or '1' character values or 1 numeric value are considered true.
• A single 'F', 'N' or '0' character values or 0 numeric value are considered false.

For SQL NULL values, ConversionException is thrown. For null-safety consider using corresponding *Opt method.

Throws:

ConversionException

getBoolOpt

java.util.Optional<java.lang.Boolean> getBoolOpt(int idx)
                                          throws ConversionException

Returns a boolean value from column with a given index.

• A single 'T', 'Y' or '1' character values or 1 numeric value are considered true.
• A single 'F', 'N' or '0' character values or 0 numeric value are considered false.

For SQL NULL values an empty Optional is returned.

Throws:

ConversionException

getChar

java.lang.Character getChar(java.lang.String name)
                     throws ConversionException

Returns a character from column with a given name.

Varchar types with a single character are convertible to a Char.

For SQL NULL values, ConversionException is thrown. For null-safety consider using corresponding *Opt method.

Throws:

ConversionException

getCharOpt

java.util.Optional<java.lang.Character> getCharOpt(java.lang.String name)
                                            throws ConversionException

Returns a character from column with a given name.

Varchar types with a single character are convertible to a Char.

For SQL NULL values an empty Optional is returned.

Throws:

ConversionException

getChar

java.lang.Character getChar(int idx)
                     throws ConversionException

Returns a character from column with a given index.

Varchar types with a single character are convertible to a Char.

For SQL NULL values, ConversionException is thrown. For null-safety consider using corresponding *Opt method.

Throws:

ConversionException

getCharOpt

java.util.Optional<java.lang.Character> getCharOpt(int idx)
                                            throws ConversionException

Returns a character from column with a given index.

Varchar types with a single character are convertible to a Char.

For SQL NULL values an empty Optional is returned.

Throws:

ConversionException

getShort

java.lang.Short getShort(java.lang.String name)
                  throws ConversionException

Returns a Short from column with a given name.

All numeric types can be converted to Short, but some conversions may involve rounding or truncation.

For SQL NULL values, ConversionException is thrown. For null-safety consider using corresponding *Opt method.

Throws:

ConversionException

getShortOpt

java.util.Optional<java.lang.Short> getShortOpt(java.lang.String name)
                                         throws ConversionException

Returns a Short from column with a given name.

All numeric types can be converted to Short, but some conversions may involve rounding or truncation.

For SQL NULL values an empty Optional is returned.

Throws:

ConversionException

getShort

java.lang.Short getShort(int idx)
                  throws ConversionException

Returns a Short from column with a given index.

All numeric types can be converted to Short, but some conversions may involve rounding or truncation.

For SQL NULL values, ConversionException is thrown. For null-safety consider using corresponding *Opt method.

Throws:

ConversionException

getShortOpt

java.util.Optional<java.lang.Short> getShortOpt(int idx)
                                         throws ConversionException

Returns a Short from column with a given index.

All numeric types can be converted to Short, but some conversions may involve rounding or truncation.

For SQL NULL values an empty Optional is returned.

Throws:

ConversionException

getInt

java.lang.Integer getInt(java.lang.String name)
                  throws ConversionException

Returns an int from column with a given name.

All numeric types can be converted to int, but some conversions may involve rounding or truncation.

For SQL NULL values, ConversionException is thrown. For null-safety consider using corresponding *Opt method.

Throws:

ConversionException

getIntOpt

java.util.Optional<java.lang.Integer> getIntOpt(java.lang.String name)
                                         throws ConversionException

Returns an int from column with a given name.

All numeric types can be converted to int, but some conversions may involve rounding or truncation.

For SQL NULL values an empty Optional is returned.

Throws:

ConversionException

getInt

java.lang.Integer getInt(int idx)
                  throws ConversionException

Returns an int from column with a given index.

All numeric types can be converted to int, but some conversions may involve rounding or truncation.

For SQL NULL values an empty Optional is returned.

Throws:

ConversionException

getIntOpt

java.util.Optional<java.lang.Integer> getIntOpt(int idx)
                                         throws ConversionException

Returns an int from column with a given index.

All numeric types can be converted to int, but some conversions may involve rounding or truncation.

For SQL NULL values an empty Optional is returned.

Throws:

ConversionException

getLong

java.lang.Long getLong(java.lang.String name)
                throws ConversionException

Returns a Long from column with a given name.

All numeric types can be converted to Long, but some conversions may involve rounding or truncation.

For SQL NULL values, ConversionException is thrown. For null-safety consider using corresponding *Opt method.

Throws:

ConversionException

getLongOpt

java.util.Optional<java.lang.Long> getLongOpt(java.lang.String name)
                                       throws ConversionException

Returns a Long from column with a given name.

All numeric types can be converted to Long, but some conversions may involve rounding or truncation.

For SQL NULL values an empty Optional is returned.

Throws:

ConversionException

getLong

java.lang.Long getLong(int idx)
                throws ConversionException

Returns a Long from column with a given index.

All numeric types can be converted to Long, but some conversions may involve rounding or truncation.

For SQL NULL values, ConversionException is thrown. For null-safety consider using corresponding *Opt method.

Throws:

ConversionException

getLongOpt

java.util.Optional<java.lang.Long> getLongOpt(int idx)
                                       throws ConversionException

Returns a Long from column with a given index.

All numeric types can be converted to Long, but some conversions may involve rounding or truncation.

For SQL NULL values an empty Optional is returned.

Throws:

ConversionException

getBigDecimal

java.math.BigDecimal getBigDecimal(java.lang.String name)
                            throws ConversionException

Returns a BigDecimal from column with a given name.

All numeric types can be converted to BigDecimal, note however that NaN value is not representable by a BigDecimal. If you expect values to be NaN use numeric method instead.

For SQL NULL values, ConversionException is thrown. For null-safety consider using corresponding *Opt method.

Throws:

ConversionException

getBigDecimalOpt

java.util.Optional<java.math.BigDecimal> getBigDecimalOpt(java.lang.String name)
                                                   throws ConversionException

Returns a BigDecimal from column with a given name.

All numeric types can be converted to BigDecimal, note however that NaN value is not representable by a BigDecimal. If you expect values to be NaN use numeric method instead.

For SQL NULL values an empty Optional is returned.

Throws:

ConversionException

getBigDecimal

java.math.BigDecimal getBigDecimal(int idx)
                            throws ConversionException

Returns a BigDecimal from column with a given index.

All numeric types can be converted to BigDecimal, note however that NaN value is not representable by a BigDecimal. If you expect values to be NaN use numeric method instead.

For SQL NULL values, ConversionException is thrown. For null-safety consider using corresponding *Opt method.

Throws:

ConversionException

getBigDecimalOpt

java.util.Optional<java.math.BigDecimal> getBigDecimalOpt(int idx)
                                                   throws ConversionException

Returns a BigDecimal from column with a given index.

All numeric types can be converted to BigDecimal, note however that NaN value is not representable by a BigDecimal. If you expect values to be NaN use numeric method instead.

For SQL NULL values an empty Optional is returned.

Throws:

ConversionException

getNumeric

SqlNumeric getNumeric(java.lang.String name)
               throws ConversionException

Returns a SqlNumeric from column with a given name.

All numeric types can be converted to SqlNumeric.

For SQL NULL values, ConversionException is thrown. For null-safety consider using corresponding *Opt method.

Throws:

ConversionException

getNumericOpt

java.util.Optional<SqlNumeric> getNumericOpt(java.lang.String name)
                                      throws ConversionException

Returns a SqlNumeric from column with a given name.

All numeric types can be converted to SqlNumeric.

For SQL NULL values an empty Optional is returned.

Throws:

ConversionException

getNumeric

SqlNumeric getNumeric(int idx)
               throws ConversionException

Returns a SqlNumeric from column with a given index.

All numeric types can be converted to SqlNumeric.

For SQL NULL values, ConversionException is thrown. For null-safety consider using corresponding *Opt method.

Throws:

ConversionException

getNumericOpt

java.util.Optional<SqlNumeric> getNumericOpt(int idx)
                                      throws ConversionException

Returns a SqlNumeric from column with a given index.

All numeric types can be converted to SqlNumeric.

For SQL NULL values an empty Optional is returned.

Throws:

ConversionException

getDouble

java.lang.Double getDouble(java.lang.String name)
                    throws ConversionException

Returns a Double from column with a given name.

All numeric types can be converted to Double, but some conversions may involve rounding or truncation.

For SQL NULL values, ConversionException is thrown. For null-safety consider using corresponding *Opt method.

Throws:

ConversionException

getDoubleOpt

java.util.Optional<java.lang.Double> getDoubleOpt(java.lang.String name)
                                           throws ConversionException

Returns a Double from column with a given name.

All numeric types can be converted to Double, but some conversions may involve rounding or truncation.

For SQL NULL values an empty Optional is returned.

Throws:

ConversionException

getDouble

java.lang.Double getDouble(int idx)
                    throws ConversionException

Returns a Double from column with a given index.

All numeric types can be converted to Double, but some conversions may involve rounding or truncation.

For SQL NULL values, ConversionException is thrown. For null-safety consider using corresponding *Opt method.

Throws:

ConversionException

getDoubleOpt

java.util.Optional<java.lang.Double> getDoubleOpt(int idx)
                                           throws ConversionException

Returns a Double from column with a given index.

All numeric types can be converted to Double, but some conversions may involve rounding or truncation.

For SQL NULL values an empty Optional is returned.

Throws:

ConversionException

getFloat

java.lang.Float getFloat(java.lang.String name)
                  throws ConversionException

Returns a Float from column with a given name.

All numeric types can be converted to Float, but some conversions may involve rounding or truncation.

For SQL NULL values, ConversionException is thrown. For null-safety consider using corresponding *Opt method.

Throws:

ConversionException

getFloatOpt

java.util.Optional<java.lang.Float> getFloatOpt(java.lang.String name)
                                         throws ConversionException

Returns a Float from column with a given name.

All numeric types can be converted to Float, but some conversions may involve rounding or truncation.

For SQL NULL values an empty Optional is returned.

Throws:

ConversionException

getFloat

java.lang.Float getFloat(int idx)
                  throws ConversionException

Returns a Float from column with a given index.

All numeric types can be converted to Float, but some conversions may involve rounding or truncation.

For SQL NULL values, ConversionException is thrown. For null-safety consider using corresponding *Opt method.

Throws:

ConversionException

getFloatOpt

java.util.Optional<java.lang.Float> getFloatOpt(int idx)
                                         throws ConversionException

Returns a Float from column with a given index.

All numeric types can be converted to Float, but some conversions may involve rounding or truncation.

For SQL NULL values an empty Optional is returned.

Throws:

ConversionException

getInstant

java.time.Instant getInstant(java.lang.String name)
                      throws ConversionException

Returns an Instant from column with a given name.

Note that regular timestamp values are not convertible to an Instant because timestamp values do not hold a time zone information.

For SQL NULL values, ConversionException is thrown. For null-safety consider using corresponding *Opt method.

Throws:

ConversionException

getInstantOpt

java.util.Optional<java.time.Instant> getInstantOpt(java.lang.String name)
                                             throws ConversionException

Returns an Instant from column with a given name.

Note that regular timestamp values are not convertible to an Instant because timestamp values do not hold a time zone information.

For SQL NULL values an empty Optional is returned.

Throws:

ConversionException

getInstant

java.time.Instant getInstant(int idx)
                      throws ConversionException

Returns an Instant from column with a given index.

Note that regular timestamp values are not convertible to an Instant because timestamp values do not hold a time zone information.

For SQL NULL values, ConversionException is thrown. For null-safety consider using corresponding *Opt method.

Throws:

ConversionException

getInstantOpt

java.util.Optional<java.time.Instant> getInstantOpt(int idx)
                                             throws ConversionException

Returns an Instant from column with a given index.

Note that regular timestamp values are not convertible to an Instant because timestamp values do not hold a time zone information.

For SQL NULL values an empty Optional is returned.

Throws:

ConversionException

getLocalDateTime

java.time.LocalDateTime getLocalDateTime(java.lang.String name)
                                  throws ConversionException

Returns a LocalDateTime from column with a given name.

For SQL date type that does not hold a time, LocalDateTime at start of day is returned.

For SQL NULL values, ConversionException is thrown. For null-safety consider using corresponding *Opt method.

Throws:

ConversionException

getLocalDateTimeOpt

java.util.Optional<java.time.LocalDateTime> getLocalDateTimeOpt(java.lang.String name)
                                                         throws ConversionException

Returns a LocalDateTime from column with a given name.

For SQL date type that does not hold a time, LocalDateTime at start of day is returned.

For SQL NULL values an empty Optional is returned.

Throws:

ConversionException

getLocalDateTime

java.time.LocalDateTime getLocalDateTime(int idx)
                                  throws ConversionException

Returns a LocalDateTime from column with a given index.

For SQL date type that does not hold a time, LocalDateTime at start of day is returned.

For SQL NULL values, ConversionException is thrown. For null-safety consider using corresponding *Opt method.

Throws:

ConversionException

getLocalDateTimeOpt

java.util.Optional<java.time.LocalDateTime> getLocalDateTimeOpt(int idx)
                                                         throws ConversionException

Returns a LocalDateTime from column with a given index.

For SQL date type that does not hold a time, LocalDateTime at start of day is returned.

For SQL NULL values an empty Optional is returned.

Throws:

ConversionException

getLocalDate

java.time.LocalDate getLocalDate(java.lang.String name)
                          throws ConversionException

Returns a LocalDate from column with a given name.

SQL types that represent a date with a time are convertible to LocalDate - a time part is truncated.

For SQL NULL values, ConversionException is thrown. For null-safety consider using corresponding *Opt method.

Throws:

ConversionException

getLocalDateOpt

java.util.Optional<java.time.LocalDate> getLocalDateOpt(java.lang.String name)
                                                 throws ConversionException

Returns a LocalDate from column with a given name.

SQL types that represent a date with a time are convertible to LocalDate - a time part is truncated.

For SQL NULL values an empty Optional is returned.

Throws:

ConversionException

getLocalDate

java.time.LocalDate getLocalDate(int idx)
                          throws ConversionException

Returns a LocalDate from column with a given index.

SQL types that represent a date with a time are convertible to LocalDate - a time part is truncated.

For SQL NULL values, ConversionException is thrown. For null-safety consider using corresponding *Opt method.

Throws:

ConversionException

getLocalDateOpt

java.util.Optional<java.time.LocalDate> getLocalDateOpt(int idx)
                                                 throws ConversionException

Returns a LocalDate from column with a given index.

SQL types that represent a date with a time are convertible to LocalDate - a time part is truncated.

For SQL NULL values an empty Optional is returned.

Throws:

ConversionException

getLocalTime

java.time.LocalTime getLocalTime(java.lang.String name)
                          throws ConversionException

Returns a LocalDate from column with a given name.

SQL types that represent a date with a time are convertible to LocalTime - a date part is truncated.

For SQL NULL values, ConversionException is thrown. For null-safety consider using corresponding *Opt method.

Throws:

ConversionException

getLocalTimeOpt

java.util.Optional<java.time.LocalTime> getLocalTimeOpt(java.lang.String name)
                                                 throws ConversionException

Returns a LocalDate from column with a given name.

SQL types that represent a date with a time are convertible to LocalTime - a date part is truncated.

For SQL NULL values an empty Optional is returned.

Throws:

ConversionException

getLocalTime

java.time.LocalTime getLocalTime(int idx)
                          throws ConversionException

Returns a LocalDate from column with a given index.

SQL types that represent a date with a time are convertible to LocalTime - a date part is truncated.

For SQL NULL values, ConversionException is thrown. For null-safety consider using corresponding *Opt method.

Throws:

ConversionException

getLocalTimeOpt

java.util.Optional<java.time.LocalTime> getLocalTimeOpt(int idx)
                                                 throws ConversionException

Returns a LocalDate from column with a given index.

SQL types that represent a date with a time are convertible to LocalTime - a date part is truncated.

For SQL NULL values an empty Optional is returned.

Throws:

ConversionException

getBytes

byte[] getBytes(java.lang.String name)
         throws ConversionException

Returns a byte array from column with a given name.

Note that this method cannot be used to fetch raw value of any type from the database, it should be used only to fetch binary data.

For SQL NULL values, ConversionException is thrown. For null-safety consider using corresponding *Opt method.

Throws:

ConversionException

getBytesOpt

java.util.Optional<byte[]> getBytesOpt(java.lang.String name)
                                throws ConversionException

Returns a byte array from column with a given name.

Note that this method cannot be used to fetch raw value of any type from the database, it should be used only to fetch binary data.

For SQL NULL values an empty Optional is returned.

Throws:

ConversionException

getBytes

byte[] getBytes(int idx)
         throws ConversionException

Returns a byte array from column with a given index.

Note that this method cannot be used to fetch raw value of any type from the database, it should be used only to fetch binary data.

For SQL NULL values, ConversionException is thrown. For null-safety consider using corresponding *Opt method.

Throws:

ConversionException

getBytesOpt

java.util.Optional<byte[]> getBytesOpt(int idx)
                                throws ConversionException

Returns a byte array from column with a given index.

Note that this method cannot be used to fetch raw value of any type from the database, it should be used only to fetch binary data.

For SQL NULL values an empty Optional is returned.

Throws:

ConversionException

getUuid

java.util.UUID getUuid(java.lang.String name)
                throws ConversionException

Returns an UUID from column with a given name.

A string type with a standard UUID representation as defined by UUID.fromString is convertible to UUID.

For SQL NULL values, ConversionException is thrown. For null-safety consider using corresponding *Opt method.

Throws:

ConversionException

getUuidOpt

java.util.Optional<java.util.UUID> getUuidOpt(java.lang.String name)
                                       throws ConversionException

Returns an UUID from column with a given name.

A string type with a standard UUID representation as defined by UUID.fromString is convertible to UUID.

For SQL NULL values an empty Optional is returned.

Throws:

ConversionException

getUuid

java.util.UUID getUuid(int idx)
                throws ConversionException

Returns an UUID from column with a given index.

A string type with a standard UUID representation as defined by UUID.fromString is convertible to UUID.

For SQL NULL values, ConversionException is thrown. For null-safety consider using corresponding *Opt method.

Throws:

ConversionException

getUuidOpt

java.util.Optional<java.util.UUID> getUuidOpt(int idx)
                                       throws ConversionException

Returns an UUID from column with a given index.

A string type with a standard UUID representation as defined by UUID.fromString is convertible to UUID.

For SQL NULL values an empty Optional is returned.

Throws:

ConversionException