oracle.pg.rdbms.pgql

Class PgqlResultSetImpl

java.lang.Object

oracle.pg.rdbms.pgql.PgqlResultSetImpl

All Implemented Interfaces:

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

public class PgqlResultSetImpl
extends java.lang.Object
implements PgqlResultSet

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
boolean	absolute(long row) Places the cursor to the given row number in this ResultSet object.
void	afterLast() Place the cursor after the last row.
void	beforeFirst() Place the cursor before the first row.
void	close() Closes the underlying JDBC ResultSet and Statement.
boolean	first() Moves the cursor to the first row in the result set.
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.time.LocalDate	getDate(int elementIdx) Gets the value of the designated element by element index as a LocalDate
java.time.LocalDate	getDate(java.lang.String elementName) Gets the value of the designated element by element name as a LocalDate
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.util.Date	getLegacyDate(int elementIdx) Gets the value of the designated element by element index as a Date
java.util.Date	getLegacyDate(java.lang.String elementName) Gets the value of the designated element by element name as a Date
<T> java.util.List<T>	getList(int elementIdx) Gets the value of the designated element by element index as a List
<T> java.util.List<T>	getList(java.lang.String elementName) Gets the value of the designated element by element name as a List
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.LocalTime	getTime(int elementIdx) Gets the value of the designated element by element index as a LocalTime
java.time.LocalTime	getTime(java.lang.String elementName) Gets the value of the designated element by element name as a LocalTime
java.time.LocalDateTime	getTimestamp(int elementIdx) Gets the value of the designated element by element index as a LocalDateTime
java.time.LocalDateTime	getTimestamp(java.lang.String elementName) Gets the value of the designated element by element name as a LocalDateTime
java.time.OffsetDateTime	getTimestampWithTimezone(int elementIdx) Gets the value of the designated element by element index as an OffsetDateTime
java.time.OffsetDateTime	getTimestampWithTimezone(java.lang.String elementName) Gets the value of the designated element by element name as an OffsetDateTime
java.time.OffsetTime	getTimeWithTimezone(int elementIdx) Gets the value of the designated element by element index as an OffsetTime
java.time.OffsetTime	getTimeWithTimezone(java.lang.String elementName) Gets the value of the designated element by element name as an OffsetTime
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.
java.util.Set<java.lang.String>	getVertexLabels(int elementIdx) Gets the value of the designated element by element index as vertex labels
java.util.Set<java.lang.String>	getVertexLabels(java.lang.String elementName) Gets the value of the designated element by element name as vertex labels
java.util.Iterator<PgqlResultSet>	iterator() Returns an iterator for this query result
boolean	last() Moves the cursor to the last row in the result set.
boolean	next() Moves the cursor forward one row from its current position.
boolean	previous() Moves the cursor to the previous row from its current position.
PgqlResultSet	print() Prints all results to System.out.
PgqlResultSet	print(java.io.PrintStream printStream, long numResults, int from) Same as PgqlResultSet.print(long, int) except that this method prints content to printStream.
boolean	relative(long rows) Moves the cursor a relative number of row with repect to the current position.

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

absolute

public boolean absolute(long row)
                 throws oracle.pgql.lang.PgqlException

Places the cursor to the given row number in this ResultSet object.

Specified by:

absolute in interface oracle.pgql.lang.ResultSet

Returns:

true if the cursor is moved to a position in the ResultSet object; false if the cursor is moved before the first or after the last row

Throws:

oracle.pgql.lang.PgqlException - if a connection error occurs or when this method is called on a closed result set

afterLast

public void afterLast()
               throws oracle.pgql.lang.PgqlException

Place the cursor after the last row.

Specified by:

afterLast in interface oracle.pgql.lang.ResultSet

Throws:

oracle.pgql.lang.PgqlException - if a connection error occurs or when this method is called on a closed result set

beforeFirst

public void beforeFirst()
                 throws oracle.pgql.lang.PgqlException

Place the cursor before the first row.

Specified by:

beforeFirst in interface oracle.pgql.lang.ResultSet

Throws:

oracle.pgql.lang.PgqlException - if a connection error occurs or when this method is called on a closed result set

close

public void close()
           throws oracle.pgql.lang.PgqlException

Closes the underlying JDBC ResultSet and Statement.

Specified by:

close in interface java.lang.AutoCloseable

Specified by:

close in interface PgqlResultSet

Specified by:

close in interface oracle.pgql.lang.ResultSet

Throws:

oracle.pgql.lang.PgqlException

first

public boolean first()
              throws oracle.pgql.lang.PgqlException

Moves the cursor to the first row in the result set.

Specified by:

first in interface oracle.pgql.lang.ResultSet

Returns:

false if there are no rows in the result set; true otherwise

Throws:

oracle.pgql.lang.PgqlException - if a connection error occurs or when this method is called on a closed result set

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

Specified by:

getBoolean in interface oracle.pgql.lang.ResultAccess

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

Specified by:

getBoolean in interface oracle.pgql.lang.ResultAccess

Parameters:

elementName - element name

Returns:

Boolean

Throws:

oracle.pgql.lang.PgqlException

getDate

public java.time.LocalDate getDate(int elementIdx)
                            throws oracle.pgql.lang.PgqlException

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

Specified by:

getDate in interface oracle.pgql.lang.ResultAccess

Parameters:

elementIdx - element index

Returns:

LocalDate

Throws:

oracle.pgql.lang.PgqlException

getDate

public java.time.LocalDate getDate(java.lang.String elementName)
                            throws oracle.pgql.lang.PgqlException

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

Specified by:

getDate in interface oracle.pgql.lang.ResultAccess

Parameters:

elementName - element name

Returns:

LocalDate

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

Specified by:

getDouble in interface oracle.pgql.lang.ResultAccess

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

Specified by:

getDouble in interface oracle.pgql.lang.ResultAccess

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

Specified by:

getFloat in interface oracle.pgql.lang.ResultAccess

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

Specified by:

getFloat in interface oracle.pgql.lang.ResultAccess

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

Specified by:

getInteger in interface oracle.pgql.lang.ResultAccess

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

Specified by:

getInteger in interface oracle.pgql.lang.ResultAccess

Parameters:

elementName - element name

Returns:

Integer

Throws:

oracle.pgql.lang.PgqlException

getLegacyDate

public java.util.Date getLegacyDate(int elementIdx)
                             throws oracle.pgql.lang.PgqlException

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

Specified by:

getLegacyDate in interface oracle.pgql.lang.ResultAccess

Parameters:

elementIdx - element index

Returns:

Date

Throws:

oracle.pgql.lang.PgqlException

getLegacyDate

public java.util.Date getLegacyDate(java.lang.String elementName)
                             throws oracle.pgql.lang.PgqlException

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

Specified by:

getLegacyDate in interface oracle.pgql.lang.ResultAccess

Parameters:

elementName - element name

Returns:

Date

Throws:

oracle.pgql.lang.PgqlException

getList

public <T> java.util.List<T> getList(int elementIdx)
                              throws oracle.pgql.lang.PgqlException

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

Specified by:

getList in interface oracle.pgql.lang.ResultAccess

Parameters:

elementIdx - element index

Returns:

List

Throws:

oracle.pgql.lang.PgqlException

getList

public <T> java.util.List<T> getList(java.lang.String elementName)
                              throws oracle.pgql.lang.PgqlException

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

Specified by:

getList in interface oracle.pgql.lang.ResultAccess

Parameters:

elementName - element name

Returns:

List

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

Specified by:

getLong in interface oracle.pgql.lang.ResultAccess

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

Specified by:

getLong in interface oracle.pgql.lang.ResultAccess

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.

Specified by:

getMetaData in interface oracle.pgql.lang.ResultSet

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

Specified by:

getObject in interface oracle.pgql.lang.ResultAccess

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

Specified by:

getObject in interface oracle.pgql.lang.ResultAccess

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

Specified by:

getString in interface oracle.pgql.lang.ResultAccess

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

Specified by:

getString in interface oracle.pgql.lang.ResultAccess

Parameters:

elementName - element name

Returns:

String

Throws:

oracle.pgql.lang.PgqlException

getTime

public java.time.LocalTime getTime(int elementIdx)
                            throws oracle.pgql.lang.PgqlException

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

Specified by:

getTime in interface oracle.pgql.lang.ResultAccess

Parameters:

elementIdx - element index

Returns:

LocalTime

Throws:

oracle.pgql.lang.PgqlException

getTime

public java.time.LocalTime getTime(java.lang.String elementName)
                            throws oracle.pgql.lang.PgqlException

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

Specified by:

getTime in interface oracle.pgql.lang.ResultAccess

Parameters:

elementName - element name

Returns:

LocalTime

Throws:

oracle.pgql.lang.PgqlException

getTimestamp

public java.time.LocalDateTime getTimestamp(int elementIdx)
                                     throws oracle.pgql.lang.PgqlException

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

Specified by:

getTimestamp in interface oracle.pgql.lang.ResultAccess

Parameters:

elementIdx - element index

Returns:

LocalDateTime

Throws:

oracle.pgql.lang.PgqlException

getTimestamp

public java.time.LocalDateTime getTimestamp(java.lang.String elementName)
                                     throws oracle.pgql.lang.PgqlException

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

Specified by:

getTimestamp in interface oracle.pgql.lang.ResultAccess

Parameters:

elementName - element name

Returns:

LocalDateTime

Throws:

oracle.pgql.lang.PgqlException

getTimestampWithTimezone

public java.time.OffsetDateTime getTimestampWithTimezone(int elementIdx)
                                                  throws oracle.pgql.lang.PgqlException

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

Specified by:

getTimestampWithTimezone in interface oracle.pgql.lang.ResultAccess

Parameters:

elementIdx - element index

Returns:

OffsetDateTime

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

Specified by:

getTimestampWithTimezone in interface oracle.pgql.lang.ResultAccess

Parameters:

elementName - element name

Returns:

OffsetDateTime

Throws:

oracle.pgql.lang.PgqlException

getTimeWithTimezone

public java.time.OffsetTime getTimeWithTimezone(int elementIdx)
                                         throws oracle.pgql.lang.PgqlException

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

Specified by:

getTimeWithTimezone in interface oracle.pgql.lang.ResultAccess

Parameters:

elementIdx - element index

Returns:

OffsetTime

Throws:

oracle.pgql.lang.PgqlException

getTimeWithTimezone

public java.time.OffsetTime getTimeWithTimezone(java.lang.String elementName)
                                         throws oracle.pgql.lang.PgqlException

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

Specified by:

getTimeWithTimezone in interface oracle.pgql.lang.ResultAccess

Parameters:

elementName - element name

Returns:

OffsetTime

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.

Specified by:

getValueType in interface PgqlResultSet

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.

Specified by:

getValueType in interface PgqlResultSet

Parameters:

elementName - element name

Returns:

the type of value

Throws:

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

getVertexLabels

public java.util.Set<java.lang.String> getVertexLabels(int elementIdx)
                                                throws oracle.pgql.lang.PgqlException

Gets the value of the designated element by element index as vertex labels

Specified by:

getVertexLabels in interface oracle.pgql.lang.ResultAccess

Parameters:

elementIdx - element index

Returns:

vertex labels

Throws:

oracle.pgql.lang.PgqlException

getVertexLabels

public java.util.Set<java.lang.String> getVertexLabels(java.lang.String elementName)
                                                throws oracle.pgql.lang.PgqlException

Gets the value of the designated element by element name as vertex labels

Specified by:

getVertexLabels in interface oracle.pgql.lang.ResultAccess

Parameters:

elementName - element name

Returns:

vertex labels

Throws:

oracle.pgql.lang.PgqlException

iterator

public java.util.Iterator<PgqlResultSet> iterator()

Returns an iterator for this query result

Specified by:

iterator in interface java.lang.Iterable

Returns:

an iterator query result

last

public boolean last()
             throws oracle.pgql.lang.PgqlException

Moves the cursor to the last row in the result set.

Specified by:

last in interface oracle.pgql.lang.ResultSet

Returns:

false if there are no rows in the result set; true otherwise

Throws:

oracle.pgql.lang.PgqlException - if a connection error occurs or when this method is called on a closed result set

next

public boolean next()
             throws oracle.pgql.lang.PgqlException

Moves the cursor forward one row from its current position.

Specified by:

next in interface oracle.pgql.lang.ResultSet

Returns:

true if the new current row is valid; false if the new cursor is positioned after the last row

Throws:

oracle.pgql.lang.PgqlException - if a connection error occurs or when this method is called on a closed result set

previous

public boolean previous()
                 throws oracle.pgql.lang.PgqlException

Moves the cursor to the previous row from its current position.

Specified by:

previous in interface oracle.pgql.lang.ResultSet

Returns:

true if the new current row is valid; false if the new cursor is positioned before the first row

Throws:

oracle.pgql.lang.PgqlException - if a connection error occurs or when this method is called on a closed result set

print

public PgqlResultSet print()

Prints all results to System.out.

Specified by:

print in interface PgqlResultSet

Returns:

PgqlResultSet

print

public PgqlResultSet print(java.io.PrintStream printStream,
                           long numResults,
                           int from)

Same as PgqlResultSet.print(long, int) except that this method prints content to printStream.

Specified by:

print in interface PgqlResultSet

Parameters:

printStream - stream to which results are printed

numResults - number of results

from - first result to be printed (start counting from 0)

Returns:

PgqlResultSet

relative

public boolean relative(long rows)
                 throws oracle.pgql.lang.PgqlException

Moves the cursor a relative number of row with repect to the current position. A negative number will move the cursor backwards.

Specified by:

relative in interface oracle.pgql.lang.ResultSet

Returns:

true if the cursor is moved to a position in the ResultSet object; false if the cursor is moved before the first or after the last row

Throws:

oracle.pgql.lang.PgqlException - if a connection error occurs or when this method is called on a closed result set