public class OraclePgqlExecution extends java.lang.Object implements OraclePgqlPreparedStatement
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.
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.
|
public void close() throws java.sql.SQLException
close
in interface java.lang.AutoCloseable
close
in interface OraclePgqlStatement
java.sql.SQLException
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
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.
executeQuery
in interface OraclePgqlPreparedStatement
timeout
- the number of seconds for query execution to finishparallel
- the degree of parallelism to use for query executionqueryID
- the query IDdynamicSampling
- the value for dynamic samplingmaxResults
- the maximum number of rows returnedoptions
- additional options used to influence query translation and executionOraclePgqlResultSet
object with the result of the provided PGQL queryPgqlToSqlException
oracle.pgql.lang.PgqlException
java.sql.SQLException
public OraclePgqlResultSet executeQuery(java.lang.String options) throws PgqlToSqlException, oracle.pgql.lang.PgqlException, java.sql.SQLException
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.
executeQuery
in interface OraclePgqlPreparedStatement
options
- additional options used to influence query translation and executionOraclePgqlResultSet
object with the result of the provided PGQL queryPgqlToSqlException
oracle.pgql.lang.PgqlException
java.sql.SQLException
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
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.
executeQuery
in interface OraclePgqlStatement
pgql
- the PGQL query to executetimeout
- the number of seconds for query execution to finishparallel
- the degree of parallelism to use for query executionqueryID
- the query IDdynamicSampling
- the value for dynamic samplingmaxResults
- the maximum number of rows returnedoptions
- additional options used to influence query translation and executionOraclePgqlResultSet
object with the result of the provided PGQL queryPgqlToSqlException
oracle.pgql.lang.PgqlException
java.sql.SQLException
public OraclePgqlResultSet executeQuery(java.lang.String pgql, java.lang.String options) throws PgqlToSqlException, oracle.pgql.lang.PgqlException, java.sql.SQLException
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.
executeQuery
in interface OraclePgqlStatement
pgql
- the PGQL query to executeoptions
- additional options used to influence query translation and executionOraclePgqlResultSet
object with the result of the provided PGQL queryPgqlToSqlException
oracle.pgql.lang.PgqlException
java.sql.SQLException
public int getFetchSize()
getFetchSize
in interface OraclePgqlStatement
public void setBoolean(int parameterIndex, boolean x)
setBoolean
in interface OraclePgqlPreparedStatement
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter valuepublic void setDouble(int parameterIndex, double x)
setDouble
in interface OraclePgqlPreparedStatement
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter valuepublic void setFetchSize(int fetchSize)
setFetchSize
in interface OraclePgqlStatement
fetchSize
- the query fetch sizepublic void setFloat(int parameterIndex, float x)
setFloat
in interface OraclePgqlPreparedStatement
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter valuepublic void setInt(int parameterIndex, int x)
setInt
in interface OraclePgqlPreparedStatement
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter valuepublic void setLong(int parameterIndex, long x)
setLong
in interface OraclePgqlPreparedStatement
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter valuepublic void setString(int parameterIndex, java.lang.String x)
setString
in interface OraclePgqlPreparedStatement
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter valuepublic void setTimestamp(int parameterIndex, java.sql.Timestamp x)
Timestamp values are assumed to be in Coordinated Universal Time (UTC).
setTimestamp
in interface OraclePgqlPreparedStatement
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter valuepublic OraclePgqlSqlTrans translateQuery(int parallel, int dynamicSampling, int maxResults, java.lang.String options) throws PgqlToSqlException, oracle.pgql.lang.PgqlException
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.
translateQuery
in interface OraclePgqlPreparedStatement
parallel
- the degree of parallelism to use for query executiondynamicSampling
- the value for dynamic samplingmaxResults
- the maximum number of rows returnedoptions
- additional options used to influence query translationOraclePgqlSqlTrans
object with the SQL translation and column metadata for the provided PGQL queryPgqlToSqlException
oracle.pgql.lang.PgqlException
public OraclePgqlSqlTrans translateQuery(java.lang.String options) throws PgqlToSqlException, oracle.pgql.lang.PgqlException
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.
translateQuery
in interface OraclePgqlPreparedStatement
options
- additional options used to influence query translationOraclePgqlSqlTrans
object with the SQL translation and column metadata for the provided PGQL queryPgqlToSqlException
oracle.pgql.lang.PgqlException
public OraclePgqlSqlTrans translateQuery(java.lang.String pgql, int parallel, int dynamicSampling, int maxResults, java.lang.String options) throws PgqlToSqlException, oracle.pgql.lang.PgqlException
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.
translateQuery
in interface OraclePgqlStatement
pgql
- the PGQL query to translateparallel
- the degree of parallelism to use for query executiondynamicSampling
- the value for dynamic samplingmaxResults
- the maximum number of rows returnedoptions
- additional options used to influence query translationOraclePgqlSqlTrans
object with the SQL translation and column metadata for the provided PGQL queryPgqlToSqlException
oracle.pgql.lang.PgqlException
public OraclePgqlSqlTrans translateQuery(java.lang.String pgql, java.lang.String options) throws PgqlToSqlException, oracle.pgql.lang.PgqlException
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.
translateQuery
in interface OraclePgqlStatement
pgql
- the PGQL query to translateoptions
- additional options used to influence query translationOraclePgqlSqlTrans
object with the SQL translation and column metadata for the provided PGQL queryPgqlToSqlException
oracle.pgql.lang.PgqlException
Copyright © 2017, 2018 Oracle and/or its affiliates. All Rights Reserved.