Package oracle.pgx.api

Interface PgxPreparedStatement

All Superinterfaces:

java.lang.AutoCloseable, oracle.pgql.lang.PreparedStatement, oracle.pgql.lang.spatial.STPreparedStatement

public interface PgxPreparedStatement
extends oracle.pgql.lang.PreparedStatement, oracle.pgql.lang.spatial.STPreparedStatement

Method Summary

Modifier and Type	Method	Description
boolean	execute()	Executes the PGQL statement in this PreparedStatement object, which may be any kind of PGQL statement.
PgxFuture<java.lang.Boolean>	executeAsync()	Executes the PGQL statement in this PreparedStatement object, which may be any kind of PGQL statement.
PgqlResultSet	executeQuery()	Blocking version of executeQueryAsync().
PgxFuture<PgqlResultSet>	executeQueryAsync()	Executes the PGQL query in this PgxPreparedStatement object and returns the PgqlResultSet object generated by the query.
PgqlResultSet	getResultSet()	Retrieves the current result as a ResultSet object.
PgxFuture<PgqlResultSet>	getResultSetAsync()	Retrieves the current result as a PgxFuture with the ResultSet object.

Methods inherited from interface oracle.pgql.lang.PreparedStatement

close, setArray, setBoolean, setDate, setDouble, setFloat, setInt, setLong, setString, setTime, setTimestamp, setTimestampWithTimezone, setTimeWithTimezone

Methods inherited from interface oracle.pgql.lang.spatial.STPreparedStatement

setPoint2D

Method Detail

executeQuery

PgqlResultSet executeQuery()
                    throws oracle.pgql.lang.PgqlException

Blocking version of executeQueryAsync(). Calls executeQueryAsync() and waits for the returned PgxFuture to complete.

Specified by:

executeQuery in interface oracle.pgql.lang.PreparedStatement

Throws:

oracle.pgql.lang.PgqlException - if the caller thread gets interrupted while waiting for completion or if any exception occurred during asynchronous execution. The actual exception will be nested.

executeQueryAsync

PgxFuture<PgqlResultSet> executeQueryAsync()

Executes the PGQL query in this PgxPreparedStatement object and returns the PgqlResultSet object generated by the query.

Returns:

a PgqlResultSet object that contains the data produced by the query; never null

execute

boolean execute()
         throws oracle.pgql.lang.PgqlException

Executes the PGQL statement in this PreparedStatement object, which may be any kind of PGQL statement.

Returns: a boolean to indicate the form of the first result: true in case of a SELECT query, false otherwise. In case of a SELECT query you must call the method getResultSet to retrieve the result.

Throws: PgqlException - if a server-side error occurs or this method is called on a closed Statement

Specified by:

execute in interface oracle.pgql.lang.PreparedStatement

Throws:

oracle.pgql.lang.PgqlException

executeAsync

PgxFuture<java.lang.Boolean> executeAsync()

Executes the PGQL statement in this PreparedStatement object, which may be any kind of PGQL statement.

Returns: A PgxFuture with a boolean to indicate the form of the first result: true in case of a SELECT query, false otherwise. In case of a SELECT query you must call the method getResultSet to retrieve the result.

Throws: PgqlException - if a server-side error occurs or this method is called on a closed Statement

getResultSet

PgqlResultSet getResultSet()
                    throws oracle.pgql.lang.PgqlException

Retrieves the current result as a ResultSet object. This method should be called only once per result.

Returns: current result as a ResultSet object or null if the query is not a SELECT query.

Throws: PgqlException - if a server-side error occurs or this method is called on a closed Statement

Specified by:

getResultSet in interface oracle.pgql.lang.PreparedStatement

Throws:

oracle.pgql.lang.PgqlException

getResultSetAsync

PgxFuture<PgqlResultSet> getResultSetAsync()
                                    throws oracle.pgql.lang.PgqlException

Retrieves the current result as a PgxFuture with the ResultSet object. This method should be called only once per result.

Returns: current result as a ResultSet object or null if the query is not a SELECT query.

Throws: PgqlException - if a server-side error occurs or this method is called on a closed Statement

Throws:

oracle.pgql.lang.PgqlException