Package com.tsurugidb.iceaxe.sql.result

Interface TsurugiResultNameRecord

  • All Known Implementing Classes:
    TsurugiResultRecord
    public interface TsurugiResultNameRecord
    Tsurugi Result Record for name access.
    Since:
    1.5.0

    • Method Summary

      All Methods Instance Methods Abstract Methods Default Methods 
      Modifier and Type Method Description
      default java.util.Optional<boolean[]> findBits​(java.lang.String name)
      This method is not yet implemented: get value as boolean[].
      default java.util.Optional<TgBlobReference> findBlob​(java.lang.String name)
      get value as BLOB.
      default java.util.Optional<java.lang.Boolean> findBoolean​(java.lang.String name)
      get value as boolean.
      default java.util.Optional<byte[]> findBytes​(java.lang.String name)
      get value as byte[].
      default java.util.Optional<TgClobReference> findClob​(java.lang.String name)
      get value as CLOB.
      default java.util.Optional<java.time.LocalDate> findDate​(java.lang.String name)
      get value as date.
      default java.util.Optional<java.time.LocalDateTime> findDateTime​(java.lang.String name)
      get value as dateTime.
      default java.util.Optional<java.math.BigDecimal> findDecimal​(java.lang.String name)
      get value as decimal.
      default java.util.Optional<java.lang.Double> findDouble​(java.lang.String name)
      get value as double.
      default java.util.Optional<java.lang.Float> findFloat​(java.lang.String name)
      get value as float.
      default java.util.Optional<java.lang.Integer> findInt​(java.lang.String name)
      get value as int.
      default java.util.Optional<java.lang.Long> findLong​(java.lang.String name)
      get value as long.
      default java.util.Optional<java.time.OffsetDateTime> findOffsetDateTime​(java.lang.String name)
      get value as offset dateTime.
      default java.util.Optional<java.time.OffsetTime> findOffsetTime​(java.lang.String name)
      get value as offset time.
      default java.util.Optional<java.lang.String> findString​(java.lang.String name)
      get value as string.
      default java.util.Optional<java.time.LocalTime> findTime​(java.lang.String name)
      get value as time.
      default java.util.Optional<java.time.ZonedDateTime> findZonedDateTime​(java.lang.String name, java.time.ZoneId zone)
      get value as zoned dateTime.
      default boolean[] getBits​(java.lang.String name)
      This method is not yet implemented: get value as boolean[].
      default boolean[] getBits​(java.lang.String name, boolean[] defaultValue)
      This method is not yet implemented: get value as boolean[].
      default boolean[] getBitsOrNull​(java.lang.String name)
      This method is not yet implemented: get value as boolean[].
      default TgBlobReference getBlob​(java.lang.String name)
      get value as BLOB.
      default TgBlobReference getBlob​(java.lang.String name, TgBlobReference defaultValue)
      get value as BLOB.
      default TgBlobReference getBlobOrNull​(java.lang.String name)
      get value as BLOB.
      default boolean getBoolean​(java.lang.String name)
      get value as boolean.
      default boolean getBoolean​(java.lang.String name, boolean defaultValue)
      get value as boolean.
      default java.lang.Boolean getBooleanOrNull​(java.lang.String name)
      get value as boolean.
      default byte[] getBytes​(java.lang.String name)
      get value as byte[].
      default byte[] getBytes​(java.lang.String name, byte[] defaultValue)
      get value as byte[].
      default byte[] getBytesOrNull​(java.lang.String name)
      get value as byte[].
      default TgClobReference getClob​(java.lang.String name)
      get value as CLOB.
      default TgClobReference getClob​(java.lang.String name, TgClobReference defaultValue)
      get value as CLOB.
      default TgClobReference getClobOrNull​(java.lang.String name)
      get value as CLOB.
      IceaxeConvertUtil getConvertUtil()
      get convert utility.
      default java.time.LocalDate getDate​(java.lang.String name)
      get value as date.
      default java.time.LocalDate getDate​(java.lang.String name, java.time.LocalDate defaultValue)
      get value as date.
      default java.time.LocalDate getDateOrNull​(java.lang.String name)
      get value as date.
      default java.time.LocalDateTime getDateTime​(java.lang.String name)
      get value as dateTime.
      default java.time.LocalDateTime getDateTime​(java.lang.String name, java.time.LocalDateTime defaultValue)
      get value as dateTime.
      default java.time.LocalDateTime getDateTimeOrNull​(java.lang.String name)
      get value as dateTime.
      default java.math.BigDecimal getDecimal​(java.lang.String name)
      get value as decimal.
      default java.math.BigDecimal getDecimal​(java.lang.String name, java.math.BigDecimal defaultValue)
      get value as decimal.
      default java.math.BigDecimal getDecimalOrNull​(java.lang.String name)
      get value as decimal.
      default double getDouble​(java.lang.String name)
      get value as double.
      default double getDouble​(java.lang.String name, double defaultValue)
      get value as double.
      default java.lang.Double getDoubleOrNull​(java.lang.String name)
      get value as double.
      default float getFloat​(java.lang.String name)
      get value as float.
      default float getFloat​(java.lang.String name, float defaultValue)
      get value as float.
      default java.lang.Float getFloatOrNull​(java.lang.String name)
      get value as float.
      default int getInt​(java.lang.String name)
      get value as int.
      default int getInt​(java.lang.String name, int defaultValue)
      get value as int.
      default java.lang.Integer getIntOrNull​(java.lang.String name)
      get value as int.
      default long getLong​(java.lang.String name)
      get value as long.
      default long getLong​(java.lang.String name, long defaultValue)
      get value as long.
      default java.lang.Long getLongOrNull​(java.lang.String name)
      get value as long.
      default java.time.OffsetDateTime getOffsetDateTime​(java.lang.String name)
      get value as offset dateTime.
      default java.time.OffsetDateTime getOffsetDateTime​(java.lang.String name, java.time.OffsetDateTime defaultValue)
      get value as offset dateTime.
      default java.time.OffsetDateTime getOffsetDateTimeOrNull​(java.lang.String name)
      get value as offset dateTime.
      default java.time.OffsetTime getOffsetTime​(java.lang.String name)
      get value as offset time.
      default java.time.OffsetTime getOffsetTime​(java.lang.String name, java.time.OffsetTime defaultValue)
      get value as offset time.
      default java.time.OffsetTime getOffsetTimeOrNull​(java.lang.String name)
      get value as offset time.
      default java.lang.String getString​(java.lang.String name)
      get value as string.
      default java.lang.String getString​(java.lang.String name, java.lang.String defaultValue)
      get value as string.
      default java.lang.String getStringOrNull​(java.lang.String name)
      get value as string.
      default java.time.LocalTime getTime​(java.lang.String name)
      get value as time.
      default java.time.LocalTime getTime​(java.lang.String name, java.time.LocalTime defaultValue)
      get value as time.
      default java.time.LocalTime getTimeOrNull​(java.lang.String name)
      get value as time.
      java.lang.Object getValueOrNull​(java.lang.String name)
      get value.
      default java.time.ZonedDateTime getZonedDateTime​(java.lang.String name, java.time.ZoneId zone)
      get value as zoned dateTime.
      default java.time.ZonedDateTime getZonedDateTime​(java.lang.String name, java.time.ZoneId zone, java.time.ZonedDateTime defaultValue)
      get value as zoned dateTime.
      default java.time.ZonedDateTime getZonedDateTimeOrNull​(java.lang.String name, java.time.ZoneId zone)
      get value as zoned dateTime.

    • Method Detail

      • getValueOrNull

        @Nullable
java.lang.Object getValueOrNull​(java.lang.String name)
                         throws java.io.IOException,
                                java.lang.InterruptedException,
                                TsurugiTransactionException
        get value.
        Parameters:
        name - column name
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data

      • getConvertUtil

        IceaxeConvertUtil getConvertUtil()
        get convert utility.
        Returns:
        convert utility

      • getBoolean

        default boolean getBoolean​(java.lang.String name)
                    throws java.io.IOException,
                           java.lang.InterruptedException,
                           TsurugiTransactionException
        get value as boolean.
        Parameters:
        name - column name
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data
        java.lang.NullPointerException - if value is null

      • getBoolean

        default boolean getBoolean​(java.lang.String name,
                           boolean defaultValue)
                    throws java.io.IOException,
                           java.lang.InterruptedException,
                           TsurugiTransactionException
        get value as boolean.
        Parameters:
        name - column name
        defaultValue - value to return if original value is null
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data

      • findBoolean

        @Nonnull
default java.util.Optional<java.lang.Boolean> findBoolean​(java.lang.String name)
                                                   throws java.io.IOException,
                                                          java.lang.InterruptedException,
                                                          TsurugiTransactionException
        get value as boolean.
        Parameters:
        name - column name
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data

      • getBooleanOrNull

        @Nullable
default java.lang.Boolean getBooleanOrNull​(java.lang.String name)
                                    throws java.io.IOException,
                                           java.lang.InterruptedException,
                                           TsurugiTransactionException
        get value as boolean.
        Parameters:
        name - column name
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data

      • getInt

        default int getInt​(java.lang.String name)
            throws java.io.IOException,
                   java.lang.InterruptedException,
                   TsurugiTransactionException
        get value as int.
        Parameters:
        name - column name
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data
        java.lang.NullPointerException - if value is null

      • getInt

        default int getInt​(java.lang.String name,
                   int defaultValue)
            throws java.io.IOException,
                   java.lang.InterruptedException,
                   TsurugiTransactionException
        get value as int.
        Parameters:
        name - column name
        defaultValue - value to return if original value is null
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data

      • findInt

        @Nonnull
default java.util.Optional<java.lang.Integer> findInt​(java.lang.String name)
                                               throws java.io.IOException,
                                                      java.lang.InterruptedException,
                                                      TsurugiTransactionException
        get value as int.
        Parameters:
        name - column name
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data

      • getIntOrNull

        @Nullable
default java.lang.Integer getIntOrNull​(java.lang.String name)
                                throws java.io.IOException,
                                       java.lang.InterruptedException,
                                       TsurugiTransactionException
        get value as int.
        Parameters:
        name - column name
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data

      • getLong

        default long getLong​(java.lang.String name)
              throws java.io.IOException,
                     java.lang.InterruptedException,
                     TsurugiTransactionException
        get value as long.
        Parameters:
        name - column name
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data
        java.lang.NullPointerException - if value is null

      • getLong

        default long getLong​(java.lang.String name,
                     long defaultValue)
              throws java.io.IOException,
                     java.lang.InterruptedException,
                     TsurugiTransactionException
        get value as long.
        Parameters:
        name - column name
        defaultValue - value to return if original value is null
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data

      • findLong

        @Nonnull
default java.util.Optional<java.lang.Long> findLong​(java.lang.String name)
                                             throws java.io.IOException,
                                                    java.lang.InterruptedException,
                                                    TsurugiTransactionException
        get value as long.
        Parameters:
        name - column name
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data

      • getLongOrNull

        @Nullable
default java.lang.Long getLongOrNull​(java.lang.String name)
                              throws java.io.IOException,
                                     java.lang.InterruptedException,
                                     TsurugiTransactionException
        get value as long.
        Parameters:
        name - column name
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data

      • getFloat

        default float getFloat​(java.lang.String name)
                throws java.io.IOException,
                       java.lang.InterruptedException,
                       TsurugiTransactionException
        get value as float.
        Parameters:
        name - column name
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data
        java.lang.NullPointerException - if value is null

      • getFloat

        default float getFloat​(java.lang.String name,
                       float defaultValue)
                throws java.io.IOException,
                       java.lang.InterruptedException,
                       TsurugiTransactionException
        get value as float.
        Parameters:
        name - column name
        defaultValue - value to return if original value is null
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data

      • findFloat

        @Nonnull
default java.util.Optional<java.lang.Float> findFloat​(java.lang.String name)
                                               throws java.io.IOException,
                                                      java.lang.InterruptedException,
                                                      TsurugiTransactionException
        get value as float.
        Parameters:
        name - column name
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data

      • getFloatOrNull

        @Nullable
default java.lang.Float getFloatOrNull​(java.lang.String name)
                                throws java.io.IOException,
                                       java.lang.InterruptedException,
                                       TsurugiTransactionException
        get value as float.
        Parameters:
        name - column name
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data

      • getDouble

        default double getDouble​(java.lang.String name)
                  throws java.io.IOException,
                         java.lang.InterruptedException,
                         TsurugiTransactionException
        get value as double.
        Parameters:
        name - column name
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data
        java.lang.NullPointerException - if value is null

      • getDouble

        default double getDouble​(java.lang.String name,
                         double defaultValue)
                  throws java.io.IOException,
                         java.lang.InterruptedException,
                         TsurugiTransactionException
        get value as double.
        Parameters:
        name - column name
        defaultValue - value to return if original value is null
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data

      • findDouble

        @Nonnull
default java.util.Optional<java.lang.Double> findDouble​(java.lang.String name)
                                                 throws java.io.IOException,
                                                        java.lang.InterruptedException,
                                                        TsurugiTransactionException
        get value as double.
        Parameters:
        name - column name
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data

      • getDoubleOrNull

        @Nullable
default java.lang.Double getDoubleOrNull​(java.lang.String name)
                                  throws java.io.IOException,
                                         java.lang.InterruptedException,
                                         TsurugiTransactionException
        get value as double.
        Parameters:
        name - column name
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data

      • getDecimal

        @Nonnull
default java.math.BigDecimal getDecimal​(java.lang.String name)
                                 throws java.io.IOException,
                                        java.lang.InterruptedException,
                                        TsurugiTransactionException
        get value as decimal.
        Parameters:
        name - column name
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data
        java.lang.NullPointerException - if value is null

      • getDecimal

        default java.math.BigDecimal getDecimal​(java.lang.String name,
                                        java.math.BigDecimal defaultValue)
                                 throws java.io.IOException,
                                        java.lang.InterruptedException,
                                        TsurugiTransactionException
        get value as decimal.
        Parameters:
        name - column name
        defaultValue - value to return if original value is null
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data

      • findDecimal

        @Nonnull
default java.util.Optional<java.math.BigDecimal> findDecimal​(java.lang.String name)
                                                      throws java.io.IOException,
                                                             java.lang.InterruptedException,
                                                             TsurugiTransactionException
        get value as decimal.
        Parameters:
        name - column name
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data

      • getDecimalOrNull

        @Nullable
default java.math.BigDecimal getDecimalOrNull​(java.lang.String name)
                                       throws java.io.IOException,
                                              java.lang.InterruptedException,
                                              TsurugiTransactionException
        get value as decimal.
        Parameters:
        name - column name
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data

      • getString

        @Nonnull
default java.lang.String getString​(java.lang.String name)
                            throws java.io.IOException,
                                   java.lang.InterruptedException,
                                   TsurugiTransactionException
        get value as string.
        Parameters:
        name - column name
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data
        java.lang.NullPointerException - if value is null

      • getString

        default java.lang.String getString​(java.lang.String name,
                                   java.lang.String defaultValue)
                            throws java.io.IOException,
                                   java.lang.InterruptedException,
                                   TsurugiTransactionException
        get value as string.
        Parameters:
        name - column name
        defaultValue - value to return if original value is null
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data

      • findString

        @Nonnull
default java.util.Optional<java.lang.String> findString​(java.lang.String name)
                                                 throws java.io.IOException,
                                                        java.lang.InterruptedException,
                                                        TsurugiTransactionException
        get value as string.
        Parameters:
        name - column name
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data

      • getStringOrNull

        @Nullable
default java.lang.String getStringOrNull​(java.lang.String name)
                                  throws java.io.IOException,
                                         java.lang.InterruptedException,
                                         TsurugiTransactionException
        get value as string.
        Parameters:
        name - column name
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data

      • getBytes

        @Nonnull
default byte[] getBytes​(java.lang.String name)
                 throws java.io.IOException,
                        java.lang.InterruptedException,
                        TsurugiTransactionException
        get value as byte[].
        Parameters:
        name - column name
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data
        java.lang.NullPointerException - if value is null

      • getBytes

        default byte[] getBytes​(java.lang.String name,
                        byte[] defaultValue)
                 throws java.io.IOException,
                        java.lang.InterruptedException,
                        TsurugiTransactionException
        get value as byte[].
        Parameters:
        name - column name
        defaultValue - value to return if original value is null
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data

      • findBytes

        @Nonnull
default java.util.Optional<byte[]> findBytes​(java.lang.String name)
                                      throws java.io.IOException,
                                             java.lang.InterruptedException,
                                             TsurugiTransactionException
        get value as byte[].
        Parameters:
        name - column name
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data

      • getBytesOrNull

        @Nullable
default byte[] getBytesOrNull​(java.lang.String name)
                       throws java.io.IOException,
                              java.lang.InterruptedException,
                              TsurugiTransactionException
        get value as byte[].
        Parameters:
        name - column name
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data

      • getBits

        @Nonnull
default boolean[] getBits​(java.lang.String name)
                   throws java.io.IOException,
                          java.lang.InterruptedException,
                          TsurugiTransactionException
        This method is not yet implemented: get value as boolean[].
        Parameters:
        name - column name
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data
        java.lang.NullPointerException - if value is null

      • getBits

        default boolean[] getBits​(java.lang.String name,
                          boolean[] defaultValue)
                   throws java.io.IOException,
                          java.lang.InterruptedException,
                          TsurugiTransactionException
        This method is not yet implemented: get value as boolean[].
        Parameters:
        name - column name
        defaultValue - value to return if original value is null
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data

      • findBits

        @Nonnull
default java.util.Optional<boolean[]> findBits​(java.lang.String name)
                                        throws java.io.IOException,
                                               java.lang.InterruptedException,
                                               TsurugiTransactionException
        This method is not yet implemented: get value as boolean[].
        Parameters:
        name - column name
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data

      • getBitsOrNull

        @Nullable
default boolean[] getBitsOrNull​(java.lang.String name)
                         throws java.io.IOException,
                                java.lang.InterruptedException,
                                TsurugiTransactionException
        This method is not yet implemented: get value as boolean[].
        Parameters:
        name - column name
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data

      • getDate

        @Nonnull
default java.time.LocalDate getDate​(java.lang.String name)
                             throws java.io.IOException,
                                    java.lang.InterruptedException,
                                    TsurugiTransactionException
        get value as date.
        Parameters:
        name - column name
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data
        java.lang.NullPointerException - if value is null

      • getDate

        default java.time.LocalDate getDate​(java.lang.String name,
                                    java.time.LocalDate defaultValue)
                             throws java.io.IOException,
                                    java.lang.InterruptedException,
                                    TsurugiTransactionException
        get value as date.
        Parameters:
        name - column name
        defaultValue - value to return if original value is null
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data

      • findDate

        @Nonnull
default java.util.Optional<java.time.LocalDate> findDate​(java.lang.String name)
                                                  throws java.io.IOException,
                                                         java.lang.InterruptedException,
                                                         TsurugiTransactionException
        get value as date.
        Parameters:
        name - column name
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data

      • getDateOrNull

        @Nullable
default java.time.LocalDate getDateOrNull​(java.lang.String name)
                                   throws java.io.IOException,
                                          java.lang.InterruptedException,
                                          TsurugiTransactionException
        get value as date.
        Parameters:
        name - column name
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data

      • getTime

        @Nonnull
default java.time.LocalTime getTime​(java.lang.String name)
                             throws java.io.IOException,
                                    java.lang.InterruptedException,
                                    TsurugiTransactionException
        get value as time.
        Parameters:
        name - column name
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data
        java.lang.NullPointerException - if value is null

      • getTime

        default java.time.LocalTime getTime​(java.lang.String name,
                                    java.time.LocalTime defaultValue)
                             throws java.io.IOException,
                                    java.lang.InterruptedException,
                                    TsurugiTransactionException
        get value as time.
        Parameters:
        name - column name
        defaultValue - value to return if original value is null
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data

      • findTime

        @Nonnull
default java.util.Optional<java.time.LocalTime> findTime​(java.lang.String name)
                                                  throws java.io.IOException,
                                                         java.lang.InterruptedException,
                                                         TsurugiTransactionException
        get value as time.
        Parameters:
        name - column name
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data

      • getTimeOrNull

        @Nullable
default java.time.LocalTime getTimeOrNull​(java.lang.String name)
                                   throws java.io.IOException,
                                          java.lang.InterruptedException,
                                          TsurugiTransactionException
        get value as time.
        Parameters:
        name - column name
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data

      • getDateTime

        @Nonnull
default java.time.LocalDateTime getDateTime​(java.lang.String name)
                                     throws java.io.IOException,
                                            java.lang.InterruptedException,
                                            TsurugiTransactionException
        get value as dateTime.
        Parameters:
        name - column name
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data
        java.lang.NullPointerException - if value is null

      • getDateTime

        default java.time.LocalDateTime getDateTime​(java.lang.String name,
                                            java.time.LocalDateTime defaultValue)
                                     throws java.io.IOException,
                                            java.lang.InterruptedException,
                                            TsurugiTransactionException
        get value as dateTime.
        Parameters:
        name - column name
        defaultValue - value to return if original value is null
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data

      • findDateTime

        @Nonnull
default java.util.Optional<java.time.LocalDateTime> findDateTime​(java.lang.String name)
                                                          throws java.io.IOException,
                                                                 java.lang.InterruptedException,
                                                                 TsurugiTransactionException
        get value as dateTime.
        Parameters:
        name - column name
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data

      • getDateTimeOrNull

        @Nullable
default java.time.LocalDateTime getDateTimeOrNull​(java.lang.String name)
                                           throws java.io.IOException,
                                                  java.lang.InterruptedException,
                                                  TsurugiTransactionException
        get value as dateTime.
        Parameters:
        name - column name
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data

      • getOffsetTime

        @Nonnull
default java.time.OffsetTime getOffsetTime​(java.lang.String name)
                                    throws java.io.IOException,
                                           java.lang.InterruptedException,
                                           TsurugiTransactionException
        get value as offset time.
        Parameters:
        name - column name
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data
        java.lang.NullPointerException - if value is null

      • getOffsetTime

        default java.time.OffsetTime getOffsetTime​(java.lang.String name,
                                           java.time.OffsetTime defaultValue)
                                    throws java.io.IOException,
                                           java.lang.InterruptedException,
                                           TsurugiTransactionException
        get value as offset time.
        Parameters:
        name - column name
        defaultValue - value to return if original value is null
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data

      • findOffsetTime

        @Nonnull
default java.util.Optional<java.time.OffsetTime> findOffsetTime​(java.lang.String name)
                                                         throws java.io.IOException,
                                                                java.lang.InterruptedException,
                                                                TsurugiTransactionException
        get value as offset time.
        Parameters:
        name - column name
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data

      • getOffsetTimeOrNull

        @Nullable
default java.time.OffsetTime getOffsetTimeOrNull​(java.lang.String name)
                                          throws java.io.IOException,
                                                 java.lang.InterruptedException,
                                                 TsurugiTransactionException
        get value as offset time.
        Parameters:
        name - column name
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data

      • getOffsetDateTime

        @Nonnull
default java.time.OffsetDateTime getOffsetDateTime​(java.lang.String name)
                                            throws java.io.IOException,
                                                   java.lang.InterruptedException,
                                                   TsurugiTransactionException
        get value as offset dateTime.
        Parameters:
        name - column name
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data
        java.lang.NullPointerException - if value is null

      • getOffsetDateTime

        default java.time.OffsetDateTime getOffsetDateTime​(java.lang.String name,
                                                   java.time.OffsetDateTime defaultValue)
                                            throws java.io.IOException,
                                                   java.lang.InterruptedException,
                                                   TsurugiTransactionException
        get value as offset dateTime.
        Parameters:
        name - column name
        defaultValue - value to return if original value is null
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data

      • findOffsetDateTime

        @Nonnull
default java.util.Optional<java.time.OffsetDateTime> findOffsetDateTime​(java.lang.String name)
                                                                 throws java.io.IOException,
                                                                        java.lang.InterruptedException,
                                                                        TsurugiTransactionException
        get value as offset dateTime.
        Parameters:
        name - column name
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data

      • getOffsetDateTimeOrNull

        @Nullable
default java.time.OffsetDateTime getOffsetDateTimeOrNull​(java.lang.String name)
                                                  throws java.io.IOException,
                                                         java.lang.InterruptedException,
                                                         TsurugiTransactionException
        get value as offset dateTime.
        Parameters:
        name - column name
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data

      • getZonedDateTime

        @Nonnull
default java.time.ZonedDateTime getZonedDateTime​(java.lang.String name,
                                                 @Nonnull
                                                 java.time.ZoneId zone)
                                          throws java.io.IOException,
                                                 java.lang.InterruptedException,
                                                 TsurugiTransactionException
        get value as zoned dateTime.
        Parameters:
        name - column name
        zone - time-zone
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data
        java.lang.NullPointerException - if value is null

      • getZonedDateTime

        default java.time.ZonedDateTime getZonedDateTime​(java.lang.String name,
                                                 @Nonnull
                                                 java.time.ZoneId zone,
                                                 java.time.ZonedDateTime defaultValue)
                                          throws java.io.IOException,
                                                 java.lang.InterruptedException,
                                                 TsurugiTransactionException
        get value as zoned dateTime.
        Parameters:
        name - column name
        zone - time-zone
        defaultValue - value to return if original value is null
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data

      • findZonedDateTime

        @Nonnull
default java.util.Optional<java.time.ZonedDateTime> findZonedDateTime​(java.lang.String name,
                                                                      @Nonnull
                                                                      java.time.ZoneId zone)
                                                               throws java.io.IOException,
                                                                      java.lang.InterruptedException,
                                                                      TsurugiTransactionException
        get value as zoned dateTime.
        Parameters:
        name - column name
        zone - time-zone
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data

      • getZonedDateTimeOrNull

        @Nullable
default java.time.ZonedDateTime getZonedDateTimeOrNull​(java.lang.String name,
                                                       @Nonnull
                                                       java.time.ZoneId zone)
                                                throws java.io.IOException,
                                                       java.lang.InterruptedException,
                                                       TsurugiTransactionException
        get value as zoned dateTime.
        Parameters:
        name - column name
        zone - time-zone
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data

      • getBlob

        @Nonnull
default TgBlobReference getBlob​(java.lang.String name)
                         throws java.io.IOException,
                                java.lang.InterruptedException,
                                TsurugiTransactionException
        get value as BLOB.
        Parameters:
        name - column name
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data
        java.lang.NullPointerException - if value is null
        Since:
        1.8.0

      • getBlob

        default TgBlobReference getBlob​(java.lang.String name,
                                TgBlobReference defaultValue)
                         throws java.io.IOException,
                                java.lang.InterruptedException,
                                TsurugiTransactionException
        get value as BLOB.
        Parameters:
        name - column name
        defaultValue - value to return if original value is null
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data
        Since:
        1.8.0

      • findBlob

        @Nonnull
default java.util.Optional<TgBlobReference> findBlob​(java.lang.String name)
                                              throws java.io.IOException,
                                                     java.lang.InterruptedException,
                                                     TsurugiTransactionException
        get value as BLOB.
        Parameters:
        name - column name
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data
        Since:
        1.8.0

      • getBlobOrNull

        @Nullable
default TgBlobReference getBlobOrNull​(java.lang.String name)
                               throws java.io.IOException,
                                      java.lang.InterruptedException,
                                      TsurugiTransactionException
        get value as BLOB.
        Parameters:
        name - column name
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data
        Since:
        1.8.0

      • getClob

        @Nonnull
default TgClobReference getClob​(java.lang.String name)
                         throws java.io.IOException,
                                java.lang.InterruptedException,
                                TsurugiTransactionException
        get value as CLOB.
        Parameters:
        name - column name
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data
        java.lang.NullPointerException - if value is null
        Since:
        1.8.0

      • getClob

        default TgClobReference getClob​(java.lang.String name,
                                TgClobReference defaultValue)
                         throws java.io.IOException,
                                java.lang.InterruptedException,
                                TsurugiTransactionException
        get value as CLOB.
        Parameters:
        name - column name
        defaultValue - value to return if original value is null
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data
        Since:
        1.8.0

      • findClob

        @Nonnull
default java.util.Optional<TgClobReference> findClob​(java.lang.String name)
                                              throws java.io.IOException,
                                                     java.lang.InterruptedException,
                                                     TsurugiTransactionException
        get value as CLOB.
        Parameters:
        name - column name
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data
        Since:
        1.8.0

      • getClobOrNull

        @Nullable
default TgClobReference getClobOrNull​(java.lang.String name)
                               throws java.io.IOException,
                                      java.lang.InterruptedException,
                                      TsurugiTransactionException
        get value as CLOB.
        Parameters:
        name - column name
        Returns:
        value
        Throws:
        java.io.IOException - if an I/O error occurs while retrieving the column data
        java.lang.InterruptedException - if interrupted while retrieving the column data
        TsurugiTransactionException - if server error occurs while retrieving the column data
        Since:
        1.8.0