ResultsetRow packet

A ResultsetRow packet contains one row in a result set.

The value of columns can usually be accessed directly, e.g.: context.packet.first_name. However, if the row contains more than one column with a given name, you may need to use getColumnValue and setColumnValue instead.

Properties

  • int sequenceId: the sequence ID for the packet.

  • String packetType: always "ResultsetRow" - read-only.

  • List<ColumnDefinitionPacket> columnDefinitions: the column definitions for the result set.


Methods

  • Object getColumnValue(String schema, String table, String column): returns the value of the specified column in the row

  • void setColumnValue(String schema, String table, String column, Object newValue): sets the value of the specified column.

  • ColumnDefinitionPacket getColumnDefinitionByName(String schema, String table, String column): returns the column definition for the specified column

  • ColumnDefinitionPacket addColumnDefinition(): adds a new column definition to the result set

  • ColumnDefinitionPacket removeColumnDefinition(String schema, String table, String column): removes the specified column definition

  • Object clone(): creates a copy of this row. This is most often used to insert a new row in a result set.