Returns a BigDecimal from column with a given index.
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 decimal
method instead.
For SQL null
values, ConversionException is thrown.
For null-safety consider using corresponding *Opt
method.
Throws:
Returns a BigDecimal from column with a given name.
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 decimal
method instead.
For SQL null
values, ConversionException is thrown.
For null-safety consider using corresponding *Opt
method.
Throws:
Returns a BigDecimal from column with a given index.
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 decimal
method instead.
For SQL null
values None is returned.
Throws:
Returns a BigDecimal from column with a given name.
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 decimal
method instead.
For SQL null
values None is returned.
Throws:
Returns a boolean value from column with a given index.
Returns a boolean value from column with a given index.
1
numeric value are
considered true
.0
numeric value are
considered false
. For SQL null
values, ConversionException is thrown.
For null-safety consider using corresponding *Opt
method.
Throws:
Returns a boolean value from column with a given name.
Returns a boolean value from column with a given name.
1
numeric value are
considered true
.0
numeric value are
considered false
. For SQL null
values, ConversionException is thrown.
For null-safety consider using corresponding *Opt
method.
Throws:
Returns a boolean value from column with a given index.
Returns a boolean value from column with a given index.
1
numeric value are
considered true
.0
numeric value are
considered false
. For SQL null
values None is returned.
Throws:
Returns a boolean value from column with a given name.
Returns a boolean value from column with a given name.
1
numeric value are
considered true
.0
numeric value are
considered false
. For SQL null
values None is returned.
Throws:
Returns a byte array from column with a given index.
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:
Returns a byte array from column with a given name.
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:
Returns a byte array from column with a given index.
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 None is returned.
Throws:
Returns a byte array from column with a given name.
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 None is returned.
Throws:
Returns a character from column with a given index.
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:
Returns a character from column with a given name.
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:
Returns a character from column with a given index.
Returns a character from column with a given index.
Varchar types with a single character are convertible to a Char
.
For SQL null
values None is returned.
Throws:
Returns a character from column with a given name.
Returns a character from column with a given name.
Varchar types with a single character are convertible to a Char
.
For SQL null
values None is returned.
Throws:
Returns a DecimalNumber from column with a given index.
Returns a DecimalNumber from column with a given index.
For SQL null
values, ConversionException is thrown.
For null-safety consider using corresponding *Opt
method.
Throws:
Returns a DecimalNumber from column with a given name.
Returns a DecimalNumber from column with a given name.
For SQL null
values, ConversionException is thrown.
For null-safety consider using corresponding *Opt
method.
Throws:
Returns a DecimalNumber from column with a given index.
Returns a DecimalNumber from column with a given index.
For SQL null
values None is returned.
Throws:
Returns a DecimalNumber from column with a given name.
Returns a DecimalNumber from column with a given name.
For SQL null
values None is returned.
Throws:
Returns a Double
from column with a given index.
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:
Returns a Double
from column with a given name.
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:
Returns a Double
from column with a given index.
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 None is returned.
Throws:
Returns a Double
from column with a given name.
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 None is returned.
Throws:
Returns a Float
from column with a given index.
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:
Returns a Float
from column with a given name.
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:
Returns a Float
from column with a given index.
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 None is returned.
Throws:
Returns a Float
from column with a given name.
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 None is returned.
Throws:
Returns an Instant
from column with a given index, assuming
that the TIMESTAMP value stored in the database is in the provided time
zone.
Returns an Instant
from column with a given index, assuming
that the TIMESTAMP value stored in the database is in the provided time
zone.
The zoneId
parameter is ignored in case the driver can create an instant
from the stored value without an user-provided time zone. This can happen
if the database stores TIMESTAMP values as instants or for columns with
TIMESTAMP WITH TIME ZONE types.
For SQL null
values, ConversionException is thrown.
For null-safety consider using corresponding *Opt
method.
Throws:
Returns an Instant
from column with a given name, assuming
that the TIMESTAMP value stored in the database is in the provided time
zone.
Returns an Instant
from column with a given name, assuming
that the TIMESTAMP value stored in the database is in the provided time
zone.
The zoneId
parameter is ignored in case the driver can create an instant
from the stored value without an user-provided time zone. This can happen
if the database stores TIMESTAMP values as instants or for columns with
TIMESTAMP WITH TIME ZONE types.
For SQL null
values, ConversionException is thrown.
For null-safety consider using corresponding *Opt
method.
Throws:
Returns an Instant
from column with a given index.
Returns an Instant
from column with a given index.
Note that standard SQL TIMESTAMP values are not convertible to an Instant
because they do not hold a time zone information.
For SQL null
values, ConversionException is thrown.
For null-safety consider using corresponding *Opt
method.
Throws:
Returns an Instant
from column with a given name.
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:
Returns an Instant
from column with a given index, assuming
that the TIMESTAMP value stored in the database is in the provided time
zone.
Returns an Instant
from column with a given index, assuming
that the TIMESTAMP value stored in the database is in the provided time
zone.
The zoneId
parameter is ignored in case the driver can create an instant
from the stored value without an user-provided time zone. This can happen
if the database stores TIMESTAMP values as instants or for columns with
TIMESTAMP WITH TIME ZONE types.
For SQL null
values None is returned.
Throws:
Returns an Instant
from column with a given name, assuming
that the TIMESTAMP value stored in the database is in the provided time
zone.
Returns an Instant
from column with a given name, assuming
that the TIMESTAMP value stored in the database is in the provided time
zone.
The zoneId
parameter is ignored in case the driver can create an instant
from the stored value without an user-provided time zone. This can happen
if the database stores TIMESTAMP values as instants or for columns with
TIMESTAMP WITH TIME ZONE types.
For SQL null
values None is returned.
Throws:
Returns an Instant
from column with a given index.
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 None is returned.
Throws:
Returns an Instant
from column with a given name.
Returns an Instant
from column with a given name.
Note that standard SQL TIMESTAMP values are not convertible to an Instant
because they do not hold a time zone information.
For SQL null
values None is returned.
Throws:
Returns an Int
from column with a given index.
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 None is returned.
Throws:
Returns an Int
from column with a given name.
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:
Returns an Int
from column with a given index.
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 None is returned.
Throws:
Returns an Int
from column with a given name.
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 None is returned.
Throws:
Returns a LocalDate
from column with a given index.
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:
Returns a LocalDate
from column with a given name.
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:
Returns a LocalDate
from column with a given index.
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 None is returned.
Throws:
Returns a LocalDate
from column with a given name.
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 None is returned.
Throws:
Returns a LocalDateTime
from column with a given index.
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:
Returns a LocalDateTime
from column with a given name.
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:
Returns a LocalDateTime
from column with a given index.
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 None is returned.
Throws:
Returns a LocalDateTime
from column with a given name.
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 None is returned.
Throws:
Returns a LocalDate
from column with a given index.
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:
Returns a LocalDate
from column with a given name.
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:
Returns a LocalDate
from column with a given index.
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 None is returned.
Throws:
Returns a LocalDate
from column with a given name.
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 None is returned.
Throws:
Returns a Long
from column with a given index.
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:
Returns a Long
from column with a given name.
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:
Returns a Long
from column with a given index.
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 None is returned.
Throws:
Returns a Long
from column with a given name.
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 None is returned.
Throws:
Returns a Short
from column with a given index.
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:
Returns a Short
from column with a given name.
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:
Returns a Short
from column with a given index.
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 None is returned.
Throws:
Returns a Short
from column with a given name.
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 None is returned.
Throws:
Returns a String
from column with a given index.
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:
Returns a String
from column with a given name.
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:
Returns a String
from column with a given index.
Returns a String
from column with a given index.
For SQL null
values None is returned.
Throws:
Returns a String
from column with a given name.
Returns a String
from column with a given name.
For SQL null
values None is returned.
Throws:
Returns an UUID
from column with a given index.
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:
Returns an UUID
from column with a given name.
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:
Returns an UUID
from column with a given index.
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 None is returned.
Throws:
Returns an UUID
from column with a given name.
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 None is returned.
Throws:
Returns a ZonedDateTime
from column with a given index.
Returns a ZonedDateTime
from column with a given index.
For SQL null
values, ConversionException is thrown.
For null-safety consider using corresponding *Opt
method.
Throws:
Returns a ZonedDateTime
from column with a given name.
Returns a ZonedDateTime
from column with a given name.
For SQL null
values, ConversionException is thrown.
For null-safety consider using corresponding *Opt
method.
Throws:
Returns a ZonedDateTime
from column with a given index.
Returns a ZonedDateTime
from column with a given index.
For SQL null
values None is returned.
Throws:
Returns a ZonedDateTime
from column with a given name.
Returns a ZonedDateTime
from column with a given name.
For SQL null
values None is returned.
Throws:
[use case] Returns an object of type A
from column with a given name.
Returns an object of type A
from column with a given name.
For SQL null
values, ConversionException is thrown.
For null-safety consider using corresponding *Opt
method.
Throws:
[use case] Returns an object of type A
from column with a given index.
Returns an object of type A
from column with a given index.
For SQL null
values, ConversionException is thrown.
For null-safety consider using corresponding *Opt
method.
Throws:
[use case] Returns an object of type A
from column with a given name.
Returns an object of type A
from column with a given name.
For SQL null
values None is returned.
Throws:
[use case] Returns an object of type A
from column with a given index.
Returns an object of type A
from column with a given index.
For SQL null
values None is returned.
Throws:
Methods in this group can be used for fetching values of types not supported by rdbc API out of the box.
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 Option to allow null-safe handling of SQL
null
values.