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 numeric
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 numeric
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 numeric
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 numeric
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 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.
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:
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.
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 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 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 SqlNumeric from column with a given index.
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:
Returns a SqlNumeric from column with a given name.
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:
Returns a SqlNumeric from column with a given index.
Returns a SqlNumeric from column with a given index.
All numeric types can be converted to SqlNumeric.
For SQL null
values None is returned.
Throws:
Returns a SqlNumeric from column with a given name.
Returns a SqlNumeric from column with a given name.
All numeric types can be converted to SqlNumeric.
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:
[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.