oracle.pg.rdbms.pgql

Class PgSchemaResultSet

java.lang.Object

oracle.pg.rdbms.pgql.PgqlResultSetImpl

oracle.pg.rdbms.pgql.PgSchemaResultSet

All Implemented Interfaces:

java.lang.AutoCloseable, java.lang.Iterable<oracle.pgql.lang.ResultAccess>, PgqlResultSet, oracle.pgql.lang.ResultAccess, oracle.pgql.lang.ResultSet<oracle.pgql.lang.ResultAccess>

public class PgSchemaResultSet
extends oracle.pg.rdbms.pgql.PgqlResultSetImpl

This class provides a ResultSet for a PGQL query execution. It uses a JDBC-style ResultSet approach for consuming the query result.

Method Summary

Modifier and Type	Method and Description
java.lang.Boolean	getBoolean(int elementIdx) Gets the value of the designated element by element index as a Boolean
java.lang.Boolean	getBoolean(java.lang.String elementName) Gets the value of the designated element by element name as a Boolean
java.lang.Double	getDouble(int elementIdx) Gets the value of the designated element by element index as a Double
java.lang.Double	getDouble(java.lang.String elementName) Gets the value of the designated element by element name as a Double
java.lang.Float	getFloat(int elementIdx) Gets the value of the designated element by element index as a Float
java.lang.Float	getFloat(java.lang.String elementName) Gets the value of the designated element by element name as a Float
java.lang.Integer	getInteger(int elementIdx) Gets the value of the designated element by element index as an Integer
java.lang.Integer	getInteger(java.lang.String elementName) Gets the value of the designated element by element name as an Integer
java.lang.Long	getLong(int elementIdx) Gets the value of the designated element by element index as a Long
java.lang.Long	getLong(java.lang.String elementName) Gets the value of the designated element by element name as a Long
oracle.pgql.lang.ResultSetMetaData	getMetaData() Retrieves the number and properties of this ResultSet object's columns.
java.lang.Object	getObject(int elementIdx) Gets the value of the designated element by element name as an Object
java.lang.Object	getObject(java.lang.String elementName) Gets the value of the designated element by element name as an Object
java.lang.String	getString(int elementIdx) Gets the value of the designated element by element index as a String
java.lang.String	getString(java.lang.String elementName) Gets the value of the designated element by element name as a String
java.time.OffsetDateTime	getTimestampWithTimezone(java.lang.String elementName) Gets the value of the designated element by element name as an OffsetDateTime
int	getValueType(int elementIdx) Returns the type of value for elements with PgqlColumnDescriptor.Type.VALUE column type.
int	getValueType(java.lang.String elementName) Returns the type of value for elements with PgqlColumnDescriptor.Type.VALUE column type.

Methods inherited from class oracle.pg.rdbms.pgql.PgqlResultSetImpl

absolute, afterLast, beforeFirst, close, first, getDate, getDate, getLegacyDate, getLegacyDate, getList, getList, getTime, getTime, getTimestamp, getTimestamp, getTimestampWithTimezone, getTimeWithTimezone, getTimeWithTimezone, getVertexLabels, getVertexLabels, iterator, last, next, previous, print, print, relative

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface oracle.pg.rdbms.pgql.PgqlResultSet

print, print

Methods inherited from interface java.lang.Iterable

forEach, spliterator

Method Detail

getBoolean

public java.lang.Boolean getBoolean(int elementIdx)
                             throws oracle.pgql.lang.PgqlException

Gets the value of the designated element by element index as a Boolean

Parameters:

elementIdx - element index

Returns:

Boolean

Throws:

oracle.pgql.lang.PgqlException

getBoolean

public java.lang.Boolean getBoolean(java.lang.String elementName)
                             throws oracle.pgql.lang.PgqlException

Gets the value of the designated element by element name as a Boolean

Parameters:

elementName - element name

Returns:

Boolean

Throws:

oracle.pgql.lang.PgqlException

getDouble

public java.lang.Double getDouble(int elementIdx)
                           throws oracle.pgql.lang.PgqlException

Gets the value of the designated element by element index as a Double

Parameters:

elementIdx - element index

Returns:

Double

Throws:

oracle.pgql.lang.PgqlException

getDouble

public java.lang.Double getDouble(java.lang.String elementName)
                           throws oracle.pgql.lang.PgqlException

Gets the value of the designated element by element name as a Double

Parameters:

elementName - element name

Returns:

Double

Throws:

oracle.pgql.lang.PgqlException

getFloat

public java.lang.Float getFloat(int elementIdx)
                         throws oracle.pgql.lang.PgqlException

Gets the value of the designated element by element index as a Float

Parameters:

elementIdx - element index

Returns:

Float

Throws:

oracle.pgql.lang.PgqlException

getFloat

public java.lang.Float getFloat(java.lang.String elementName)
                         throws oracle.pgql.lang.PgqlException

Gets the value of the designated element by element name as a Float

Parameters:

elementName - element name

Returns:

Float

Throws:

oracle.pgql.lang.PgqlException

getInteger

public java.lang.Integer getInteger(int elementIdx)
                             throws oracle.pgql.lang.PgqlException

Gets the value of the designated element by element index as an Integer

Parameters:

elementIdx - element index

Returns:

Integer

Throws:

oracle.pgql.lang.PgqlException

getInteger

public java.lang.Integer getInteger(java.lang.String elementName)
                             throws oracle.pgql.lang.PgqlException

Gets the value of the designated element by element name as an Integer

Parameters:

elementName - element name

Returns:

Integer

Throws:

oracle.pgql.lang.PgqlException

getLong

public java.lang.Long getLong(int elementIdx)
                       throws oracle.pgql.lang.PgqlException

Gets the value of the designated element by element index as a Long

Parameters:

elementIdx - element index

Returns:

Long

Throws:

oracle.pgql.lang.PgqlException

getLong

public java.lang.Long getLong(java.lang.String elementName)
                       throws oracle.pgql.lang.PgqlException

Gets the value of the designated element by element name as a Long

Parameters:

elementName - element name

Returns:

Long

Throws:

oracle.pgql.lang.PgqlException

getMetaData

public oracle.pgql.lang.ResultSetMetaData getMetaData()

Retrieves the number and properties of this ResultSet object's columns.

Returns:

the description of this ResultSet object's columns

getObject

public java.lang.Object getObject(int elementIdx)
                           throws oracle.pgql.lang.PgqlException

Gets the value of the designated element by element name as an Object

Parameters:

elementIdx - element index

Returns:

Object

Throws:

oracle.pgql.lang.PgqlException

getObject

public java.lang.Object getObject(java.lang.String elementName)
                           throws oracle.pgql.lang.PgqlException

Gets the value of the designated element by element name as an Object

Parameters:

elementName - element name

Returns:

Object

Throws:

oracle.pgql.lang.PgqlException

getString

public java.lang.String getString(int elementIdx)
                           throws oracle.pgql.lang.PgqlException

Gets the value of the designated element by element index as a String

Parameters:

elementIdx - element index

Returns:

String

Throws:

oracle.pgql.lang.PgqlException

getString

public java.lang.String getString(java.lang.String elementName)
                           throws oracle.pgql.lang.PgqlException

Gets the value of the designated element by element name as a String

Parameters:

elementName - element name

Returns:

String

Throws:

oracle.pgql.lang.PgqlException

getTimestampWithTimezone

public java.time.OffsetDateTime getTimestampWithTimezone(java.lang.String elementName)
                                                  throws oracle.pgql.lang.PgqlException

Gets the value of the designated element by element name as an OffsetDateTime

Parameters:

elementName - element name

Returns:

OffsetDateTime

Throws:

oracle.pgql.lang.PgqlException

getValueType

public int getValueType(int elementIdx)
                 throws oracle.pgql.lang.PgqlException

Returns the type of value for elements with PgqlColumnDescriptor.Type.VALUE column type. The returned values correspond to values in the T column of the PG relational schema.

Parameters:

elementIdx - element index

Returns:

the type of value

Throws:

oracle.pgql.lang.PgqlException - when an error occurs while retrieving the value type

getValueType

public int getValueType(java.lang.String elementName)
                 throws oracle.pgql.lang.PgqlException

Returns the type of value for elements with PgqlColumnDescriptor.Type.VALUE column type. The returned values correspond to values in the T column of the PG relational schema.

Parameters:

elementName - element name

Returns:

the type of value

Throws:

oracle.pgql.lang.PgqlException - when an error occurs while retrieving the value type