Interface ResultSetProvider.Large

All Superinterfaces:
ResultSetProvider
Enclosing interface:
ResultSetProvider

public static interface ResultSetProvider.Large extends ResultSetProvider
Version of ResultSetProvider where the assignRowValues method accepting a long row count must be implemented, and the int version defaults to using it.
  • Nested Class Summary

    Nested classes/interfaces inherited from interface org.postgresql.pljava.ResultSetProvider

    ResultSetProvider.Large
  • Method Summary

    Modifier and Type
    Method
    Description
    default boolean
    assignRowValues(ResultSet receiver, int currentRow)
    Older version where currentRow is limited to the range of int.
    boolean
    assignRowValues(ResultSet receiver, long currentRow)
    This method is called once for each row that should be returned from a procedure that returns a set of rows.

    Methods inherited from interface org.postgresql.pljava.ResultSetProvider

    close
  • Method Details

    • assignRowValues

      boolean assignRowValues(ResultSet receiver, long currentRow) throws SQLException
      This method is called once for each row that should be returned from a procedure that returns a set of rows. The receiver is a SingleRowWriter instance that is used to capture the data for the row.

      If the return type is RECORD rather than a specific complex type, SQL requires a column definition list to follow any use of the function in a query. The ResultSetMetaData of receiver can be used here to learn the number, names, and types of the columns expected by the caller. (It can also be used in the case of a specific complex type, but in that case the names and types are probably already known.)

      Specified by:
      assignRowValues in interface ResultSetProvider
      Parameters:
      receiver - Receiver of values for the given row.
      currentRow - Row number, zero on the first call, incremented by one on each subsequent call.
      Returns:
      true if a new row was provided, false if not (end of data).
      Throws:
      SQLException
    • assignRowValues

      default boolean assignRowValues(ResultSet receiver, int currentRow) throws SQLException
      Description copied from interface: ResultSetProvider
      Older version where currentRow is limited to the range of int.
      Specified by:
      assignRowValues in interface ResultSetProvider
      Throws:
      SQLException