oracle.pg.rdbms

Class OraclePgqlExecution

java.lang.Object

oracle.pg.rdbms.OraclePgqlExecution

All Implemented Interfaces:

java.lang.AutoCloseable, OraclePgqlPreparedStatement, OraclePgqlStatement

public class OraclePgqlExecution
extends java.lang.Object
implements OraclePgqlPreparedStatement

This class implements the OraclePgqlStatement and OraclePgqlPreparedStatement interfaces for executing PGQL queries against graphs stored in Oracle Database.

Refer to the documentation of these interfaces for further explanation and sample code.

Method Summary

Modifier and Type	Method and Description
void	close() Releases this OraclePgqlStatment's database and JDBC resources.
OraclePgqlResultSet	executeQuery(int timeout, int parallel, long queryID, int dynamicSampling, int maxResults, java.lang.String options) Translates this instance's PGQL statement into a SQL statement and executes the SQL against this instance's property graph.
OraclePgqlResultSet	executeQuery(java.lang.String options) Translates this instance's PGQL statement into a SQL statement and executes the SQL against this instance's property graph.
OraclePgqlResultSet	executeQuery(java.lang.String pgql, int timeout, int parallel, long queryID, int dynamicSampling, int maxResults, java.lang.String options) Translates this instance's PGQL statement into a SQL statement and executes the SQL against this instance's property graph.
OraclePgqlResultSet	executeQuery(java.lang.String pgql, java.lang.String options) Translates this instance's PGQL statement into a SQL statement and executes the SQL against this instance's property graph.
int	getFetchSize() Returns the the number of rows that should be fetched from the database when more rows are needed for a query result.
void	setBoolean(int parameterIndex, boolean x) Sets the designated parameter to the given Java boolean value.
void	setDouble(int parameterIndex, double x) Sets the designated parameter to the given Java double value.
void	setFetchSize(int fetchSize) Sets the number of rows that should be fetched from the database when more rows are needed for a query result.
void	setFloat(int parameterIndex, float x) Sets the designated parameter to the given Java float value.
void	setInt(int parameterIndex, int x) Sets the designated parameter to the given Java int value.
void	setLong(int parameterIndex, long x) Sets the designated parameter to the given Java long value.
void	setString(int parameterIndex, java.lang.String x) Sets the designated parameter to the given Java String value.
void	setTimestamp(int parameterIndex, java.sql.Timestamp x) Sets the designated parameter to the given Java Timestamp value.
OraclePgqlSqlTrans	translateQuery(int parallel, int dynamicSampling, int maxResults, java.lang.String options) Translates this instance's PGQL statement into a SQL statement.
OraclePgqlSqlTrans	translateQuery(java.lang.String options) Translates this instance's PGQL statement into a SQL statement.
OraclePgqlSqlTrans	translateQuery(java.lang.String pgql, int parallel, int dynamicSampling, int maxResults, java.lang.String options) Translates this instance's PGQL statement into a SQL statement.
OraclePgqlSqlTrans	translateQuery(java.lang.String pgql, java.lang.String options) Translates this instance's PGQL statement into a SQL statement.

Methods inherited from class java.lang.Object

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

Method Detail

close

public void close()
           throws java.sql.SQLException

Releases this OraclePgqlStatment's database and JDBC resources. Closing this OraclePgqlStatement will close all OraclePgqlResultSets that were created from it.

Specified by:

close in interface java.lang.AutoCloseable

Specified by:

close in interface OraclePgqlStatement

Throws:

java.sql.SQLException

executeQuery

public OraclePgqlResultSet executeQuery(int timeout,
                                        int parallel,
                                        long queryID,
                                        int dynamicSampling,
                                        int maxResults,
                                        java.lang.String options)
                                 throws PgqlToSqlException,
                                        oracle.pgql.lang.PgqlException,
                                        java.sql.SQLException

Translates this instance's PGQL statement into a SQL statement and executes the SQL against this instance's property graph.

Supported query options are:

USE_GT_TAB=T Use the GRAPH_NAMEGT$ table instead of the GRAPH_NAMEGE$ table for evaluating edge traversals.

USE_RW=F Use CONNECT BY instead of recursive WITH for unbounded path traversals.

MAX_PATH_LEN=n Traverse at most n hops when evaluating unbounded path traversals.

EDGE_SET_PARTIAL=T Fetch properties for each start and end vertex found when reading edges from the query result.

Specified by:

executeQuery in interface OraclePgqlPreparedStatement

Parameters:

timeout - the number of seconds for query execution to finish

parallel - the degree of parallelism to use for query execution

queryID - the query ID

dynamicSampling - the value for dynamic sampling

maxResults - the maximum number of rows returned

options - additional options used to influence query translation and execution

Returns:

a OraclePgqlResultSet object with the result of the provided PGQL query

Throws:

PgqlToSqlException

oracle.pgql.lang.PgqlException

java.sql.SQLException

executeQuery

public OraclePgqlResultSet executeQuery(java.lang.String options)
                                 throws PgqlToSqlException,
                                        oracle.pgql.lang.PgqlException,
                                        java.sql.SQLException

Translates this instance's PGQL statement into a SQL statement and executes the SQL against this instance's property graph.

Supported query options are:

USE_GT_TAB=T Use the GRAPH_NAMEGT$ table instead of the GRAPH_NAMEGE$ table for evaluating edge traversals.

USE_RW=F Use CONNECT BY instead of recursive WITH for unbounded path traversals.

MAX_PATH_LEN=n Traverse at most n hops when evaluating unbounded path traversals.

EDGE_SET_PARTIAL=T Fetch properties for each start and end vertex found when reading edges from the query result.

Specified by:

executeQuery in interface OraclePgqlPreparedStatement

Parameters:

options - additional options used to influence query translation and execution

Returns:

a OraclePgqlResultSet object with the result of the provided PGQL query

Throws:

PgqlToSqlException

oracle.pgql.lang.PgqlException

java.sql.SQLException

executeQuery

public OraclePgqlResultSet executeQuery(java.lang.String pgql,
                                        int timeout,
                                        int parallel,
                                        long queryID,
                                        int dynamicSampling,
                                        int maxResults,
                                        java.lang.String options)
                                 throws PgqlToSqlException,
                                        oracle.pgql.lang.PgqlException,
                                        java.sql.SQLException

Translates this instance's PGQL statement into a SQL statement and executes the SQL against this instance's property graph.

Supported query options are:

USE_GT_TAB=T Use the GRAPH_NAMEGT$ table instead of the GRAPH_NAMEGE$ table for evaluating edge traversals.

USE_RW=F Use CONNECT BY instead of recursive WITH for unbounded path traversals.

MAX_PATH_LEN=n Traverse at most n hops when evaluating unbounded path traversals.

EDGE_SET_PARTIAL=T Fetch properties for each start and end vertex found when reading edges from the query result.

Specified by:

executeQuery in interface OraclePgqlStatement

Parameters:

pgql - the PGQL query to execute

timeout - the number of seconds for query execution to finish

parallel - the degree of parallelism to use for query execution

queryID - the query ID

dynamicSampling - the value for dynamic sampling

maxResults - the maximum number of rows returned

options - additional options used to influence query translation and execution

Returns:

a OraclePgqlResultSet object with the result of the provided PGQL query

Throws:

PgqlToSqlException

oracle.pgql.lang.PgqlException

java.sql.SQLException

executeQuery

public OraclePgqlResultSet executeQuery(java.lang.String pgql,
                                        java.lang.String options)
                                 throws PgqlToSqlException,
                                        oracle.pgql.lang.PgqlException,
                                        java.sql.SQLException

Translates this instance's PGQL statement into a SQL statement and executes the SQL against this instance's property graph.

Supported query options are:

USE_GT_TAB=T Use the GRAPH_NAMEGT$ table instead of the GRAPH_NAMEGE$ table for evaluating edge traversals.

USE_RW=F Use CONNECT BY instead of recursive WITH for unbounded path traversals.

MAX_PATH_LEN=n Traverse at most n hops when evaluating unbounded path traversals.

EDGE_SET_PARTIAL=T Fetch properties for each start and end vertex found when reading edges from the query result.

Specified by:

executeQuery in interface OraclePgqlStatement

Parameters:

pgql - the PGQL query to execute

options - additional options used to influence query translation and execution

Returns:

a OraclePgqlResultSet object with the result of the provided PGQL query

Throws:

PgqlToSqlException

oracle.pgql.lang.PgqlException

java.sql.SQLException

getFetchSize

public int getFetchSize()

Returns the the number of rows that should be fetched from the database when more rows are needed for a query result.

Specified by:

getFetchSize in interface OraclePgqlStatement

Returns:

the query fetch size

setBoolean

public void setBoolean(int parameterIndex,
                       boolean x)

Sets the designated parameter to the given Java boolean value.

Specified by:

setBoolean in interface OraclePgqlPreparedStatement

Parameters:

parameterIndex - the first parameter is 1, the second is 2, ...

x - the parameter value

setDouble

public void setDouble(int parameterIndex,
                      double x)

Sets the designated parameter to the given Java double value.

Specified by:

setDouble in interface OraclePgqlPreparedStatement

Parameters:

parameterIndex - the first parameter is 1, the second is 2, ...

x - the parameter value

setFetchSize

public void setFetchSize(int fetchSize)

Sets the number of rows that should be fetched from the database when more rows are needed for a query result.

Specified by:

setFetchSize in interface OraclePgqlStatement

Parameters:

fetchSize - the query fetch size

setFloat

public void setFloat(int parameterIndex,
                     float x)

Sets the designated parameter to the given Java float value.

Specified by:

setFloat in interface OraclePgqlPreparedStatement

Parameters:

parameterIndex - the first parameter is 1, the second is 2, ...

x - the parameter value

setInt

public void setInt(int parameterIndex,
                   int x)

Sets the designated parameter to the given Java int value.

Specified by:

setInt in interface OraclePgqlPreparedStatement

Parameters:

parameterIndex - the first parameter is 1, the second is 2, ...

x - the parameter value

setLong

public void setLong(int parameterIndex,
                    long x)

Sets the designated parameter to the given Java long value.

Specified by:

setLong in interface OraclePgqlPreparedStatement

Parameters:

parameterIndex - the first parameter is 1, the second is 2, ...

x - the parameter value

setString

public void setString(int parameterIndex,
                      java.lang.String x)

Sets the designated parameter to the given Java String value.

Specified by:

setString in interface OraclePgqlPreparedStatement

Parameters:

parameterIndex - the first parameter is 1, the second is 2, ...

x - the parameter value

setTimestamp

public void setTimestamp(int parameterIndex,
                         java.sql.Timestamp x)

Sets the designated parameter to the given Java Timestamp value.

Timestamp values are assumed to be in Coordinated Universal Time (UTC).

Specified by:

setTimestamp in interface OraclePgqlPreparedStatement

Parameters:

parameterIndex - the first parameter is 1, the second is 2, ...

x - the parameter value

translateQuery

public OraclePgqlSqlTrans translateQuery(int parallel,
                                         int dynamicSampling,
                                         int maxResults,
                                         java.lang.String options)
                                  throws PgqlToSqlException,
                                         oracle.pgql.lang.PgqlException

Translates this instance's PGQL statement into a SQL statement.

Supported query options are:

USE_GT_TAB=T Use the GRAPH_NAMEGT$ table instead of the GRAPH_NAMEGE$ table for evaluating edge traversals.

USE_RW=F Use CONNECT BY instead of recursive WITH for unbounded path traversals.

MAX_PATH_LEN=n Traverse at most n hops when evaluating unbounded path traversals.

EDGE_SET_PARTIAL=T Fetch properties for each start and end vertex found when reading edges from the query result.

Specified by:

translateQuery in interface OraclePgqlPreparedStatement

Parameters:

parallel - the degree of parallelism to use for query execution

dynamicSampling - the value for dynamic sampling

maxResults - the maximum number of rows returned

options - additional options used to influence query translation

Returns:

a OraclePgqlSqlTrans object with the SQL translation and column metadata for the provided PGQL query

Throws:

PgqlToSqlException

oracle.pgql.lang.PgqlException

translateQuery

public OraclePgqlSqlTrans translateQuery(java.lang.String options)
                                  throws PgqlToSqlException,
                                         oracle.pgql.lang.PgqlException

Translates this instance's PGQL statement into a SQL statement.

Supported query options are:

USE_GT_TAB=T Use the GRAPH_NAMEGT$ table instead of the GRAPH_NAMEGE$ table for evaluating edge traversals.

USE_RW=F Use CONNECT BY instead of recursive WITH for unbounded path traversals.

MAX_PATH_LEN=n Traverse at most n hops when evaluating unbounded path traversals.

EDGE_SET_PARTIAL=T Fetch properties for each start and end vertex found when reading edges from the query result.

Specified by:

translateQuery in interface OraclePgqlPreparedStatement

Parameters:

options - additional options used to influence query translation

Returns:

a OraclePgqlSqlTrans object with the SQL translation and column metadata for the provided PGQL query

Throws:

PgqlToSqlException

oracle.pgql.lang.PgqlException

translateQuery

public OraclePgqlSqlTrans translateQuery(java.lang.String pgql,
                                         int parallel,
                                         int dynamicSampling,
                                         int maxResults,
                                         java.lang.String options)
                                  throws PgqlToSqlException,
                                         oracle.pgql.lang.PgqlException

Translates this instance's PGQL statement into a SQL statement.

Supported query options are:

USE_GT_TAB=T Use the GRAPH_NAMEGT$ table instead of the GRAPH_NAMEGE$ table for evaluating edge traversals.

USE_RW=F Use CONNECT BY instead of recursive WITH for unbounded path traversals.

MAX_PATH_LEN=n Traverse at most n hops when evaluating unbounded path traversals.

EDGE_SET_PARTIAL=T Fetch properties for each start and end vertex found when reading edges from the query result.

Specified by:

translateQuery in interface OraclePgqlStatement

Parameters:

pgql - the PGQL query to translate

parallel - the degree of parallelism to use for query execution

dynamicSampling - the value for dynamic sampling

maxResults - the maximum number of rows returned

options - additional options used to influence query translation

Returns:

a OraclePgqlSqlTrans object with the SQL translation and column metadata for the provided PGQL query

Throws:

PgqlToSqlException

oracle.pgql.lang.PgqlException

translateQuery

public OraclePgqlSqlTrans translateQuery(java.lang.String pgql,
                                         java.lang.String options)
                                  throws PgqlToSqlException,
                                         oracle.pgql.lang.PgqlException

Translates this instance's PGQL statement into a SQL statement.

Supported query options are:

USE_GT_TAB=T Use the GRAPH_NAMEGT$ table instead of the GRAPH_NAMEGE$ table for evaluating edge traversals.

USE_RW=F Use CONNECT BY instead of recursive WITH for unbounded path traversals.

MAX_PATH_LEN=n Traverse at most n hops when evaluating unbounded path traversals.

EDGE_SET_PARTIAL=T Fetch properties for each start and end vertex found when reading edges from the query result.

Specified by:

translateQuery in interface OraclePgqlStatement

Parameters:

pgql - the PGQL query to translate

options - additional options used to influence query translation

Returns:

a OraclePgqlSqlTrans object with the SQL translation and column metadata for the provided PGQL query

Throws:

PgqlToSqlException

oracle.pgql.lang.PgqlException